//通过服务名称查询数据 public fuwuModel selectIteam(string name) { fuwuModel model = new fuwuModel(); string str; SqlParameter[] pms; //if (FilterClass.DianPu1.UserName.Trim()=="admin") //{ str = "select * from fuwuInfo where Name=@Name and DPName='" + FilterClass.DianPu1.UserName.Trim() + "' "; pms = new SqlParameter[] { new SqlParameter("@Name", name.Trim()) }; // } //else //{ // str = "select * from fuwuInfo where Name=@Name and DPName=@DPName"; // pms = new SqlParameter[] { //new SqlParameter("@Name",name.Trim()), //new SqlParameter("@DPName",FilterClass.DianPu1.UserName.Trim()) //}; //} SqlDataReader read = SqlHelper.ExecuteReader(str, pms); while (read.Read()) { if (read.HasRows) { model.Name = read["Name"].ToString().Trim(); model.neirong = read["neirong"].ToString().Trim(); } } return(model); }
private void scfwbutton_Click(object sender, EventArgs e) { if (dataGridView1.SelectedColumns.Count != 1) { MessageBox.Show("请选择要编辑的一列!"); return; } string name = dataGridView1.SelectedColumns[0].HeaderText; fuwuModel model = bll.selectIteam(name); if (model == null) { MessageBox.Show("请选择有效列!"); return; } bool result = bll.deleteIteam(name); if (result) { MessageBox.Show("删除成功!"); gridbind(); return; } MessageBox.Show("删除失败!"); }
//显示服务 查询功能 public List <fuwuModel> selectAllList() { List <fuwuModel> list = new List <fuwuModel>(); fuwuModel model; string str = "select * from fuwuInfo where DPName='" + FilterClass.DianPu1.UserName.Trim() + "'"; //SqlParameter[] pms; //if (FilterClass.DianPu1.UserName.Trim()=="admin") //{ // str = "select * from fuwuInfo"; //} //else //{ // str = "select * from fuwuInfo"; //// pms = new SqlParameter[] { ////new SqlParameter("@DPName",FilterClass.DianPu1.UserName.Trim()) ////}; //} SqlDataReader read = SqlHelper.ExecuteReader(str); while (read.Read()) { if (read.HasRows) { model = new fuwuModel(); model.Name = read["Name"].ToString(); model.neirong = read["neirong"].ToString(); list.Add(model); } } return(list); }
private void fuwuEdit_Load(object sender, EventArgs e) { fuwuModel model = new fuwuModel(); model = fuwubll.selectIteam(name); if (model == null) { MessageBox.Show("请选择有效行!"); return; } List <string> list = new List <string>(); list = bll.selectNodes(); list.Insert(0, "无卡"); tableLayoutPanel1.Height = (list.Count + 1) * 40; RowStyle row; Label lab1; TextBox teb1; //row = new RowStyle(SizeType.Absolute,40); lab1 = new Label(); lab1.Text = "服务类别名称"; teb1 = new TextBox(); teb1.Text = model.Name; teb1.ReadOnly = true; tableLayoutPanel1.Controls.Add(lab1, 0, 0); tableLayoutPanel1.Controls.Add(teb1, 1, 0); foreach (var i in list) { lab1 = new Label(); lab1.Text = i; teb1 = new TextBox(); row = new RowStyle(SizeType.Absolute, 40); string[] str = model.neirong.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries); foreach (var iteam in str) { string[] ss = iteam.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); if (i.Trim() == ss[0].Trim()) { teb1.Text = ss[1]; } } tableLayoutPanel1.Controls.Add(lab1, 0, tableLayoutPanel1.RowStyles.Count - 1); tableLayoutPanel1.Controls.Add(teb1, 1, tableLayoutPanel1.RowStyles.Count - 1); tableLayoutPanel1.RowStyles.Add(row); } }
//服务的DAL //添加服务类 基本服务 //admin账户可设置此参数 添加服务的时候记录 店铺名称 在查询的时候去除名称 public bool AddModel(fuwuModel model) { bool result = false; SqlParameter[] pms = new SqlParameter[] { new SqlParameter("@Name", model.Name), new SqlParameter("@neirong", model.neirong), new SqlParameter("@DPName", FilterClass.DianPu1.UserName.Trim()) }; string str = "insert into fuwuInfo(Name,neirong,DPName) values(@Name,@neirong,@DPName)"; if (SqlHelper.ExecuteNonQuery(str, pms) > 0) { result = true; } return(result); }
//修改基本服务中的信息 public bool EditModel(fuwuModel model) { bool result = false; SqlParameter[] pms = new SqlParameter[] { new SqlParameter("@neirong", model.neirong), new SqlParameter("@Name", model.Name), new SqlParameter("@DPName", FilterClass.DianPu1.UserName.Trim()) }; string str = "update fuwuInfo set neirong=@neirong where Name=@Name and DPName=@DPName"; if (SqlHelper.ExecuteNonQuery(str, pms) > 0) { result = true; } return(result); }
private void xgfwbutton_Click(object sender, EventArgs e) { if (dataGridView1.SelectedColumns.Count != 1) { MessageBox.Show("请选择要编辑的一列!"); return; } string name = dataGridView1.SelectedColumns[0].HeaderText; fuwuModel model = bll.selectIteam(name); if (model == null) { MessageBox.Show("请选择有效列!"); return; } fuwuEdit fuwu = fuwuEdit.Create(gridbind, name); fuwu.Show(); fuwu.Focus(); }
private void button1_Click(object sender, EventArgs e) { fuwuModel model = new fuwuModel(); TextBox tb; Label lb; string str = ""; int count = tableLayoutPanel1.RowStyles.Count; for (int i = 0; i < count - 1; i++) { if (i == 0) { tb = tableLayoutPanel1.GetControlFromPosition(1, i) as TextBox; model.Name = tb.Text.Trim(); continue; } lb = tableLayoutPanel1.GetControlFromPosition(0, i) as Label; tb = tableLayoutPanel1.GetControlFromPosition(1, i) as TextBox; if (tb.Text == "") { MessageBox.Show("信息不能为空!"); model.Name = ""; str = ""; return; } str += lb.Text.Trim() + "," + tb.Text.Trim() + ";"; } model.neirong = str; bool result = fuwubl.AddModel(model); if (result) { MessageBox.Show("添加成功!"); bind1(); this.Close(); return; } MessageBox.Show("添加失败!"); }
public bool EditModel(fuwuModel model) { return(dal.EditModel(model)); }
public bool AddModel(fuwuModel model) { return(dal.AddModel(model)); }