//查询所有店铺的信息 public List <DianPu> selectAllList() { List <DianPu> list = new List <DianPu>(); DianPu model; string str = ""; if (FilterClass.DianPu1.UserName == "admin") { str = "select * from DPInfo"; } else { str = "select * from DPInfo where DPName='" + FilterClass.DianPu1.UserName.Trim() + "'"; } SqlDataReader read = SqlHelper.ExecuteReader(str); while (read.Read()) { if (read.HasRows) { model = new DianPu(); model.DPName = read["DPName"].ToString(); model.DPContent = read["DPContent"].ToString(); model.DPAddress = read["DPAddress"].ToString(); model.DPPerson = read["DPPerson"].ToString(); model.DPPicture = read["DPPicture"].ToString(); model.DPRemark = read["DPRemark"].ToString(); model.DPTel = read["DPTel"].ToString(); model.DPNo = read["DPNo"].ToString(); model.ID = Convert.ToInt32(read["ID"]); list.Add(model); } } return(list); }
private void bcbutton_Click(object sender, EventArgs e) { DianPu model = new DianPu(); model.DPName = dpmcBox.Text.Trim(); model.DPPerson = lxrBox.Text.Trim(); model.DPTel = lxdhBox.Text.Trim(); model.DPAddress = dpdztBox.Text.Trim(); model.DPRemark = bzxxBox.Text.Trim(); model.DPContent = textBox1.Text.Trim(); model.DPPicture = comboBox1.Text.Trim(); model.DPNo = textBox2.Text.Trim(); model.DPDay = DateTime.Now.Day.ToString(); model.BGJPrint = comboBox2.Text; model.MemberPrint = comboBox3.Text; model.DPNumber = "1"; if (model.DPName == "" || model.DPPerson == "" || model.DPTel == "" || model.DPAddress == "" || model.DPRemark == "" || model.DPPicture == "") { MessageBox.Show("请将信息填写完整!"); return; } int result = dpbll.AddModel(model); if (result != 0) { MessageBox.Show("添加成功!"); bind(); //添加成功之后,开始添加新店铺所对应的表 dpbll.AddTable(result); this.Close(); return; } MessageBox.Show("添加失败!"); }
private void bcbutton_Click(object sender, EventArgs e) { DianPu model = new DianPu(); model.DPName = dpmcBox.Text.Trim(); model.DPPerson = lxrBox.Text.Trim(); model.DPTel = lxdhBox.Text.Trim(); model.DPNo = textBox2.Text.Trim(); model.DPAddress = dpdztBox.Text.Trim(); model.DPRemark = bzxxBox.Text.Trim(); model.DPContent = textBox1.Text.Trim(); model.DPPicture = comboBox1.Text.Trim(); model.BGJPrint = comboBox2.Text; model.MemberPrint = comboBox3.Text; if (model.DPName == "" || model.DPPerson == "" || model.DPTel == "" || model.DPAddress == "" || model.DPRemark == "" || model.DPPicture == "") { MessageBox.Show("请将信息填写完整!"); return; } bool result = dpbll.UpdateModel(model); if (result) { MessageBox.Show("修改成功!"); bind(); this.Close(); return; } MessageBox.Show("修改失败!"); }
public static DPUpdateFrom Create(databind bind1, DianPu model) { model1 = model; bind = bind1; if (lsdzj == null) { lsdzj = new DPUpdateFrom(); } return(lsdzj); }
private void button2_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count != 1) { MessageBox.Show("请选择一条数据!"); return; } DianPu model = new DianPu(); model = (DianPu)dataGridView1.SelectedRows[0].DataBoundItem; DPUpdateFrom lsdzj = DPUpdateFrom.Create(databind, model); lsdzj.Show(); lsdzj.Focus(); }
public bool UpdateModel(DianPu model) { bool result = false; string str = "update DPInfo set DPPerson=@DPPerson,DPTel=@DPTel,DPAddress=@DPAddress,DPRemark=@DPRemark,DPContent=@DPContent,DPPicture=@DPPicture,DPNo=@DPNo,MemberPrint=@MemberPrint,BGJPrint=@BGJPrint where DPName=@DPName"; SqlParameter[] pms = new SqlParameter[] { new SqlParameter("@DPName", model.DPName), new SqlParameter("@DPPerson", model.DPPerson), new SqlParameter("@DPTel", model.DPTel), new SqlParameter("@DPAddress", model.DPAddress), new SqlParameter("@DPRemark", model.DPRemark), new SqlParameter("@DPContent", model.DPContent), new SqlParameter("@DPPicture", model.DPPicture), new SqlParameter("@MemberPrint", model.MemberPrint), new SqlParameter("@BGJPrint", model.BGJPrint), new SqlParameter("@DPNo", model.DPNo) }; if (SqlHelper.ExecuteNonQuery(str, pms) > 0) { result = true; } return(result); }
private void button3_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count != 1) { MessageBox.Show("请选择一条数据!"); return; } var btnresult = MessageBox.Show("确认删除?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (btnresult == DialogResult.OK) { DianPu model = new DianPu(); model = (DianPu)dataGridView1.SelectedRows[0].DataBoundItem; bool result = dpbll.deleteIteam(model.ID); if (result) { MessageBox.Show("删除成功!"); databind(); return; } MessageBox.Show("删除失败!"); } }
//此类是唯一的只有admin能访问 //店铺信息DAL //插入店铺信息 public int AddModel(DianPu model) { //首先判断 当前的店铺名字是否唯一 唯一之后才可添加新店铺 string dpname = model.DPName.Trim(); bool isweiyi = DpnameWY(dpname); if (!isweiyi) { return(0); } string str = "insert into DPInfo(DPName,DPPerson,DPTel,DPAddress,DPRemark,DPContent,DPPicture,DPNo,DPDay,DPNumber,MemberPrint,BGJPrint) values(@DPName,@DPPerson,@DPTel,@DPAddress,@DPRemark,@DPContent,@DPPicture,@DPNo,@DPDay,@DPNumber,@MemberPrint,@BGJPrint);select @@Identity"; SqlParameter[] pms = new SqlParameter[] { new SqlParameter("@DPName", model.DPName), new SqlParameter("@DPPerson", model.DPPerson), new SqlParameter("@DPTel", model.DPTel), new SqlParameter("@DPAddress", model.DPAddress), new SqlParameter("@DPRemark", model.DPRemark), new SqlParameter("@DPContent", model.DPContent), new SqlParameter("@DPPicture", model.DPPicture), new SqlParameter("@DPNo", model.DPNo), new SqlParameter("@DPDay", model.DPDay), new SqlParameter("@DPNumber", model.DPNumber), new SqlParameter("@MemberPrint", model.MemberPrint), new SqlParameter("@BGJPrint", model.BGJPrint) }; object oo = SqlHelper.ExecuteScalar(str, pms); if (oo == null) { return(0); } else { return(Convert.ToInt32(oo)); } }
public bool UpdateModel(DianPu model) { return(dal.UpdateModel(model)); }
public int AddModel(DianPu model) { return(dal.AddModel(model)); }