private void BtnMsDelete_Click(object sender, EventArgs e)
{
if (DgvMembership.SelectedRows.Count == 1)
{
int index = DgvMembership.SelectedRows[0].Index;
Ms = mses[index];
if (EValid.效 == Ms.IsValid)
{
StringBuilder sb = new StringBuilder();
sb.Append("确定删除当前会员？\n");
sb.Append("会员编号" + Ms.MsID.ToString() + "\n");
sb.Append("会员姓名" + Ms.MsName + "\n");
sb.Append("联系方式" + Ms.MsPhone + "\n");
sb.Append("会员积分" + Ms.MsPoint);
if (DialogResult.OK == MsgBoxUtil.QuestionMsgBox(sb.ToString()))
{
MembershipDao.DeleteByMsID(Ms.MsID);
mses[index].IsValid = EValid.已删除;
DgvMembership.Rows[index].Cells["ClnMsIsValid"].Value = EValid.已删除;
Ms = null;
}
}
}
else
{
MsgBoxUtil.ErrMsgBox("请选择要删除的会员！");
}
}
private void BtnMsInsert_Click(object sender, EventArgs e)
{
FrmMsInsert fmi = new FrmMsInsert {
StartPosition = FormStartPosition.CenterParent
};
fmi.ShowDialog();
if (Ms != null)
{
mses.Add(Ms);
Ms = null;
if (mses.Count > 1)
{
mses[mses.Count - 1].MsID = mses[mses.Count - 2].MsID + 1;
}
DgvMembership.Rows.Add(new object[] {
mses[mses.Count - 1].MsID,
mses[mses.Count - 1].MsName,
mses[mses.Count - 1].MsPhone,
mses[mses.Count - 1].MsPoint,
mses[mses.Count - 1].IsValid
});
hasUpdated = true;
}
}
private void BtnMsUpdate_Click(object sender, EventArgs e)
{
if (DgvMembership.SelectedRows.Count == 1)
{
int index = DgvMembership.SelectedRows[0].Index;
Ms = mses[index];
FrmMsUpdate fmu = new FrmMsUpdate {
StartPosition = FormStartPosition.CenterParent
};
fmu.ShowDialog();
if (Ms != null)
{
DgvMembership.Rows[index].Cells["ClnMsName"].Value = Ms.MsName;
DgvMembership.Rows[index].Cells["ClnMsPhone"].Value = Ms.MsPhone;
DgvMembership.Rows[index].Cells["ClnMsPoint"].Value = Ms.MsPoint;
DgvMembership.Rows[index].Cells["ClnMsIsValid"].Value = Ms.IsValid;
mses[index] = Ms;
Ms = null;
}
hasUpdated = true;
}
else
{
MsgBoxUtil.ErrMsgBox("请选择要修改的会员信息！");
}
}
private static List <EtMembership> GetListByDataReader(MySqlDataReader dr)
{
List <EtMembership> memberships = new List <EtMembership>();
try
{
while (dr.Read())
{
EtMembership membership = new EtMembership
{
MsID = dr.GetInt32("msID"),
MsName = dr["msName"] is DBNull ? null : dr.GetString("msName"),
MsPhone = dr["msPhone"] is DBNull ? null : dr.GetString("msPhone"),
MsPoint = dr["msPoint"] is DBNull ? 0 : dr.GetInt32("msPoint"),
IsValid = (EValid)(dr["isValid"] is DBNull ? 0 : dr.GetInt32("isValid"))
};
memberships.Add(membership);
}
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
return(memberships);
}
public FrmMembership()
{
InitializeComponent();
Ms = null;
hasUpdated = false;
mses = MembershipDao.QueryAll();
foreach (EtMembership ms in mses)
{
DgvMembership.Rows.Add(new object[] {
ms.MsID,
ms.MsName,
ms.MsPhone,
ms.MsPoint,
ms.IsValid
});
}
}
public static int InsertMembership(EtMembership membership)
{
List <EtMembership> memberships = QueryByMsID(membership.MsID);
if (memberships.Count > 0)
{
return(-1);
}
DBHelper helper = new DBHelper();
string sql = "INSERT INTO " +
"membership(msName,msPhone,msPoint,isValid) " +
"VALUE(@msName,@msPhone,@msPoint,@isValid)";
MySqlParameter[] prams =
{
new MySqlParameter("@MsName", membership.MsName ?? (object)DBNull.Value),
new MySqlParameter("@MsPhone", membership.MsPhone ?? (object)DBNull.Value),
new MySqlParameter("@msPoint", membership.MsPoint),
new MySqlParameter("@isValid", membership.IsValid)
};
return(helper.RunNonQuerySQL(sql, prams));
}
public static int UpdateMembership(EtMembership membership)
{
List <EtMembership> memberships = QueryByMsID(membership.MsID);
if (memberships.Count == 0)
{
return(-1);
}
DBHelper helper = new DBHelper();
string sql = "UPDATE membership SET msName = @MsName, msPhone = @MsPhone," +
"msPoint = @MsPoint, isValid = @IsValid " +
"WHERE msID = @MsID;";
MySqlParameter[] prams =
{
new MySqlParameter("@MsName", membership.MsName ?? (object)DBNull.Value),
new MySqlParameter("@MsPhone", membership.MsPhone ?? (object)DBNull.Value),
new MySqlParameter("@MsPoint", membership.MsPoint),
new MySqlParameter("@IsValid", membership.IsValid),
new MySqlParameter("@MsID", membership.MsID)
};
return(helper.RunNonQuerySQL(sql, prams));
}
public static int UpdateOrInsert(EtMembership membership)
{
List <EtMembership> memberships = QueryByMsID(membership.MsID);
if (memberships.Count > 0)
{
DBHelper helper = new DBHelper();
string sql = "UPDATE membership SET msName = @MsName, msPhone = @MsPhone," +
"msPoint = @MsPoint, isValid = @IsValid " +
"WHERE msID = @MsID;";
MySqlParameter[] prams =
{
new MySqlParameter("@MsName", membership.MsName ?? (object)DBNull.Value),
new MySqlParameter("@MsPhone", membership.MsPhone ?? (object)DBNull.Value),
new MySqlParameter("@MsPoint", membership.MsPoint),
new MySqlParameter("@IsValid", membership.IsValid),
new MySqlParameter("@MsID", membership.MsID)
};
return(helper.RunNonQuerySQL(sql, prams));
}
else
{
DBHelper helper = new DBHelper();
string sql = "INSERT INTO " +
"membership(msName,msPhone,msPoint,isValid) " +
"VALUE(@msName,@msPhone,@msPoint,@isValid)";
MySqlParameter[] prams =
{
new MySqlParameter("@MsName", membership.MsName ?? (object)DBNull.Value),
new MySqlParameter("@MsPhone", membership.MsPhone ?? (object)DBNull.Value),
new MySqlParameter("@msPoint", membership.MsPoint),
new MySqlParameter("@isValid", membership.IsValid)
};
return(helper.RunNonQuerySQL(sql, prams));
}
}
