/// <summary> /// 修改 /// </summary> /// <param name="temp"></param> /// <param name="sql"></param> /// <param name="mem"></param> /// <returns></returns> private int AddAndUpdateMemberInfo(int temp,string sql,MemberInfo mem) { SQLiteParameter[] ps = { new SQLiteParameter("@MemName",mem.MemName), new SQLiteParameter("@MemMobilePhone",mem.MemMobilePhone), new SQLiteParameter("@MemAddress",mem.MemAddress), new SQLiteParameter("@MemType",mem.MemType), new SQLiteParameter("@MemNum",mem.MemNum), new SQLiteParameter("@MemGender",mem.MemGender), new SQLiteParameter("@MemDiscount",mem.MemDiscount), new SQLiteParameter("@MemMoney",mem.MemMoney), new SQLiteParameter("@MemIntegral",mem.MemIntegral), new SQLiteParameter("@MemEndServerTime",mem.MemEndServerTime), new SQLiteParameter("@MemBirthdaty",mem.MemBirthdaty) }; List<SQLiteParameter> list = new List<SQLiteParameter>(); list.AddRange(ps); if (temp == 1) { list.Add(new SQLiteParameter("@Delflag", mem.DelFlag)); list.Add(new SQLiteParameter("@SubTime", mem.SubTime)); } else if(temp == 2) { list.Add(new SQLiteParameter("@MemmberId", mem.MemmberId)); } return SqliteHelper.ExecuteNonQuery(sql,list.ToArray()); }
public int UpdateMemberInfoByMemberId(MemberInfo mem) { string sql = "update MemmberInfo set MemName=@MemName,MemMobilePhone=@MemMobilePhone,MemAddress=@MemAddress,MemType=@MemType,MemNum=@MemNum,MemGender=@MemGender,MemDiscount=@MemDiscount,MemMoney=@MemMoney,MemIntegral=@MemIntegral,MemEndServerTime=@MemEndServerTime,MemBirthdaty=@MemBirthdaty where MemmberId=@MemmberId"; return AddAndUpdateMemberInfo(2,sql,mem); }
/// <summary> /// Insert and Update Member Infomation /// </summary> /// <param name="mem">MemberInfo Class</param> /// <param name="temp">Flag 1---Insert, 2----Update</param> /// <returns>true/false</returns> public bool SaveMemberInfo(MemberInfo mem,int temp) { int r = -1; if(temp == 1) { //Insert r = dal.InsertMemberInfo(mem); } else if(temp == 2) { //Update r = dal.UpdateMemberInfoByMemberId(mem); } return r > 0; }
private void btnOk_Click(object sender, EventArgs e) { if (CheckEmpty()) { //获取每一个文本框的值 MemberInfo mem = new MemberInfo(); mem.MemBirthdaty = Convert.ToDateTime(txtBirs.Text); mem.MemDiscount = Convert.ToDecimal(txtMemDiscount.Text); mem.MemEndServerTime = Convert.ToDateTime(dtEndServerTime.Text); mem.MemGender = CheckGender(); mem.MemIntegral = Convert.ToInt32(txtMemIntegral.Text); //mem.MemmberId = Convert.ToInt32(labId.Text); mem.MemMobilePhone = txtMemPhone.Text; mem.MemMoney = Convert.ToDecimal(txtmemMoney.Text); mem.MemNum = txtMemNum.Text; mem.MemNum = txtMemName.Text; mem.MemType = Convert.ToInt32(cmbMemType.SelectedValue); if (this.TP == 1) { //Insert mem.SubTime = System.DateTime.Now; mem.DelFlag = 0; } else if (this.TP == 2) { //Update mem.MemmberId = Convert.ToInt32(labId.Text); } MemberInfoBLL bll = new MemberInfoBLL(); string msg = bll.SaveMemberInfo(mem, this.TP)?"操作成功":"操作失败"; MessageBox.Show(msg); this.Close(); } }
/// <summary> /// 新增 /// </summary> /// <param name="mem"></param> /// <returns></returns> public int InsertMemberInfo(MemberInfo mem) { string sql = "insert into MemmberInfo(MemName,MemMobilePhone,MemAddress,MemType,MemNum,MemGender,MemDiscount,MemMoney,Delflag,SubTime,MemIntegral,MemEndServerTime,MemBirthdaty) values(@MemName,@MemMobilePhone,@MemAddress,@MemType,@MemNum,@MemGender,@MemDiscount,@MemMoney,@Delflag,@SubTime,@MemIntegral,@MemEndServerTime,@MemBirthdaty)"; return AddAndUpdateMemberInfo(1,sql,mem); }
/// <summary> /// update money By MemId /// </summary> /// <param name="memId"></param> /// <returns></returns> public int UpdateMoneyByMemId(int memId, decimal money) { MemberInfo mem = new MemberInfo(); string sql = "update MemmberInfo set MemMoney=@MemMoney where DelFlag=0 and MemmberId=@MemmberId"; return SqliteHelper.ExecuteNonQuery(sql, new SQLiteParameter("@MemMoney", money), new SQLiteParameter("@MemmberId", memId)); }
private MemberInfo RowToMemberInfo(DataRow dr) { MemberInfo mem = new MemberInfo(); mem.MemAddress = dr["MemAddress"].ToString(); mem.MemBirthdaty = Convert.ToDateTime(dr["MemBirthdaty"]); mem.MemDiscount = Convert.ToDecimal(dr["MemDiscount"]); mem.MemGender = dr["MemGender"].ToString(); mem.MemEndServerTime = Convert.ToDateTime(dr["MemEndServerTime"]); mem.MemIntegral = Convert.ToInt32(dr["MemIntegral"]); mem.MemmberId = Convert.ToInt32(dr["MemmberId"]); mem.MemMobilePhone = dr["MemMobilePhone"].ToString(); mem.MemName = dr["MemName"].ToString(); mem.MemNum = dr["MemNum"].ToString(); mem.MemPhone = dr["MemPhone"].ToString(); mem.MemType = Convert.ToInt32(dr["MemType"]); mem.SubTime = Convert.ToDateTime(dr["SubTime"]); mem.MemMoney = Convert.ToDecimal(dr["MemMoney"]); return mem; }