public void getMessage(int ApplyID) { Tz888.BLL.Register.VIPMemberRegister obj = new Tz888.BLL.Register.VIPMemberRegister(); Tz888.Model.Register.VIPMemberRegister model = new Tz888.Model.Register.VIPMemberRegister(); model = obj.GetVIPMemberModel(ApplyID); hidManageType.Value = model.ManageTypeID.ToString(); if (model.ManageTypeID.Trim() == "2003") { radioManageType1.Checked = true; } if (model.ManageTypeID.Trim() == "2001") { radioManageType3.Checked = true; } rblBuyTerm.SelectedValue = model.BuyTerm.ToString(); tbOrgName.Text = model.OrgName; tbRealName.Text = model.RealName; tbPosition.Text = model.Position; rblSex.SelectedValue = model.Sex.ToString(); txtTelCountry.Text = model.TelCountryCode; txtTelZoneCode.Text = model.TelStateCode; txtTelNumber.Text = model.TelNum; txtMobile.Text = model.Mobile; txtEmail.Text = model.Email; }
public void getMessage(int ApplyID) { Tz888.BLL.Register.VIPMemberRegister obj = new Tz888.BLL.Register.VIPMemberRegister(); Tz888.Model.Register.VIPMemberRegister model = new Tz888.Model.Register.VIPMemberRegister(); try { model = obj.GetVIPMemberModel(ApplyID); lbOrgName.Text = model.OrgName; lbtbRealName.Text = model.RealName; lbSex.Text = model.Sex ? "男士" : "女士"; if (model.BuyTerm.ToString().Trim() == "1") { lbBuyTerm.Text = "三个月"; } else if (model.BuyTerm.ToString().Trim() == "2") { lbBuyTerm.Text = "半年"; } else if (model.BuyTerm.ToString().Trim() == "3") { lbBuyTerm.Text = "一年"; } switch (model.ManageTypeID.Trim()) { case "1001": lbManageType.Text = "个人"; lbPrice.Text = obj.getPriceByType("1001", Convert.ToInt32(model.BuyTerm.ToString().Trim())); break; case "1003": lbManageType.Text = "企业"; lbPrice.Text = obj.getPriceByType("1003", Convert.ToInt32(model.BuyTerm.ToString().Trim())); break; case "1004": lbManageType.Text = "政府"; lbPrice.Text = obj.getPriceByType("1004", Convert.ToInt32(model.BuyTerm.ToString().Trim())); break; } } catch { } lbTel.Text = model.TelCountryCode + "-" + model.TelStateCode + "-" + model.TelNum; lbEmail.Text = model.Email; }
public void getMessage(int ApplyID) { Tz888.BLL.Register.VIPMemberRegister obj = new Tz888.BLL.Register.VIPMemberRegister(); Tz888.Model.Register.VIPMemberRegister model = new Tz888.Model.Register.VIPMemberRegister(); model = obj.GetVIPMemberModel(ApplyID); lbOrgName.Text = model.OrgName; lbtbRealName.Text = model.RealName; lbSex.Text = model.Sex ? "男士" : "女士"; switch (model.BuyTerm.ToString()) { case "1": lbBuyTerm.Text = "3个月"; break; case "2": lbBuyTerm.Text = "半年"; break; case "3": lbBuyTerm.Text = "一年"; break; default: break; } switch (model.ManageTypeID.Trim()) { case "1001": lbManageType.Text = "[个人]"; lbPrice.Text = obj.getPriceByType("1001", Convert.ToInt32(model.BuyTerm.ToString().Trim())); break; case "1003": lbManageType.Text = "[企业]"; lbPrice.Text = obj.getPriceByType("1003", Convert.ToInt32(model.BuyTerm.ToString().Trim())); break; case "1004": lbManageType.Text = "[政府]"; lbPrice.Text = obj.getPriceByType("1004", Convert.ToInt32(model.BuyTerm.ToString().Trim())); break; } lbTel.Text = model.TelCountryCode + "-" + model.TelStateCode + "-" + model.TelNum; lbEmail.Text = model.Email; }
public void getMessageForUpdate(int ApplyID) { Tz888.BLL.Register.VIPMemberRegister obj = new Tz888.BLL.Register.VIPMemberRegister(); Tz888.Model.Register.VIPMemberRegister model = new Tz888.Model.Register.VIPMemberRegister(); model = obj.GetVIPMemberModel(ApplyID); if (Page.User.IsInRole("MT2003")) { managetype.Text = "项目方"; this.ViewState["ManageType"] = "2003"; } if (Page.User.IsInRole("MT2002")) { managetype.Text = "投资机构"; this.ViewState["ManageType"] = "2002"; } if (Page.User.IsInRole("MT2001")) { managetype.Text = "政府机构"; this.ViewState["ManageType"] = "2001"; } rblBuyTerm.SelectedValue = model.BuyTerm.ToString(); tbOrgName.Text = model.OrgName; tbRealName.Text = model.RealName; tbPosition.Text = model.Position; if (model.Sex) { rblSex.SelectedIndex = 0; } else { rblSex.SelectedIndex = 1; } //rblSex.SelectedValue = model.Sex.ToString(); txtTelCountry.Text = model.TelCountryCode; txtTelZoneCode.Text = model.TelStateCode; txtTelNumber.Text = model.TelNum; txtMobile.Text = model.Mobile; txtEmail.Text = model.Email; }
public bool AuditVIPMember(Tz888.Model.Register.VIPMemberRegister model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@ApplyID", SqlDbType.Int, 4), new SqlParameter("@LoginName", SqlDbType.Char, 16), new SqlParameter("@AuditStatus", SqlDbType.SmallInt, 2), new SqlParameter("@ManageTypeID", SqlDbType.SmallInt, 2), new SqlParameter("@CycleID", SqlDbType.SmallInt, 2), new SqlParameter("@VIPValidateDate", SqlDbType.DateTime), new SqlParameter("@MarketPersonName", SqlDbType.VarChar, 30), new SqlParameter("@IsPay", SqlDbType.TinyInt, 1), new SqlParameter("@Status", SqlDbType.SmallInt, 2) }; parameters[0].Value = model.ApplyID; parameters[1].Value = model.LoginName; parameters[2].Value = model.OprStatus; parameters[3].Value = model.ManageTypeID; parameters[4].Value = model.BuyTerm; parameters[5].Value = model.VIPValidateDate; parameters[6].Value = model.OprMan; parameters[7].Value = model.IsPay; parameters[8].Direction = ParameterDirection.Output;////--0成功 1逻辑失败 2数据库失败*/ DbHelperSQL.RunProcedure("VIP_MEMBER_AUDIT", parameters, out rowsAffected); if (rowsAffected > 0)//parameters[0].Value.ToString() == "0")// Status = (int)parameters[8].Value; { return(true); } else { return(false); } }
protected void ibOK_Click(object sender, ImageClickEventArgs e) { Tz888.Model.Register.VIPMemberRegister modelInfo = new Tz888.Model.Register.VIPMemberRegister(); Tz888.BLL.Register.VIPMemberRegister obj = new Tz888.BLL.Register.VIPMemberRegister(); modelInfo.ApplyID = 0; modelInfo.LoginName = ""; modelInfo.ManageTypeID = hidManageType.Value != "" ?hidManageType.Value:"1003"; modelInfo.BuyTerm = Convert.ToInt16(rblBuyTerm.SelectedValue); modelInfo.OrgName = tbOrgName.Text; modelInfo.RealName = tbRealName.Text; modelInfo.Position = tbPosition.Text;//职务 modelInfo.Sex = Convert.ToBoolean(rblSex.SelectedValue); modelInfo.TelCountryCode = txtTelCountry.Text; modelInfo.TelStateCode = txtTelZoneCode.Text; modelInfo.TelNum = txtTelNumber.Text; modelInfo.Mobile = txtMobile.Text; modelInfo.Email = txtEmail.Text; modelInfo.ApplyDate = DateTime.Now; modelInfo.IsPay = 0; //是否付费 modelInfo.OprStatus = 0; // 审核状态:0未审核、1审核为拓富通会员、2已审核(已审基本信息)、3审核不通过、4退款、 modelInfo.OprDescript = ""; modelInfo.OprMan = ""; modelInfo.OprDate = DateTime.Now; modelInfo.Memo = ""; modelInfo.MarketPersonName = ""; modelInfo.VIPValidateDate = DateTime.Now;//生效时间 modelInfo.Money = 0; modelInfo.Years = Convert.ToInt16(rblBuyTerm.SelectedValue); modelInfo.Price = 0; modelInfo.ServiceType = "2001"; if (modelInfo.OrgName == "" && this.hidManageType.Value != "1001") { Tz888.Common.MessageBox.Show(this.Page, "公司名称不能为空"); return; } if (modelInfo.RealName == "") { Tz888.Common.MessageBox.Show(this.Page, "真实姓名不能为空"); return; } if (modelInfo.Email == "") { Tz888.Common.MessageBox.Show(this.Page, "'Email不能为空"); return; } if (this.ViewState["tag"].ToString() == "add") { this.ViewState["ApplyID"] = obj.AddVIPMember(modelInfo); } else if (this.ViewState["tag"].ToString() == "update") { bool bl = obj.UpdateVIPMember(modelInfo); } if (Convert.ToInt32(this.ViewState["ApplyID"]) > 0) { Response.Redirect("VIPRegisterSubmit.aspx?ApplyID=" + this.ViewState["ApplyID"]); } }
/// <summary> /// 审核拓富通会员 /// </summary> /// <param name="LoginName"></param> /// <param name="ManageTypeID"></param> /// <param name="CycleID"></param> /// <returns></returns> public bool UpdateVIPMember_sh(Tz888.Model.Register.VIPMemberRegister model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@ApplyID", SqlDbType.Int, 4), // //new SqlParameter("@LoginName", SqlDbType.Char,16), new SqlParameter("@ManageTypeID", SqlDbType.Char, 10), // new SqlParameter("@BuyTerm", SqlDbType.SmallInt, 2), // //new SqlParameter("@OrgName", SqlDbType.Char,16), //new SqlParameter("@RealName", SqlDbType.VarChar,30), //new SqlParameter("@Position", SqlDbType.VarChar,50), //new SqlParameter("@Sex", SqlDbType.Bit,1), //new SqlParameter("@TelCountryCode", SqlDbType.Char,3), //new SqlParameter("@TelStateCode", SqlDbType.Char,4), //new SqlParameter("@TelNum", SqlDbType.VarChar,60), //new SqlParameter("@Mobile", SqlDbType.VarChar,30), //new SqlParameter("@Email", SqlDbType.VarChar,50), //new SqlParameter("@ApplyDate", SqlDbType.DateTime), //new SqlParameter("@IsPay", SqlDbType.TinyInt,1), //new SqlParameter("@OprStatus", SqlDbType.SmallInt,2), //new SqlParameter("@OprDescript", SqlDbType.VarChar,500), new SqlParameter("@OprMan", SqlDbType.VarChar, 30), // //new SqlParameter("@OprDate", SqlDbType.DateTime),// new SqlParameter("@Memo", SqlDbType.VarChar, 100), // //new SqlParameter("@MarketPersonName", SqlDbType.Char,16), //new SqlParameter("@VIPValidateDate", SqlDbType.DateTime), ////new SqlParameter("@Money", SqlDbType.Money), ////new SqlParameter("@Years", SqlDbType.Int), //new SqlParameter("@ServiceType", SqlDbType.Char,10), //new SqlParameter("@Price", SqlDbType.Money) }; parameters[0].Value = model.ApplyID; //parameters[1].Value = model.LoginName; parameters[1].Value = model.ManageTypeID; parameters[2].Value = model.BuyTerm; //parameters[4].Value = model.OrgName; //parameters[5].Value = model.RealName; //parameters[6].Value = model.Position; //parameters[7].Value = model.Sex; //parameters[8].Value = model.TelCountryCode; //parameters[9].Value = model.TelStateCode; //parameters[10].Value = model.TelNum; //parameters[11].Value = model.Mobile; //parameters[12].Value = model.Email; // parameters[13].Value = model.ApplyDate; //parameters[13].Value = model.IsPay; //parameters[14].Value = model.OprStatus; //parameters[15].Value = model.OprDescript; parameters[3].Value = model.OprMan; //parameters[17].Value = model.OprDate; parameters[4].Value = model.Memo; //parameters[19].Value = model.MarketPersonName; //parameters[21].Value = model.VIPValidateDate; ////parameters[22].Value = model.Money; ////parameters[23].Value = model.Years; ////parameters[24].Value = model.ServiceType; ////parameters[25].Value = model.Price; DbHelperSQL.RunProcedure("UP_VipApplyTab_Update", parameters, out rowsAffected); if (rowsAffected > 0) { return(true); } else { return(false); } }
public Tz888.Model.Register.VIPMemberRegister GetVIPMemberModel(int ApplyID) { SqlParameter[] parameters = { new SqlParameter("@ApplyID", SqlDbType.Int, 4) }; parameters[0].Value = ApplyID; Tz888.Model.Register.VIPMemberRegister model = new Tz888.Model.Register.VIPMemberRegister(); DataSet ds = DbHelperSQL.RunProcedure("UP_VipApplyTab_GetModel", parameters, "ds"); model.ApplyID = ApplyID; if (ds.Tables[0].Rows.Count > 0) { model.LoginName = ds.Tables[0].Rows[0]["LoginName"].ToString(); if (ds.Tables[0].Rows[0]["ManageTypeID"].ToString() != "") { model.ManageTypeID = ds.Tables[0].Rows[0]["ManageTypeID"].ToString(); } if (ds.Tables[0].Rows[0]["BuyTerm"].ToString() != "") { model.BuyTerm = int.Parse(ds.Tables[0].Rows[0 ]["BuyTerm"].ToString()); } model.OrgName = ds.Tables[0].Rows[0]["OrgName"].ToString(); model.RealName = ds.Tables[0].Rows[0]["RealName"].ToString(); model.Position = ds.Tables[0].Rows[0]["Position"].ToString(); if (ds.Tables[0].Rows[0]["Sex"].ToString() != "") { if ((ds.Tables[0].Rows[0]["Sex"].ToString().Trim().ToLower() == "false")) { model.Sex = false; //model.Email = "ffff"; } else { model.Sex = true; //model.Email = "tttt"; } } model.TelCountryCode = ds.Tables[0].Rows[0]["TelCountryCode"].ToString(); model.TelStateCode = ds.Tables[0].Rows[0]["TelStateCode"].ToString(); model.TelNum = ds.Tables[0].Rows[0]["TelNum"].ToString(); model.Mobile = ds.Tables[0].Rows[0]["Mobile"].ToString(); model.Email = ds.Tables[0].Rows[0]["Email"].ToString(); if (ds.Tables[0].Rows[0]["ApplyDate"].ToString() != "") { model.ApplyDate = DateTime.Parse(ds.Tables[0].Rows[0]["ApplyDate"].ToString()); } if (ds.Tables[0].Rows[0]["OprStatus"].ToString() != "") { model.OprStatus = int.Parse(ds.Tables[0].Rows[0]["OprStatus"].ToString()); } model.OprDescript = ds.Tables[0].Rows[0]["OprDescript"].ToString(); model.OprMan = ds.Tables[0].Rows[0]["OprMan"].ToString(); if (ds.Tables[0].Rows[0]["OprDate"].ToString() != "") { model.OprDate = DateTime.Parse(ds.Tables[0].Rows[0]["OprDate"].ToString()); } if (ds.Tables[0].Rows[0]["VIPValidateDate"].ToString() != "") { model.VIPValidateDate = DateTime.Parse(ds.Tables[0].Rows[0]["VIPValidateDate"].ToString()); } model.Memo = ds.Tables[0].Rows[0]["Memo"].ToString(); model.MarketPersonName = ds.Tables[0].Rows[0]["MarketPersonName"].ToString(); return(model); } else { return(null); } }
//审核拓富通会员 public bool UpdateVIPMember_sh(Tz888.Model.Register.VIPMemberRegister model) { return(dal.UpdateVIPMember_sh(model)); }
public bool AuditVIPMember(Tz888.Model.Register.VIPMemberRegister model) { return(dal.AuditVIPMember(model)); }
public int AddVIPMember(Tz888.Model.Register.VIPMemberRegister model) { return(dal.AddVIPMember(model)); }
protected void ibOK_Click(object sender, ImageClickEventArgs e) { //获取ManageTypeID Tz888.SQLServerDAL.Conn getOpWorker = new Tz888.SQLServerDAL.Conn(); DataTable dt = getOpWorker.GetList("logininfotab", "*", "ManageTypeID", 1, 1, 0, 1, "loginname='" + Page.User.Identity.Name + "'"); if (dt != null && dt.Rows.Count > 0) { this.ViewState["ManageType"] = dt.Rows[0]["ManageTypeID"].ToString(); } Tz888.Model.Register.VIPMemberRegister modelInfo = new Tz888.Model.Register.VIPMemberRegister(); Tz888.BLL.Register.VIPMemberRegister obj = new Tz888.BLL.Register.VIPMemberRegister(); modelInfo.LoginName = Page.User.Identity.Name; if (dt != null && dt.Rows.Count > 0) { modelInfo.ManageTypeID = this.ViewState["ManageType"].ToString(); } modelInfo.BuyTerm = Convert.ToInt16(rblBuyTerm.SelectedValue); modelInfo.OrgName = tbOrgName.Text; modelInfo.RealName = tbRealName.Text; modelInfo.Position = tbPosition.Text;//职务 modelInfo.Sex = Convert.ToBoolean(rblSex.SelectedValue); modelInfo.TelCountryCode = txtTelCountry.Text; modelInfo.TelStateCode = txtTelZoneCode.Text; modelInfo.TelNum = txtTelNumber.Text; modelInfo.Mobile = txtMobile.Text; modelInfo.Email = txtEmail.Text; modelInfo.ApplyDate = DateTime.Now; modelInfo.IsPay = 0; //是否付费 modelInfo.OprStatus = 0; // 审核状态:0未审核、1审核为拓富通会员、2已审核(已审基本信息)、3审核不通过、4退款、 modelInfo.OprDescript = ""; modelInfo.OprMan = ""; modelInfo.OprDate = DateTime.Now; modelInfo.Memo = ""; modelInfo.MarketPersonName = ""; modelInfo.VIPValidateDate = DateTime.Now;//生效时间 if (modelInfo.OrgName == "") { Tz888.Common.MessageBox.Show(this.Page, "公司名称不能为空"); return; } if (modelInfo.RealName == "") { Tz888.Common.MessageBox.Show(this.Page, "真实姓名不能为空"); return; } if (modelInfo.Email == "") { Tz888.Common.MessageBox.Show(this.Page, "Email"); return; } bool bl = true; try { if (this.ViewState["tag"].ToString() == "add") { modelInfo.ApplyID = 0; this.ViewState["ApplyID"] = obj.AddVIPMember(modelInfo); } else if (this.ViewState["tag"].ToString() == "update") { modelInfo.ApplyID = Convert.ToInt32(this.ViewState["ApplyID"]); bl = obj.UpdateVIPMember(modelInfo); } } catch { Tz888.Common.MessageBox.Show(this.Page, "信息输入有错。。。"); } if (Convert.ToInt32(this.ViewState["ApplyID"]) > 0 && bl == true) { Response.Redirect("VIPMemberSubmint_In.aspx?ApplyID=" + this.ViewState["ApplyID"]); } }