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