private void Frm_memberXG_Load(object sender, EventArgs e)
{
try
{
//查找会员等级名称
ClientServicesProxy proxys = new ClientServicesProxy();
tb_membertype p = new tb_membertype();
var result = proxys.Find(p);
foreach (var item in result)
{
CB_grade.Items.Add(item.Mt_Name);
}
//判断是添加还是修改
if (ID == null)
{
this.Text = "添加会员";
bianhao();
TB_BZ.Text = "无";
TB_IDcard.Text = "";
TB_Name.Text = "";
TB_Tel.Text = "";
CB_grade.SelectedIndex = 0;
CB_Sex.SelectedIndex = 1;
CB_Type.SelectedIndex = 0;
TB_jifen.Enabled = false;
//根据会员等级显示新会员初始积分
p.Mt_Name = CB_grade.Text.Trim();
result = proxys.Find(p);
if (result.IsNotNull())
{
TB_jifen.Text = result.FirstOrDefault().Mt_csjf;
}
}
else
{
this.Text = "修改会员";
string str_sql1 = "select a.member_ID,a.member_Name, b.Mt_Name,a.member_Sex,a.Member_birthday,a.Member_Phone,a.Member_DJRQ,"
+ "a.Member_JF,a.Member_type,a.member_IDCard,a.Beizhu from tb_member a,tb_membertype b where a.Member_DJ=b.Mt_ID and a.member_ID='" + ID + "'";
DataSet dst = db.GetDataFromSQL(str_sql1);
TB_ID.Text = ID;
TB_Name.Text = dst.Tables[0].Rows[0]["member_Name"].ToString().Trim();
CB_Sex.Text = dst.Tables[0].Rows[0]["member_Sex"].ToString().Trim();
DTP_SR.Text = dst.Tables[0].Rows[0]["Member_birthday"].ToString().Trim();
TB_jifen.Text = dst.Tables[0].Rows[0]["Member_JF"].ToString().Trim();
TB_IDcard.Text = dst.Tables[0].Rows[0]["member_IDCard"].ToString().Trim();
TB_Tel.Text = dst.Tables[0].Rows[0]["Member_Phone"].ToString().Trim();
CB_grade.Text = dst.Tables[0].Rows[0]["Mt_Name"].ToString().Trim();
CB_Type.Text = dst.Tables[0].Rows[0]["Member_type"].ToString().Trim();
TB_BZ.Text = dst.Tables[0].Rows[0]["Beizhu"].ToString().Trim();
DTP_Djrq.Text = dst.Tables[0].Rows[0]["Member_DJRQ"].ToString().Trim();
}
}
catch { }
}
public List <tb_membertype> Find(tb_membertype p)
{
string res = http.Get(GetUrl(RequestEnum.tb_membertype), p).ReadAsStringAsync().Result;
return(res.ToDeserialize <List <tb_membertype> >());
}
public int Delete(tb_membertype p)
{
string res = http.Delete(GetUrl(RequestEnum.tb_membertype), p).ReadAsStringAsync().Result;
return(res.ToDeserialize <int>());
}
public int Update(tb_membertype p)
{
string res = http.Put(GetUrl(RequestEnum.tb_membertype), p).ReadAsStringAsync().Result;
return(res.ToSerializer <int>());
}
public int Delete(tb_membertype parameter)
{
tb_membertypeBLL bll = new tb_membertypeBLL();
return(bll.Delete(parameter));
}
public int Put([FromBody] tb_membertype parameter)
{
tb_membertypeBLL bll = new tb_membertypeBLL();
return(bll.Update(parameter));
}
public int Post([FromBody] tb_membertype parameter)
{
tb_membertypeBLL bll = new tb_membertypeBLL();
return(bll.Add(parameter));
}
public IEnumerable <tb_membertype> Get(tb_membertype parameter)
{
tb_membertypeBLL bll = new tb_membertypeBLL();
return(bll.Find(parameter));
}
