public List <qtFuWuModel> SelectAllList() { string dpname = FilterClass.DianPu1.UserName.Trim(); List <qtFuWuModel> list = new List <qtFuWuModel>(); qtFuWuModel model; SqlParameter[] pms; string str; if (dpname == "admin") { pms = new SqlParameter[] { }; str = "select * from QtFuWu"; } else { pms = new SqlParameter[] { new SqlParameter("@DPName", dpname) }; str = "select * from QtFuWu where DPName=@DPName"; } SqlDataReader read = SqlHelper.ExecuteReader(str, pms); while (read.Read()) { if (read.HasRows) { model = new qtFuWuModel(); model.QtName = read["QtName"].ToString(); list.Add(model); } } return(list); }
private void button1_Click(object sender, EventArgs e) { qtFuWuModel model = new qtFuWuModel(); model.QtName = textBox1.Text.Trim(); try { //money = Convert.ToInt32(textBox2.Text.Trim()); //if (money > 100 || money < 0) //{ // MessageBox.Show("请输入合理的提成!"); // return; //} //model.QtTc = money; bool result = bll.EditModel(model); if (result) { MessageBox.Show("修改成功!"); bind1(); this.Close(); return; } MessageBox.Show("错误!请稍后再试!"); } catch { MessageBox.Show("提成请输入数字!"); } }
public static EditQtFuWu Create(databind bind, qtFuWuModel model) { model1 = model; bind1 = bind; if (qt == null) { qt = new EditQtFuWu(); } return(qt); }
private void button2_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count != 1) { MessageBox.Show("请选择一条数据!"); return; } qtFuWuModel model = (qtFuWuModel)dataGridView1.SelectedRows[0].DataBoundItem; EditQtFuWu qtedit = EditQtFuWu.Create(databind, model); qtedit.Show(); qtedit.Focus(); }
/// <summary> /// 添加其他服务类 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddModel(qtFuWuModel model) { bool result = false; string str = "insert into QtFuWu(QtName,DPName) values(@QtName,@DPName)"; SqlParameter[] pms = new SqlParameter[] { new SqlParameter("@QtName", model.QtName), new SqlParameter("@DPName", FilterClass.DianPu1.UserName.Trim()) }; if (SqlHelper.ExecuteNonQuery(str, pms) > 0) { result = true; } return(result); }
public bool EditModel(qtFuWuModel model) { bool result = false; string str = "update QtFuWu set QtName=@QtName1 where QtName=@QtName and DPName=@DPName"; SqlParameter[] pms = new SqlParameter[] { new SqlParameter("@QtName", model.QtName), new SqlParameter("@QtName1", model.QtName), new SqlParameter("@DPName", FilterClass.DianPu1.UserName.Trim()) }; if (SqlHelper.ExecuteNonQuery(str, pms) > 0) { result = true; } return(result); }
public bool EditModel(qtFuWuModel model) { return(dal.EditModel(model)); }
public bool AddModel(qtFuWuModel model) { return(dal.AddModel(model)); }