2023年6月21日发(作者：)

⽤winform程序简单的开发⼀个超市管理系统，实现增删改查主页using System;using c;using entModel;using ;using g;using ;using ;using ;using ;namespace AdvancedFiltration{ public partial class manageSystem : Form { Form Head;//头部的⼦窗体 public manageSystem() { InitializeComponent(); } private void ManageSystem_Load(object sender, EventArgs e) {

} private void Label1_Click(object sender, EventArgs e) { } ///

///

进⼊⽤户管理页⾯ ///

/// /// private void BtnUser_Click(object sender, EventArgs e) { e = false;//该窗⼝隐藏 userManage um = new userManage();//实例化⽤户管理窗⼝ ();//显⽰⽤户管理窗⼝ } /// ///

进⼊⽤户管理页⾯ ///

/// /// private void BtnCustomer_Click(object sender, EventArgs e) { e = false;//该窗⼝隐藏 customerManage cm = new customerManage();//实例化客户管理窗⼝ ();//显⽰⽤户管理窗⼝ } /// ///

进⼊订单管理页⾯ ///

/// /// private void BtnOrder_Click(object sender, EventArgs e) { e = false;//该窗⼝隐藏 orderManage om = new orderManage();//实例化客户管理窗⼝ ();//显⽰⽤户管理窗⼝ } /// ///

退出系统 ///

/// /// private void BtnExit_Click(object sender, EventArgs e) { ();//关闭整个系统 } }}1.⽤户管理界⾯using System;using c;using entModel;using ;using g;using ;using ;using ;using ;namespace AdvancedFiltration{ public partial class userManage : Form public partial class userManage : Form { public userManage() { InitializeComponent(); } /// ///

根据⽤户名称，查询数据库 ///

/// /// private void BtnUserFind_Click(object sender, EventArgs e) { string strSql = ("select * from userManage where userName = '{0}'", ); AdoHelp ah = new AdoHelp();//实例化SQL操作辅助类 DataSet ds = eQueryDataSet(strSql);//执⾏查询语句，返回DataSet集合 urce = [0]; } /// ///在DataGridView中修改，并更新到数据库 /// /// /// private void DataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { string strColumn = s[Index].HeaderText;//获取列标题 string strRow = [ex].Cells[0].ng();//获取焦点触发⾏的第⼀个值,⼀般来说，都是表的主键 string ColumnValue = ng();//获取当前点击的活动单元格的值 //定义SQL语⾔ string strSql = ("update userManage set {0} = '{1}' where userId = {2}", strColumn, ColumnValue, strRow); AdoHelp ah = new AdoHelp();//实例化SQL增删改查辅助类对象 int result = eNonQuery(strSql);//增删改操作，返回受影响的值 if (result > 0) { ("修改成功！"); } else { ("修改失败！"); } } /// ///

返回⾸页 ///

/// /// private void Label2_Click(object sender, EventArgs e) { e = false;//隐藏本页⾯（⽤户管理） manageSystem ms = new manageSystem();//实例化管理系统页⾯ ();//显⽰管理系统界⾯ } //进⼊添加数据页⾯ private void BtnAddTo_Click(object sender, EventArgs e) { e = false;//隐藏当前页⾯（⽤户管理页⾯） AddUserForm auf = new AddUserForm();//实例化添加⽤户窗⼝ ();//显⽰此窗⼝ } /// ///

删除选中的单元⾏数据 ///

/// /// private void BtnUserDelete_Click(object sender, EventArgs e) { { //serToAddRows = false;//删除最后⼀⾏的空⽩⾏ //(tRow);//删除当前光标所在⾏

//();//删除所有⾏

string value = edCells[0].ng();//获取选中单元格的值 //获取所选中的单元格的列名 string column = s[Index].HeaderText; DialogResult dr = ("是否删除此条数据", "警告", el, ation); if(dr == ) { //定义SQL删除指令 string strSql = ("delete from userManage where {0} = '{1}'", column, value); AdoHelp ah = new AdoHelp();//实例化SQL增删改查辅助类对象 int result = eNonQuery(strSql);//返回受影响的⾏数 if (result > 0) { ("删除成功"); (tRow);//删除当前光标所在⾏

} else { ("删除失败"); } } else { ("已取消操作"); }

} ///

///

查询⽤户管理表的全部数据 ///

/// /// private void BtnSelectUserAll_Click(object sender, EventArgs e) { string strSql = "select * from userManage"; AdoHelp ah = new AdoHelp();//实例化类 DataSet ds = eQueryDataSet(strSql); urce = [0]; //实例化DataSet集合输出到Excel对象 dataSetToExcel dte = new dataSetToExcel(); tToExcel(ds, true);//输出到Excel } }}1.1添加⽤户页⾯using System;using c;using entModel;using ;using ent;using g;using ;using ;using ;using ;namespace AdvancedFiltration{ public partial class AddUserForm : Form { public AddUserForm() { InitializeComponent(); } /// ///

添加⽤户数据 ///

/// /// private void BtnAddUser_Click(object sender, EventArgs e) { string userId = ;//获取编号 string userName = ;//获取名称 string userSex = ;//获取性别 string userAge = ;//获取年龄 string userPhone = ;//获取电话 string userAddress = ;//获取地址 string userJurisdiction = ;//获取权限 //(userId + "-" + userName + "-" + userSex + "-" + userAge + "-" + userPhone + "-" + userAddress + "-" + userJurisdiction); //编写插⼊SQL语句 string strSql = "insert into userManage values (@userId, @userName, @userSex, @userAge, @userPhone, @userAddress, @userJurisdiction)"; //注意：@这⾥都不要加引号，如果⽤的是才需要 //创建输⼊参数数组 SqlParameter[] paras = new SqlParameter[] { { new SqlParameter("@userId", userId), new SqlParameter("@userName", userName), new SqlParameter("@userSex", userSex), new SqlParameter("@userAge", userAge), new SqlParameter("@userPhone", userPhone), new SqlParameter("@userAddress", userAddress), new SqlParameter("@userJurisdiction", userJurisdiction), }; AdoHelp ah = new AdoHelp();//实例化sql增删改查辅助类 int result = eNonQuery(strSql, paras);//返回受影响的函数 if(result > 0) { ("成功添加数据"); //清空数据 = "";//获取编号 = "";//获取名称 = "";//获取性别 = "";//获取年龄 = "";//获取电话 = "";//获取地址 = "";//获取权限 } else { ("添加数据失败"); } } //前往⾸页 private void Label8_Click(object sender, EventArgs e) { e = false;//隐藏当前页⾯ manageSystem ms = new manageSystem();//实例化管理系统窗⼝ ();//显⽰窗⼝ } //回到⽤户管理页⾯ private void Label9_Click(object sender, EventArgs e) { e = false;//隐藏当前页⾯ userManage um = new userManage();//实例化⽤户管理页⾯ ();//显⽰页⾯ } }}看完这⼀个⽤户管理就可以了，后⾯的代码都差不多2.客户管理界⾯using System;using c;using entModel;using ;using g;using ;using ;using ;using ;namespace AdvancedFiltration{ public partial class customerManage : Form { public customerManage() { InitializeComponent(); } /// ///

根据客户名称，查询数据库 ///

/// /// private void BtnSelectCustomerName_Click(object sender, EventArgs e) { string strSql = ("select * from customerManage where customerName = '{0}'", ); AdoHelp ah = new AdoHelp();//实例化SQL操作辅助类 DataSet ds = eQueryDataSet(strSql);//执⾏查询语句，返回DataSet集合 urce = [0]; } /// ///

进⼊添加数据页⾯ ///

/// /// private void BtnAddCustomer_Click(object sender, EventArgs e) { e = false;//隐藏当前页⾯（⽤户管理页⾯） AddCustomer ac = new AddCustomer();//实例化添加客户窗⼝ ();//显⽰此窗⼝ } /// ///

在dataGridView⾥修改数据 ///

/// /// private void DataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { string strColumn = s[Index].HeaderText;//获取列标题 string strRow = [ex].Cells[0].ng();//获取焦点触发⾏的第⼀个值,⼀般来说，都是表的主键 string ColumnValue = ng();//获取当前点击的活动单元格的值 //定义SQL语⾔ string strSql = ("update customerManage set {0} = '{1}' where customerId = {2}", strColumn, ColumnValue, strRow); AdoHelp ah = new AdoHelp();//实例化SQL增删改查辅助类对象 int result = eNonQuery(strSql);//增删改操作，返回受影响的值 if (result > 0) { ("修改成功！"); } else { ("修改失败！"); } } /// ///

删除客户 ///

/// /// private void BtnDeleteCustomer_Click(object sender, EventArgs e) { string value = edCells[0].ng();//获取选中单元格的值 //获取所选中的单元格的列名 string column = s[Index].HeaderText; DialogResult dr = ("是否删除此条数据", "警告", el, ation); if (dr == ) { //定义SQL删除指令 string strSql = ("delete from customerManage where {0} = '{1}'", column, value); AdoHelp ah = new AdoHelp();//实例化SQL增删改查辅助类对象 int result = eNonQuery(strSql);//返回受影响的⾏数 if (result > 0) { ("删除成功"); (tRow);//删除当前光标所在⾏

} else { ("删除失败"); } } else { ("已取消操作"); } } ///

///

查询全部客户数据 ///

/// /// private void BtnSelectAllCustomer_Click(object sender, EventArgs e) { string strSql = "select * from customerManage"; AdoHelp ah = new AdoHelp();//实例化类 DataSet ds = eQueryDataSet(strSql); urce = [0]; //实例化DataSet集合输出到Excel对象 dataSetToExcel dte = new dataSetToExcel(); tToExcel(ds, true);//输出到Excel } /// ///

返回⾸页 ///

/// /// private void Label1_Click(object sender, EventArgs e) { e = false;//隐藏本页⾯（客户管理） manageSystem ms = new manageSystem();//实例化管理系统页⾯ ();//显⽰管理系统界⾯ } private void DataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { } }}2.2添加客户using System;using c;using entModel;using ;using ent;using g;using ;using ;using ;using ;namespace AdvancedFiltration{ public partial class AddUserForm : Form public partial class AddUserForm : Form { public AddUserForm() { InitializeComponent(); } /// ///

添加⽤户数据 ///

/// /// private void BtnAddUser_Click(object sender, EventArgs e) { string userId = ;//获取编号 string userName = ;//获取名称 string userSex = ;//获取性别 string userAge = ;//获取年龄 string userPhone = ;//获取电话 string userAddress = ;//获取地址 string userJurisdiction = ;//获取权限 //(userId + "-" + userName + "-" + userSex + "-" + userAge + "-" + userPhone + "-" + userAddress + "-" + userJurisdiction); //编写插⼊SQL语句 string strSql = "insert into userManage values (@userId, @userName, @userSex, @userAge, @userPhone, @userAddress, @userJurisdiction)"; //注意：@这⾥都不要加引号，如果⽤的是才需要 //创建输⼊参数数组 SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@userId", userId), new SqlParameter("@userName", userName), new SqlParameter("@userSex", userSex), new SqlParameter("@userAge", userAge), new SqlParameter("@userPhone", userPhone), new SqlParameter("@userAddress", userAddress), new SqlParameter("@userJurisdiction", userJurisdiction), }; AdoHelp ah = new AdoHelp();//实例化sql增删改查辅助类 int result = eNonQuery(strSql, paras);//返回受影响的函数 if(result > 0) { ("成功添加数据"); //清空数据 = "";//获取编号 = "";//获取名称 = "";//获取性别 = "";//获取年龄 = "";//获取电话 = "";//获取地址 = "";//获取权限 } else { ("添加数据失败"); } } //前往⾸页 private void Label8_Click(object sender, EventArgs e) { e = false;//隐藏当前页⾯ manageSystem ms = new manageSystem();//实例化管理系统窗⼝ ();//显⽰窗⼝ } //回到⽤户管理页⾯ private void Label9_Click(object sender, EventArgs e) { e = false;//隐藏当前页⾯ userManage um = new userManage();//实例化⽤户管理页⾯ userManage um = new userManage();//实例化⽤户管理页⾯ ();//显⽰页⾯ } }}3.订单管理using System;using c;using entModel;using ;using g;using ;using ;using ;using ;namespace AdvancedFiltration{ public partial class orderManage : Form { public orderManage() { InitializeComponent(); } /// ///

返回⾸页 ///

/// /// private void Label1_Click(object sender, EventArgs e) { e = false;//隐藏本页⾯（订单管理） manageSystem ms = new manageSystem();//实例化管理系统页⾯ ();//显⽰管理系统界⾯ } /// ///

根据订单名称，查询订单 ///

/// /// /// private void BtnSelectOrderName_Click(object sender, EventArgs e) { string strSql = ("select * from orderManage where orderName = '{0}'", ); AdoHelp ah = new AdoHelp();//实例化SQL操作辅助类 DataSet ds = eQueryDataSet(strSql);//执⾏查询语句，返回DataSet集合 urce = [0]; } /// ///

去添加数据页⾯ ///

/// /// private void BtnToAddOrder_Click(object sender, EventArgs e) { e = false;//隐藏当前页⾯（订单管理页⾯） AddOrder ao = new AddOrder();//实例化添加订单窗⼝ ();//显⽰此窗⼝ } /// ///

删除订单 ///

/// /// private void BtnDeleteOrder_Click(object sender, EventArgs e) { string value = edCells[0].ng();//获取选中单元格的值 //获取所选中的单元格的列名 string column = s[Index].HeaderText; DialogResult dr = ("是否删除此条数据", "警告", el, ation); if (dr == ) { //定义SQL删除指令 string strSql = ("delete from orderManage where {0} = '{1}'", column, value); AdoHelp ah = new AdoHelp();//实例化SQL增删改查辅助类对象 int result = eNonQuery(strSql);//返回受影响的⾏数 if (result > 0) { ("删除成功"); (tRow);//删除当前光标所在⾏

} else { ("删除失败"); } } else { ("已取消操作"); } } ///

///

查询所有订单 ///

/// /// private void BtnSelectAllOrder_Click(object sender, EventArgs e) { string strSql = "select * from orderManage"; AdoHelp ah = new AdoHelp();//实例化类 DataSet ds = eQueryDataSet(strSql); urce = [0]; //实例化DataSet集合输出到Excel对象 dataSetToExcel dte = new dataSetToExcel(); tToExcel(ds, true);//输出到Excel } } /// ///

单元格修改，修改数据库数据 ///

/// /// private void DataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { string strColumn = s[Index].HeaderText;//获取列标题 string strRow = [ex].Cells[0].ng();//获取焦点触发⾏的第⼀个值,⼀般来说，都是表的主键 string ColumnValue = ng();//获取当前点击的活动单元格的值 //定义SQL语⾔ string strSql = ("update orderManage set {0} = '{1}' where orderId = {2}", strColumn, ColumnValue, strRow); AdoHelp ah = new AdoHelp();//实例化SQL增删改查辅助类对象 int result = eNonQuery(strSql);//增删改操作，返回受影响的值 if (result > 0) { ("修改成功！"); } else { ("修改失败！"); } } private void DataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) {

} private void OrderManage_Load(object sender, EventArgs e) { } ///

///

把订单管理表插⼊到oMana表中 ///

/// /// private void Label3_Click(object sender, EventArgs e) { string strSql = "EXEC ser";//执⾏存储过程ser AdoHelp ah = new AdoHelp();//实例化类 int result = eNonQuery(strSql); if(result > 0) { ("插⼊成功"); string str = "select * from oMana"; DataSet ds = eQueryDataSet(str);//查询oMana表 urce = [0]; } else { ("插⼊失败"); } } }}

2023年6月21日发(作者：)

⽤winform程序简单的开发⼀个超市管理系统，实现增删改查主页using System;using c;using entModel;using ;using g;using ;using ;using ;using ;namespace AdvancedFiltration{ public partial class manageSystem : Form { Form Head;//头部的⼦窗体 public manageSystem() { InitializeComponent(); } private void ManageSystem_Load(object sender, EventArgs e) {

} private void Label1_Click(object sender, EventArgs e) { } ///

///

进⼊⽤户管理页⾯ ///

/// /// private void BtnUser_Click(object sender, EventArgs e) { e = false;//该窗⼝隐藏 userManage um = new userManage();//实例化⽤户管理窗⼝ ();//显⽰⽤户管理窗⼝ } /// ///

进⼊⽤户管理页⾯ ///

/// /// private void BtnCustomer_Click(object sender, EventArgs e) { e = false;//该窗⼝隐藏 customerManage cm = new customerManage();//实例化客户管理窗⼝ ();//显⽰⽤户管理窗⼝ } /// ///

进⼊订单管理页⾯ ///

/// /// private void BtnOrder_Click(object sender, EventArgs e) { e = false;//该窗⼝隐藏 orderManage om = new orderManage();//实例化客户管理窗⼝ ();//显⽰⽤户管理窗⼝ } /// ///

退出系统 ///

/// /// private void BtnExit_Click(object sender, EventArgs e) { ();//关闭整个系统 } }}1.⽤户管理界⾯using System;using c;using entModel;using ;using g;using ;using ;using ;using ;namespace AdvancedFiltration{ public partial class userManage : Form public partial class userManage : Form { public userManage() { InitializeComponent(); } /// ///

根据⽤户名称，查询数据库 ///

/// /// private void BtnUserFind_Click(object sender, EventArgs e) { string strSql = ("select * from userManage where userName = '{0}'", ); AdoHelp ah = new AdoHelp();//实例化SQL操作辅助类 DataSet ds = eQueryDataSet(strSql);//执⾏查询语句，返回DataSet集合 urce = [0]; } /// ///在DataGridView中修改，并更新到数据库 /// /// /// private void DataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { string strColumn = s[Index].HeaderText;//获取列标题 string strRow = [ex].Cells[0].ng();//获取焦点触发⾏的第⼀个值,⼀般来说，都是表的主键 string ColumnValue = ng();//获取当前点击的活动单元格的值 //定义SQL语⾔ string strSql = ("update userManage set {0} = '{1}' where userId = {2}", strColumn, ColumnValue, strRow); AdoHelp ah = new AdoHelp();//实例化SQL增删改查辅助类对象 int result = eNonQuery(strSql);//增删改操作，返回受影响的值 if (result > 0) { ("修改成功！"); } else { ("修改失败！"); } } /// ///

返回⾸页 ///

/// /// private void Label2_Click(object sender, EventArgs e) { e = false;//隐藏本页⾯（⽤户管理） manageSystem ms = new manageSystem();//实例化管理系统页⾯ ();//显⽰管理系统界⾯ } //进⼊添加数据页⾯ private void BtnAddTo_Click(object sender, EventArgs e) { e = false;//隐藏当前页⾯（⽤户管理页⾯） AddUserForm auf = new AddUserForm();//实例化添加⽤户窗⼝ ();//显⽰此窗⼝ } /// ///

删除选中的单元⾏数据 ///

/// /// private void BtnUserDelete_Click(object sender, EventArgs e) { { //serToAddRows = false;//删除最后⼀⾏的空⽩⾏ //(tRow);//删除当前光标所在⾏

//();//删除所有⾏

string value = edCells[0].ng();//获取选中单元格的值 //获取所选中的单元格的列名 string column = s[Index].HeaderText; DialogResult dr = ("是否删除此条数据", "警告", el, ation); if(dr == ) { //定义SQL删除指令 string strSql = ("delete from userManage where {0} = '{1}'", column, value); AdoHelp ah = new AdoHelp();//实例化SQL增删改查辅助类对象 int result = eNonQuery(strSql);//返回受影响的⾏数 if (result > 0) { ("删除成功"); (tRow);//删除当前光标所在⾏

} else { ("删除失败"); } } else { ("已取消操作"); }

} ///

///

查询⽤户管理表的全部数据 ///

/// /// private void BtnSelectUserAll_Click(object sender, EventArgs e) { string strSql = "select * from userManage"; AdoHelp ah = new AdoHelp();//实例化类 DataSet ds = eQueryDataSet(strSql); urce = [0]; //实例化DataSet集合输出到Excel对象 dataSetToExcel dte = new dataSetToExcel(); tToExcel(ds, true);//输出到Excel } }}1.1添加⽤户页⾯using System;using c;using entModel;using ;using ent;using g;using ;using ;using ;using ;namespace AdvancedFiltration{ public partial class AddUserForm : Form { public AddUserForm() { InitializeComponent(); } /// ///

添加⽤户数据 ///

/// /// private void BtnAddUser_Click(object sender, EventArgs e) { string userId = ;//获取编号 string userName = ;//获取名称 string userSex = ;//获取性别 string userAge = ;//获取年龄 string userPhone = ;//获取电话 string userAddress = ;//获取地址 string userJurisdiction = ;//获取权限 //(userId + "-" + userName + "-" + userSex + "-" + userAge + "-" + userPhone + "-" + userAddress + "-" + userJurisdiction); //编写插⼊SQL语句 string strSql = "insert into userManage values (@userId, @userName, @userSex, @userAge, @userPhone, @userAddress, @userJurisdiction)"; //注意：@这⾥都不要加引号，如果⽤的是才需要 //创建输⼊参数数组 SqlParameter[] paras = new SqlParameter[] { { new SqlParameter("@userId", userId), new SqlParameter("@userName", userName), new SqlParameter("@userSex", userSex), new SqlParameter("@userAge", userAge), new SqlParameter("@userPhone", userPhone), new SqlParameter("@userAddress", userAddress), new SqlParameter("@userJurisdiction", userJurisdiction), }; AdoHelp ah = new AdoHelp();//实例化sql增删改查辅助类 int result = eNonQuery(strSql, paras);//返回受影响的函数 if(result > 0) { ("成功添加数据"); //清空数据 = "";//获取编号 = "";//获取名称 = "";//获取性别 = "";//获取年龄 = "";//获取电话 = "";//获取地址 = "";//获取权限 } else { ("添加数据失败"); } } //前往⾸页 private void Label8_Click(object sender, EventArgs e) { e = false;//隐藏当前页⾯ manageSystem ms = new manageSystem();//实例化管理系统窗⼝ ();//显⽰窗⼝ } //回到⽤户管理页⾯ private void Label9_Click(object sender, EventArgs e) { e = false;//隐藏当前页⾯ userManage um = new userManage();//实例化⽤户管理页⾯ ();//显⽰页⾯ } }}看完这⼀个⽤户管理就可以了，后⾯的代码都差不多2.客户管理界⾯using System;using c;using entModel;using ;using g;using ;using ;using ;using ;namespace AdvancedFiltration{ public partial class customerManage : Form { public customerManage() { InitializeComponent(); } /// ///

根据客户名称，查询数据库 ///

/// /// private void BtnSelectCustomerName_Click(object sender, EventArgs e) { string strSql = ("select * from customerManage where customerName = '{0}'", ); AdoHelp ah = new AdoHelp();//实例化SQL操作辅助类 DataSet ds = eQueryDataSet(strSql);//执⾏查询语句，返回DataSet集合 urce = [0]; } /// ///

进⼊添加数据页⾯ ///

/// /// private void BtnAddCustomer_Click(object sender, EventArgs e) { e = false;//隐藏当前页⾯（⽤户管理页⾯） AddCustomer ac = new AddCustomer();//实例化添加客户窗⼝ ();//显⽰此窗⼝ } /// ///

在dataGridView⾥修改数据 ///

/// /// private void DataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { string strColumn = s[Index].HeaderText;//获取列标题 string strRow = [ex].Cells[0].ng();//获取焦点触发⾏的第⼀个值,⼀般来说，都是表的主键 string ColumnValue = ng();//获取当前点击的活动单元格的值 //定义SQL语⾔ string strSql = ("update customerManage set {0} = '{1}' where customerId = {2}", strColumn, ColumnValue, strRow); AdoHelp ah = new AdoHelp();//实例化SQL增删改查辅助类对象 int result = eNonQuery(strSql);//增删改操作，返回受影响的值 if (result > 0) { ("修改成功！"); } else { ("修改失败！"); } } /// ///

删除客户 ///

/// /// private void BtnDeleteCustomer_Click(object sender, EventArgs e) { string value = edCells[0].ng();//获取选中单元格的值 //获取所选中的单元格的列名 string column = s[Index].HeaderText; DialogResult dr = ("是否删除此条数据", "警告", el, ation); if (dr == ) { //定义SQL删除指令 string strSql = ("delete from customerManage where {0} = '{1}'", column, value); AdoHelp ah = new AdoHelp();//实例化SQL增删改查辅助类对象 int result = eNonQuery(strSql);//返回受影响的⾏数 if (result > 0) { ("删除成功"); (tRow);//删除当前光标所在⾏

} else { ("删除失败"); } } else { ("已取消操作"); } } ///

///

查询全部客户数据 ///

/// /// private void BtnSelectAllCustomer_Click(object sender, EventArgs e) { string strSql = "select * from customerManage"; AdoHelp ah = new AdoHelp();//实例化类 DataSet ds = eQueryDataSet(strSql); urce = [0]; //实例化DataSet集合输出到Excel对象 dataSetToExcel dte = new dataSetToExcel(); tToExcel(ds, true);//输出到Excel } /// ///

返回⾸页 ///

/// /// private void Label1_Click(object sender, EventArgs e) { e = false;//隐藏本页⾯（客户管理） manageSystem ms = new manageSystem();//实例化管理系统页⾯ ();//显⽰管理系统界⾯ } private void DataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { } }}2.2添加客户using System;using c;using entModel;using ;using ent;using g;using ;using ;using ;using ;namespace AdvancedFiltration{ public partial class AddUserForm : Form public partial class AddUserForm : Form { public AddUserForm() { InitializeComponent(); } /// ///

添加⽤户数据 ///

/// /// private void BtnAddUser_Click(object sender, EventArgs e) { string userId = ;//获取编号 string userName = ;//获取名称 string userSex = ;//获取性别 string userAge = ;//获取年龄 string userPhone = ;//获取电话 string userAddress = ;//获取地址 string userJurisdiction = ;//获取权限 //(userId + "-" + userName + "-" + userSex + "-" + userAge + "-" + userPhone + "-" + userAddress + "-" + userJurisdiction); //编写插⼊SQL语句 string strSql = "insert into userManage values (@userId, @userName, @userSex, @userAge, @userPhone, @userAddress, @userJurisdiction)"; //注意：@这⾥都不要加引号，如果⽤的是才需要 //创建输⼊参数数组 SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@userId", userId), new SqlParameter("@userName", userName), new SqlParameter("@userSex", userSex), new SqlParameter("@userAge", userAge), new SqlParameter("@userPhone", userPhone), new SqlParameter("@userAddress", userAddress), new SqlParameter("@userJurisdiction", userJurisdiction), }; AdoHelp ah = new AdoHelp();//实例化sql增删改查辅助类 int result = eNonQuery(strSql, paras);//返回受影响的函数 if(result > 0) { ("成功添加数据"); //清空数据 = "";//获取编号 = "";//获取名称 = "";//获取性别 = "";//获取年龄 = "";//获取电话 = "";//获取地址 = "";//获取权限 } else { ("添加数据失败"); } } //前往⾸页 private void Label8_Click(object sender, EventArgs e) { e = false;//隐藏当前页⾯ manageSystem ms = new manageSystem();//实例化管理系统窗⼝ ();//显⽰窗⼝ } //回到⽤户管理页⾯ private void Label9_Click(object sender, EventArgs e) { e = false;//隐藏当前页⾯ userManage um = new userManage();//实例化⽤户管理页⾯ userManage um = new userManage();//实例化⽤户管理页⾯ ();//显⽰页⾯ } }}3.订单管理using System;using c;using entModel;using ;using g;using ;using ;using ;using ;namespace AdvancedFiltration{ public partial class orderManage : Form { public orderManage() { InitializeComponent(); } /// ///

返回⾸页 ///

/// /// private void Label1_Click(object sender, EventArgs e) { e = false;//隐藏本页⾯（订单管理） manageSystem ms = new manageSystem();//实例化管理系统页⾯ ();//显⽰管理系统界⾯ } /// ///

根据订单名称，查询订单 ///

/// /// /// private void BtnSelectOrderName_Click(object sender, EventArgs e) { string strSql = ("select * from orderManage where orderName = '{0}'", ); AdoHelp ah = new AdoHelp();//实例化SQL操作辅助类 DataSet ds = eQueryDataSet(strSql);//执⾏查询语句，返回DataSet集合 urce = [0]; } /// ///

去添加数据页⾯ ///

/// /// private void BtnToAddOrder_Click(object sender, EventArgs e) { e = false;//隐藏当前页⾯（订单管理页⾯） AddOrder ao = new AddOrder();//实例化添加订单窗⼝ ();//显⽰此窗⼝ } /// ///

删除订单 ///

/// /// private void BtnDeleteOrder_Click(object sender, EventArgs e) { string value = edCells[0].ng();//获取选中单元格的值 //获取所选中的单元格的列名 string column = s[Index].HeaderText; DialogResult dr = ("是否删除此条数据", "警告", el, ation); if (dr == ) { //定义SQL删除指令 string strSql = ("delete from orderManage where {0} = '{1}'", column, value); AdoHelp ah = new AdoHelp();//实例化SQL增删改查辅助类对象 int result = eNonQuery(strSql);//返回受影响的⾏数 if (result > 0) { ("删除成功"); (tRow);//删除当前光标所在⾏

} else { ("删除失败"); } } else { ("已取消操作"); } } ///

///

查询所有订单 ///

/// /// private void BtnSelectAllOrder_Click(object sender, EventArgs e) { string strSql = "select * from orderManage"; AdoHelp ah = new AdoHelp();//实例化类 DataSet ds = eQueryDataSet(strSql); urce = [0]; //实例化DataSet集合输出到Excel对象 dataSetToExcel dte = new dataSetToExcel(); tToExcel(ds, true);//输出到Excel } } /// ///

单元格修改，修改数据库数据 ///

/// /// private void DataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { string strColumn = s[Index].HeaderText;//获取列标题 string strRow = [ex].Cells[0].ng();//获取焦点触发⾏的第⼀个值,⼀般来说，都是表的主键 string ColumnValue = ng();//获取当前点击的活动单元格的值 //定义SQL语⾔ string strSql = ("update orderManage set {0} = '{1}' where orderId = {2}", strColumn, ColumnValue, strRow); AdoHelp ah = new AdoHelp();//实例化SQL增删改查辅助类对象 int result = eNonQuery(strSql);//增删改操作，返回受影响的值 if (result > 0) { ("修改成功！"); } else { ("修改失败！"); } } private void DataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) {

} private void OrderManage_Load(object sender, EventArgs e) { } ///

///

把订单管理表插⼊到oMana表中 ///

/// /// private void Label3_Click(object sender, EventArgs e) { string strSql = "EXEC ser";//执⾏存储过程ser AdoHelp ah = new AdoHelp();//实例化类 int result = eNonQuery(strSql); if(result > 0) { ("插⼊成功"); string str = "select * from oMana"; DataSet ds = eQueryDataSet(str);//查询oMana表 urce = [0]; } else { ("插⼊失败"); } } }}