private void btnSave_Click(object sender, EventArgs e) { MemberTypeInfoBll bll = new MemberTypeInfoBll(); MemberTypeInfo model = new MemberTypeInfo() { MTitle = txtTitle.Text, MDiscount = Convert.ToDecimal(txtDiscount.Text), }; if (btnSave.Text == "添加") { if (!bll.Add(model)) { MessageBox.Show("添加失败"); } } else { model.MId = Convert.ToInt32(txtId.Text); if (!bll.Update(model)) { MessageBox.Show("修改失败"); } } Reset(); LoadList(); resulted = DialogResult.OK; }
private void btnSave_Click(object sender, EventArgs e) { MemberTypeInfo mti = new MemberTypeInfo(); mti.MTitle = txtTitle.Text; mti.MDiscount = Convert.ToDecimal(txtDiscount.Text); if (!btnSave.Text.Equals("保存")) { mti.MId = Convert.ToInt32(txtId.Text); if (mtiBll.UpdateMTI(mti)) { LoadList(); txtId.Text = "添加时无编号"; txtDiscount.Text = ""; txtTitle.Text = ""; btnSave.Text = "保存"; } else { MessageBox.Show("修改失败"); } result = DialogResult.OK; return; } if (mtiBll.AddMTI(mti)) { LoadList(); } else { MessageBox.Show("添加失败"); } result = DialogResult.OK; }
private static IMemberAccessor CreateMemberAccessor(MemberTypeInfo mi, bool readOnly, IObjectCache <string> memberCache) { var genType = typeof(DelegateMemberAccessor <,>).MakeGenericType(mi.DeclaringType, mi.MemberType); var result = Activator.CreateInstance(genType, mi.Name, readOnly, memberCache); return((IMemberAccessor)result); }
private void button_添加_Click(object sender, EventArgs e) { if (textBox_标题.Text != "" && textBox_折扣.Text != "") { try { MemberTypeInfo mti = new MemberTypeInfo() { MTitle = textBox_标题.Text, MDiscount = decimal.Parse(textBox_折扣.Text), MIsdelete = false }; if (MTIBll.Insert(mti)) { GetInfo(); button_取消.PerformClick(); } else { button_取消.PerformClick(); MessageBox.Show("添加不成功,请重试"); } } catch (FormatException) { MessageBox.Show("折扣必须是数字"); } } else { MessageBox.Show("文本框不能为空"); } }
private void btnSave_Click(object sender, EventArgs e) { MemberTypeInfo mti = new MemberTypeInfo(); mti.MDiscount = Convert.ToDecimal(txtDiscount.Text); mti.MTitle = txtTitle.Text; if (txtId.Text == "添加时无编号")//表示增加 { if (mtiBll.Add(mti)) { LoadList(); ClearText(); } else { MessageBox.Show("添加失败,请稍后再试!"); } } else { mti.MId = Convert.ToInt32(txtId.Text); if (mtiBll.Edit(mti)) { LoadList(); ClearText(); } else { MessageBox.Show("修改失败,请稍后再试!"); } } }
private void btnSave_Click(object sender, EventArgs e) { MemberTypeInfo mti = new MemberTypeInfo() { MTitle = txtTitle.Text, MDiscount = Convert.ToDecimal(txtDiscount.Text) }; if (txtId.Text.Equals("No ID")) { if (mtiBll.Add(mti)) { LoadList(); } } else { mti.MId = int.Parse(txtId.Text); if (mtiBll.Edit(mti)) { LoadList(); } else { MessageBox.Show("Failed."); } } txtId.Text = "No ID"; txtTitle.Text = ""; txtDiscount.Text = ""; btnSave.Text = "Add"; result = DialogResult.OK; }
public bool Alert(MemberTypeInfo mti) { if (mbtdal.Update(mti) > 0) { return(true); } return(false); }
//修改 public int updateMTI(MemberTypeInfo mti) { string sql = "update membertypeinfo set mtitle=@title,MDiscount=@discount where mid=@id"; SQLiteParameter[] sp = { new SQLiteParameter("@title", mti.MTitle) , new SQLiteParameter("@discount", mti.MDiscount) , new SQLiteParameter("@id", mti.MId) }; return(SqliteHelper.ExecuteNonQuery(sql, sp)); }
public bool Add(MemberTypeInfo mti) { if (mbtdal.Insert(mti) > 0) { return(true); } return(false); }
public SystemClassWithMembersAndTypes(DeserializeReader reader) : base(reader, RecordType.SystemClassWithMembersAndTypes) { ClassInfo = new ClassInfo(reader); MemberTypeInfo = new MemberTypeInfo(reader, ClassInfo); if (MemberTypeInfo.Types.Count != ClassInfo.MemberCount) { throw new InvalidStructureException("Member type count mismatch"); } }
public int Delete(MemberTypeInfo mti) { string sql = "DELETE FROM MemberTypeInfo WHERE MId =@id"; SQLiteParameter[] ps = { new SQLiteParameter("@id", mti.MId) }; return(SqliteHelper.ExecuteNonQuery(sql, ps)); }
//添加 public int insertMTI(MemberTypeInfo mti) { string sql = "insert into membertypeinfo(mtitle,MDiscount,MIsDelete)" + "values(@title,@discount,@MIsDelete)"; SQLiteParameter[] sp = { new SQLiteParameter("@title", mti.MTitle) , new SQLiteParameter("@discount", mti.MDiscount) , new SQLiteParameter("@MIsDelete", false) }; return(SqliteHelper.ExecuteNonQuery(sql, sp)); }
private void btnSave_Click(object sender, EventArgs e) { //判断输入有效性 if (string.IsNullOrWhiteSpace(txtTitle.Text)) { MessageBox.Show("请输入标题"); txtTitle.Focus(); return; } if (string.IsNullOrWhiteSpace(txtDiscount.Text)) { MessageBox.Show("请输入折扣"); txtDiscount.Focus(); return; } //接收用户输入的值,构造对象 MemberTypeInfo mti = new MemberTypeInfo() { MTitle = txtTitle.Text, MDiscount = decimal.Parse(txtDiscount.Text) }; if (txtId.Text.Equals("添加时无编号")) { //添加操作 if (mtiBll.Add(mti)) //调用添加方法 { LoadList(); } else { MessageBox.Show("添加失败,请稍候重试"); } } else { //修改操作 mti.MId = int.Parse(txtId.Text); if (mtiBll.Edit(mti)) { LoadList(); } else { MessageBox.Show("修改失败,请稍候重试"); } } //将控件还原 txtId.Text = "添加时无编号"; txtTitle.Text = ""; txtDiscount.Text = ""; btnSave.Text = "添加"; result = DialogResult.OK; }
public int Insert(MemberTypeInfo memberTypeInfo) { string sql = "insert into MemberTypeInfo(mtitle,mdiscount,misdelete) values(@title,@discount,0)"; SQLiteParameter[] parameter = { new SQLiteParameter("@title", memberTypeInfo.MTitle), new SQLiteParameter("@discount", memberTypeInfo.MDiscount), }; return(SqliteHelper.ExecuteNonQuery(sql, parameter)); }
public int Insert(MemberTypeInfo mti) { var sql = "insert into membertypeinfo (mtitle,mdiscount,misDelete) values (@title,@discount,0)"; SQLiteParameter[] ps = { new SQLiteParameter("@title", mti.MTitle), new SQLiteParameter("@discount", mti.MDiscount) }; return(SqliteHelper.ExecuteNonQuery(sql, ps)); }
public int Insert(MemberTypeInfo memberTypeInfo) { string sql = "insert into MemberTypeInfo('MTitle','MDiscount','MIsDelete') values(@title,@discount,0)"; SQLiteParameter[] ps = { new SQLiteParameter("@title", memberTypeInfo.MTitle), new SQLiteParameter("@discount", memberTypeInfo.MDiscount), }; return(SqliteHelper.ExecuteNonQuery(sql, ps)); }
public int Insert(MemberTypeInfo mti) { string sql = "insert into MemberTypeInfo (MTitle,MDiscount,MIsDelete) values (@MTitle,@MDiscount,0)"; SQLiteParameter[] sp = { new SQLiteParameter("MTitle", mti.MTitle), new SQLiteParameter("MDiscount", mti.MDiscount) }; return(SQLiteHelper.ExecuteNonQuery(sql, sp)); }
public int Update(MemberTypeInfo memberTypeInfo) { string sql = "update membertypeinfo set mtitle=@title,mdiscount=@discount where mid=@id"; SQLiteParameter[] parameters = { new SQLiteParameter("@title", memberTypeInfo.MTitle), new SQLiteParameter("@discount", memberTypeInfo.MDiscount), new SQLiteParameter("@id", memberTypeInfo.MId), }; return(SqliteHelper.ExecuteNonQuery(sql, parameters)); }
public int Update(MemberTypeInfo mti) { string sql = "update MemberTypeInfo set MTitle=@MTitle,MDiscount=@MDiscount where Mid=@Mid"; SQLiteParameter[] sp = { new SQLiteParameter("MTitle", mti.MTitle), new SQLiteParameter("MDiscount", mti.MDiscount), new SQLiteParameter("Mid", mti.MId) }; return(SQLiteHelper.ExecuteNonQuery(sql, sp)); }
public int Insert(MemberTypeInfo mit) { //构造插入语句,注意:必须列与值要相对应 string sql = "insert into MemberTypeInfo(MTitle,MDiscount,MIsDelete) values(@title,@discount,0)"; SQLiteParameter[] ps = { new SQLiteParameter("@title", mit.MTitle), new SQLiteParameter("@discount", mit.MDiscount) }; return(SqliteHelper.ExecuteNonQuery(sql, ps)); }
public int Update(MemberTypeInfo memberTypeInfo) { string sql = "update MemberTypeInfo set MDiscount=@discount,MTitle=@title where MId=@id"; SQLiteParameter[] ps = { new SQLiteParameter("@discount", memberTypeInfo.MDiscount), new SQLiteParameter("@title", memberTypeInfo.MTitle), new SQLiteParameter("@id", memberTypeInfo.MId) }; return(SqliteHelper.ExecuteNonQuery(sql, ps)); }
public int Update(MemberTypeInfo model) { string sql = "update MemberTypeInfo set Mtitle=@title,MDiscount=@count where Mid=@id"; SQLiteParameter[] param = { new SQLiteParameter("@title", model.MTitle), new SQLiteParameter("@count", model.MDiscount), new SQLiteParameter("@id", model.MId) }; return(SqliteHelper.ExecuteNonQuery(sql, param)); }
public int Add(MemberTypeInfo model) { string sql = "insert into MemberTypeInfo(MTitle,MDiscount,MIsDelete) values(@title,@discount,@isdelete)"; SQLiteParameter[] param = { new SQLiteParameter("@title", model.MTitle), new SQLiteParameter("@discount", model.MDiscount), new SQLiteParameter("@isdelete", model.MIsDelete) }; return(SqliteHelper.ExecuteNonQuery(sql, param)); }
public int Update(MemberTypeInfo mti) { var sql = "update membertypeinfo set mtitle=@mtitle,mdiscount=@mdiscount where mid=@mid"; SQLiteParameter[] ps = { new SQLiteParameter("@mtitle", mti.MTitle), new SQLiteParameter("@mdiscount", mti.MDiscount), new SQLiteParameter("@mid", mti.Mid) }; return(SqliteHelper.ExecuteNonQuery(sql, ps)); }
/// <summary> /// 插入数据 /// </summary> /// <param name="mti"></param> /// <returns></returns> public int Insert(MemberTypeInfo mti) { string sqltext = "insert into MemberTypeInfo(MTitle,MDiscount,MIsDelete) values(@title,@discount,0)"; SQLiteParameter[] parameters = { new SQLiteParameter("@title", DbType.String), new SQLiteParameter("@discount", DbType.Decimal), }; parameters[0].Value = mti.MTitle; parameters[1].Value = mti.MDiscount; return(SQLiteHelper.ExecuteNonQuery(sqltext, parameters)); }
/// <summary> /// insert MemberTypeInfo对象 /// </summary> /// <param name="mti"></param> /// <returns></returns> public int Insert(MemberTypeInfo mti) { //构造insert语句 string sql = "INSERT INTO MemberTypeInfo(MTitle, MDiscount, MIsDelete) VALUES(@title, @discount, 1)"; SQLiteParameter[] ps = { new SQLiteParameter("@title", mti.MTitle), new SQLiteParameter("@discount", mti.MDiscount), }; return(SqliteHelper.ExecuteNonQuery(sql, ps)); }
/// <summary> /// 添加数据 /// </summary> /// <param name="mti"></param> /// <returns></returns> public int Insert(MemberTypeInfo mti) { //构造添加sql语句 string sql = "INSERT INTO MemberTypeInfo (MTitle,MDiscount,MIsDelete) VALUES(@MTitle,@MDiscount,0)"; //构造参数 MySqlParameter[] ps = { new MySqlParameter("@MTitle", mti.MTitle), new MySqlParameter("@MDiscount", mti.MDiscount), }; //调用操作数据方法 return(MysqlHelper.ExecuteNonQuery(sql, ps)); }
public int Update(MemberTypeInfo mti) { string sql = "update MemberTypeInfo set Mtitle=@title,Mdiscount=@discount,MIsDelete=@isdelete where mid=@id"; SQLiteParameter[] ps = { new SQLiteParameter("@id", mti.Mid), new SQLiteParameter("@title", mti.Mtitle), new SQLiteParameter("@discount", mti.Mdiscount), new SQLiteParameter("@isdelete", mti.MIsDelete) }; return(SqliteHelper.Execute(sql, sqltype.ExecuteNonQuery, ps)); }
//添加 public int Insert(MemberTypeInfo mti) { //构造insert语句 string sql = "insert into MemberTypeInfo(mtitle,mdiscount,misDelete) values(@title,@discount,0)"; //为sql语句构造参数 SQLiteParameter[] ps = { new SQLiteParameter("@title", mti.MTitle), new SQLiteParameter("@discount", mti.MDiscount) }; //执行 return(SqliteHelper.ExecuteNonQuery(sql, ps)); }
public int Insert(MemberTypeInfo mti) { string sql = "insert into MemberTypeInfo(mid,mtitle,mdiscount,misdelete) values(@id,@type,@discount,@isdelete)"; SQLiteParameter[] ps = { new SQLiteParameter("@id", mti.Mid), new SQLiteParameter("@type", mti.Mtitle), new SQLiteParameter("@discount", mti.Mdiscount), new SQLiteParameter("@isdelete", mti.MIsDelete) }; return(SqliteHelper.Execute(sql, sqltype.ExecuteNonQuery, ps)); }