public static List <EtCategory> QueryByIsValid(EValid eValid)
{
DBHelper helper = new DBHelper();
string sql = "SELECT * FROM category WHERE isValid = @isValid;";
MySqlParameter[] prams = { new MySqlParameter("@isValid", eValid) };
MySqlDataReader dr = helper.RunQuerySQL(sql, prams);
return(GetListByDataReader(dr));
}
public static List <EtMembership> QueryByIsValid(EValid isValid)
{
DBHelper helper = new DBHelper();
string sql = "SELECT * FROM membership WHERE isValid=@isValid";
MySqlParameter[] prams = { new MySqlParameter("@isValid", isValid) };
MySqlDataReader dr = helper.RunQuerySQL(sql, prams);
return(GetListByDataReader(dr));
}
private void BtnInsert_Click(object sender, EventArgs e)
{
try {
string MsName = TxtMsName.Text;
string MsPhone = TxtMsPhone.Text;
int MsPoint = "" == TxtMsPoint.Text ? 0 : int.Parse(TxtMsPoint.Text);
EValid IsValid = (EValid)CmbIsValid.SelectedIndex;
FrmMembership.Ms = new EtMembership {
MsName = MsName,
MsPhone = MsPhone,
MsPoint = MsPoint,
IsValid = IsValid
};
Close();
}
catch (Exception) {
MsgBoxUtil.ErrMsgBox("员工信息输入错误！");
}
}
