/// <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;
}
