public int Delete(int m_id)
{
//連動刪除Member_card
Member_cardInfo mcinfos = mcBLL.GetDataByMid(m_id);
mcBLL.Delete(mcinfos.mc_id);
return(db.Delete(m_id));
}
public Member_cardInfo GetDataByMid(int m_id)
{
Member_cardInfo info = new Member_cardInfo();
IDataReader reader = db.GetDataByMId(m_id).CreateDataReader();
if (reader.Read())
{
info = Member_cardInfo.Populate(reader);
}
return(info);
}
public static Member_cardInfo Populate(IDataReader reader)
{
Member_cardInfo info = new Member_cardInfo();
for (int i = 0; i < reader.FieldCount; i++)
{
PropertyInfo property = info.GetType().GetProperty(reader.GetName(i));
Type propType = property.PropertyType;
TypeConverters.ITypeConverter typeConverter = TypeConverters.TypeConverterFactory.GetConvertType(propType);
property.SetValue(info, Convert.ChangeType(typeConverter.Convert(reader.GetValue(i)), propType), null);
}
return(info);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
Member_cardInfo info = mcBLL.GetDataByMid(int.Parse(Request.QueryString["id"].ToString()));
info.mc_pass = txtPass.Text.Trim().ToLower();
info.mc_status = int.Parse(ddlLevel.SelectedValue);
info.mc_note = txtContact.Text;
info.mc_editdate = DateTime.Now;
if (mcBLL.Update(info) > 0)
{
//SetSmtpArray();
Response.Redirect("~/Manager/Member/List.aspx?header=" + Getmessage("30014"));
}
}
protected void Bind()
{
if (Request.QueryString["id"] != null)
{
if (Tools.TryParseMethod(Request.QueryString["id"].ToString()) != 0)
{
Member_cardInfo info = mcBLL.GetDataByMid(int.Parse(Request.QueryString["id"].ToString()));
lbCardNumber.Text = info.mc_number;
lbPAss.Text = info.mc_pass;
ddlLevel.SelectedValue = info.mc_status.ToString();
txtContact.Text = info.mc_note;
lbCreateDate.Text = info.mc_adddate.ToString("yyyy/MM/dd hh:mm");
lbEditDate.Text = info.mc_editdate.ToString("yyyy/MM/dd hh:mm");
}
}
}
protected void lkbtnCreateCard_Command(object sender, CommandEventArgs e)
{
if (mcBLL.GetDataByMid(int.Parse(e.CommandArgument.ToString())).m_id == 0)
{
MemberInfo minfo = mBLL.GetDataById(int.Parse(e.CommandArgument.ToString()));
Member_cardInfo info = new Member_cardInfo();
info.mc_number = "MC" + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + minfo.m_level + string.Format("{00000:00000}", mcBLL.Getall().Rows.Count + 1);
info.mc_pass = Tools.GetRandomString(12);
info.mc_status = 0;
info.m_id = int.Parse(e.CommandArgument.ToString());
info.mc_adddate = DateTime.Now;
info.mc_editdate = DateTime.Now;
if (mcBLL.Insert(info) > 0)
{
ShowMessage("創建會員卡成功");
}
}
else
{
ShowMessage("此帳號已創建會員卡");
}
}
public int Update(Member_cardInfo info)
{
return(db.Update(info.mc_number, info.mc_pass, info.mc_status, info.m_id, info.mc_note, info.mc_adddate, info.mc_editdate, info.mc_id));
}
public int Insert(Member_cardInfo info)
{
return(db.Insert(info.mc_number, info.mc_pass, info.mc_status, info.m_id, info.mc_note, info.mc_adddate, info.mc_editdate));
}