1500字范文 > c#窗体点餐系统使用sql server 数据库保存数据

c#窗体点餐系统使用sql server 数据库保存数据

时间：2023-12-09 09:22:34

登录界面

using System;using System.Collections.Generic;using ponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;using System.Data.SqlClient;using System.IO;using ;namespace Dian_chai_system{public partial class 注册界面 : Form{public 注册界面(){InitializeComponent();}private void button1_Click(object sender, EventArgs e){string SqlStr = "Server=LAPTOP-NGTPLSQG;User Id=sa;Pwd=123456;DataBase=用户信息数据库";SqlConnection conn = new SqlConnection(SqlStr);//数据库连接conn.Open();//打开数据库if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "") {MessageBox.Show("请不要遗漏信息！");}if ((textBox3.Text == textBox4.Text)&&textBox3.Text!=""){string strsql = "insert into text(手机号,用户名,密码) values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "')";SqlCommand comm = new SqlCommand(strsql, conn);if (conn.State == ConnectionState.Closed){conn.Open();}try{if (Convert.ToInt32(comm.ExecuteNonQuery()) > 0){登录界面 form1 = new 登录界面();MessageBox.Show("注册成功！");form1.Show();this.Hide();}else{登录界面 form1 = new 登录界面();MessageBox.Show("注册失败！");form1.Show();this.Hide();}}catch (SqlException ex){MessageBox.Show(ex.ToString());}finally{conn.Close();//关闭数据库连接conn.Dispose();//释放数据库连接}}if(textBox3.Text!=textBox4.Text) {MessageBox.Show("密码不一致，请重新输入");}}private void button2_Click(object sender, EventArgs e){if (!CallPhone(textBox1.Text.ToString())){MessageBox.Show("发送失败！");}else{MessageBox.Show("发送成功！");}}private bool CallPhone(string Recipient_Mobile_Num){string PostUrl = "/webservice/sms.php?method=Submit";//登录“互亿无线网站”查看用户名登录用户中心->验证码通知短信>产品总览->API接口信息->APIIDstring account = "C63753195";//登录“互亿无线网站”查看密码登录用户中心->验证码通知短信>产品总览->API接口信息->APIKEYstring password = "38d578a70b772cc944d5561eccc917b1";//接收短信的用户的手机号码string mobile = Recipient_Mobile_Num;//随机生成四位数可以模仿向用户发送验证码Random rad = new Random();int mobile_code = rad.Next(1000, 10000); //生成随机数string content = "您的验证码是：" + mobile_code + "。请不要把验证码泄露给其他人。";string postStrTpl = "account={0}&password={1}&mobile={2}&content={3}"; //用户名+密码+注册的手机号+验证码UTF8Encoding encoding = new UTF8Encoding(); //万国码//将 account, password, mobile, content 这四个内容添加到postStrTpl字符串当中//并利用encoding.GetBytes()将括号里面的字符串转化为二进制类型byte[] postData = encoding.GetBytes(string.Format(postStrTpl, account, password, mobile, content)); //将字符串postStrTpl中的格式项替换为四个个指定的 Object 实例的值的文本等效项。再转为二进制数据//新建一个请求对象HttpWebRequest myRequest = (HttpWebRequest)WebRequest.Create(PostUrl);//对统一资源标识符 (URI) 发出请求。这是一个 abstract 类。myRequest.Method = "POST";myRequest.ContentType = "application/x-www-form-urlencoded";myRequest.ContentLength = postData.Length;Stream newStream = myRequest.GetRequestStream();//间postData合并到 PostUrl中去newStream.Write(postData, 0, postData.Length);newStream.Flush();newStream.Close();//以/webservice/sms.php?method=Submit&account=你的APIID&password=你的APIKEY&mobile=接收短信的用户的手机号码&content=您的验证码是：" + mobile_code + " 。请不要把验证码泄露给其他人。" 发起https请求并获取请求结果HttpWebResponse myResponse = (HttpWebResponse)myRequest.GetResponse();if (myResponse.StatusCode == HttpStatusCode.OK){return true;}else{return false;//访问失败}}private void 注册界面_Load(object sender, EventArgs e){}}}

using System;using System.Collections.Generic;using ponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;using System.Data.SqlClient;namespace Dian_chai_system{public partial class 商家管理界面 : Form{SqlDataAdapter adapter = null;DataSet ds = null;public 商家管理界面(){InitializeComponent();}private void Form3_Load(object sender, EventArgs e){Show1();}private void Show1(){string SqlStr = "Server=LAPTOP-NGTPLSQG;User Id=sa;Pwd=123456;DataBase=用户信息数据库";//数据库连接SqlConnection conn = new SqlConnection(SqlStr);//打开数据库conn.Open();String sql = "select *from text3";//查询数据库后，将数据源绑定到dataGridView控件，使用数据集Datset 和适配器 DataAdapterds = new DataSet();adapter = new SqlDataAdapter(sql, conn);//将获取的数据填充到数据集ds中adapter.Fill(ds, "text3");//数据源绑定到dataGridViewdataGridView1.DataSource = ds.Tables["text3"];conn.Close();}private void 删除ToolStripMenuItem_Click(object sender, EventArgs e){int i = dataGridView1.CurrentRow.Index;string stuNo = dataGridView1.Rows[i].Cells["商品编号"].Value.ToString();string stuNo1 = dataGridView1.Rows[i].Cells["商品名称"].Value.ToString();string stuNo2 = dataGridView1.Rows[i].Cells["商品价格"].Value.ToString();DialogResult result = MessageBox.Show("确定要删除" + stuNo+stuNo1+stuNo2+ "的信息吗？", "提示信息", MessageBoxButtons.YesNo);if (result == DialogResult.Yes){string SqlStr = "Server=LAPTOP-NGTPLSQG;User Id=sa;Pwd=123456;DataBase=用户信息数据库";//数据库连接SqlConnection conn = new SqlConnection(SqlStr);//打开数据库conn.Open();string sql = "delete from text3 where 商品编号='" + stuNo + "'";SqlCommand command = new SqlCommand(sql,conn);int s= command.ExecuteNonQuery();if (s > 0){MessageBox.Show("删除成功！");Show1();}}}private void 商家管理界面_FormClosed(object sender, FormClosedEventArgs e){登录界面 s = new 登录界面();s.Show();this.Hide();}private void 订单信息ToolStripMenuItem_Click(object sender, EventArgs e){Form5 form5 = new Form5();form5.Show();this.Hide();}private void button1_Click_1(object sender, EventArgs e){DialogResult result = MessageBox.Show("确定要修改吗？", "提示信息", MessageBoxButtons.YesNo);if (result == DialogResult.Yes){//执行修改SqlCommandBuilder builder = new SqlCommandBuilder(adapter);//需要参数；适配器（具有数据源的）adapter.Update(ds, "text3");//要设置一个主键，不然报错。MessageBox.Show("修改成功!");Show1();}}private void 修改账号ToolStripMenuItem_Click(object sender, EventArgs e){商家账号修改页面 f = new 商家账号修改页面();f.Show();this.Hide();}}}

textBox1.Text + “’ and 商家密码=’” + textBox2.Text + “’”;

SqlCommand comm = new SqlCommand(strsql, conn);

int i= comm.ExecuteNonQuery();

//SqlDataReader sql = comm.ExecuteReader();

if (i>0)//满足用户名和密码一致

{

MessageBox.Show(“修改成功！”);

}

else

{

DialogResult dr = MessageBox.Show(“修改失败”);

this.Show();