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