protected void givTWmember_RowCommand(object sender, GridViewCommandEventArgs e)
{
string[] args = e.CommandArgument.ToString().Split(':');
if (args.Length != 3)
{
ScriptHelper.SetAlert(Page, GetTran("001089", "数据异常！"));
return;
}
if (args[2].Trim() == "2")
{
ScriptHelper.SetAlert(Page, GetTran("001334", "会员已经恢复注销！"));
return;
}
int id = Convert.ToInt32(args[0]);
string number = args[1];
string Operator = Session["Company"].ToString();
string OperatorName = DataBackupBLL.GetNameByAdminID(Operator);
if (e.CommandName == "OK")
{
int insertCon = MemberOffBLL.getUpdateMemberZX(number, CommonDataBLL.getMaxqishu(), id, DateTime.UtcNow, Operator, OperatorName);
if (insertCon > 0)
{
ScriptHelper.SetAlert(Page, GetTran("001338", "确定完成"));
}
else
{
ScriptHelper.SetAlert(Page, GetTran("007132", "恢复注销失败"));
}
btnSeach_Click(null, null);
}
}
protected void btnquery_Click(object sender, EventArgs e)
{
string number = txtNumber.Text.Trim();
//判断会员是否存在
if (txtNumber.Text.Trim() != "")
{
string sql = "select number from MemberInfo where MobileTele='" + txtNumber.Text + "'";
DataTable shj = DBHelper.ExecuteDataTable(sql);
if (shj.Rows.Count > 0)
{
number = shj.Rows[0][0].ToString();
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert(' 无此手机号，请检查后再重新输入 ！')</script>");
return;
}
}
if (Request.QueryString["type"] == null)
{
int con = MemberOffBLL.getMember(number);
if (con == 0)
{
LabelResponse.Text = "<font color='red'>" + GetTran("000599", "会员") + "" + txtNumber.Text + "" + GetTran("000801", "不存在，请重新输入") + "！</font>";
return;
}
if (MemberOffBLL.getMemberZX(number) > 0)
{
int con1 = MemberOffBLL.getMemberSPISzx(number);
//判断会员是否已冻结
if (con1 == 1)
{
LabelResponse.Text = "<font color='red'>" + GetTran("000599", "会员") + "" + number + "" + GetTran("007563", "已经冻结，不需要再次冻结了") + "！</font>";
return;
}
}
string zxname = GetTran("001286", "已冻结");
zxname = Encryption.Encryption.GetEncryptionName(zxname);
DateTime nowTime = DateTime.Now.AddHours(Convert.ToDouble(Session["WTH"]));
string offReason = txtMemberOffreason.Text;
MemberOffModel mom = new MemberOffModel();
mom.Number = number;
mom.Zxqishu = CommonDataBLL.getMaxqishu();
mom.Zxfate = DateTime.Now.ToUniversalTime();
mom.OffReason = txtMemberOffreason.Text;
mom.OperatorNo = txtOperatorNo.Text;
mom.OperatorName = txtOperatorName.Text;
int insertCon = MemberOffBLL.getInsertMemberSPZX(mom, zxname);
if (insertCon > 0)
{
msg = "<script language='javascript'>alert('" + GetTran("007564", "冻结会员成功") + "！');window.location.href='MemberSPOffView.aspx';</script>";
}
}
else
{
//int id = Convert.ToInt32(DAL.DBHelper.ExecuteScalar("select top 1 id from memberOffSP where number='" + txtNumber.Text.Trim() + "' order by zxdate desc"));
DataTable dt = DAL.DBHelper.ExecuteDataTable("select top 1 id,isnull(name,'') as name,isnull(storeid,'') as storeid,isnull(papernumber,'')as papernumber,isnull(mobiletele,'') as mobiletele from memberoffsp where number='" + number + "' order by zxdate desc");
if (dt.Rows.Count > 0)
{
string reason = txtMemberOffreason.Text;
string opert = Session["company"].ToString();
string opname = GetTran("000151", "管理员");
string storeid = dt.Rows[0]["storeid"].ToString();
string name = dt.Rows[0]["name"].ToString();
string papernumber = dt.Rows[0]["papernumber"].ToString();
string mobiletele = dt.Rows[0]["mobiletele"].ToString();
int id = int.Parse(dt.Rows[0]["id"].ToString());
SqlTransaction tran = null;
SqlConnection con = DAL.DBHelper.SqlCon();
con.Open();
tran = con.BeginTransaction();
try
{
string sql_insert = "insert into memberoffsp(number,[name],zxqishu,storeid,papernumber,mobiletele,iszx,offreason,operator,operatorname,zxdate) values(@number,@name,@zxqishu,@storeid,@papernumber,@mobiletele,2,@offreason,@operator,@operatorname,@zxdate)";
SqlParameter[] sps = { new SqlParameter("@number", number), new SqlParameter("@name", name), new SqlParameter("@zxqishu", CommonDataBLL.getMaxqishu()), new SqlParameter("@storeid", storeid), new SqlParameter("@papernumber", papernumber), new SqlParameter("@mobiletele", mobiletele), new SqlParameter("@operator", opert), new SqlParameter("@operatorname", opname), new SqlParameter("@zxdate", DateTime.Now.ToUniversalTime()), new SqlParameter("@offreason", reason) };
int ret = DAL.DBHelper.ExecuteNonQuery(tran, sql_insert, sps, CommandType.Text);
if (ret > 0)
{
string sql_updateOff = "update memberoffsp set [type]=1,operator=@Operator,operatorname=@OperatorName where id=@id and iszx=1";
SqlParameter[] sp_updateOff = { new SqlParameter("@Operator", opert), new SqlParameter("@operatorname", opname), new SqlParameter("@id", id) };
int ret1 = DAL.DBHelper.ExecuteNonQuery(tran, sql_updateOff, sp_updateOff, CommandType.Text);
if (ret1 > 0)
{
string sql_updateMember = "update memberinfo set memberstate=1 where number=@number";
SqlParameter[] sp_updateMember = { new SqlParameter("@number", number) };
int ret2 = DAL.DBHelper.ExecuteNonQuery(tran, sql_updateMember, sp_updateMember, CommandType.Text);
if (ret2 > 0)
{
tran.Commit();
con.Close();
ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('" + GetTran("007565", "恢复解冻完成!") + "');location.href='MemberRestoreSPOff.aspx';", true);
}
else
{
tran.Rollback(); con.Close(); ScriptHelper.SetAlert(Page, GetTran("007566", "恢复解冻失败"));
}
}
else
{
tran.Rollback(); con.Close(); ScriptHelper.SetAlert(Page, GetTran("007566", "恢复解冻失败"));
}
}
else
{
tran.Rollback();
con.Close();
ScriptHelper.SetAlert(Page, GetTran("007566", "恢复解冻失败"));
}
}
catch {
tran.Rollback();
con.Close();
ScriptHelper.SetAlert(Page, GetTran("007566", "恢复解冻失败"));
}
}
}
}
protected void btnquery_Click(object sender, EventArgs e)
{
string number = txtNumber.Text.Trim();
//判断会员是否存在
int con = MemberOffBLL.getMember(number);
if (con == 0)
{
ScriptHelper.SetAlert(Page, GetTran("000599", "会员") + "" + number + "" + GetTran("000801", "不存在，请重新输入") + "！");
return;
}
if (MemberOffBLL.getMemberZX(number) > 0)
{
int con1 = MemberOffBLL.getMemberISzx(number);
if (Request.QueryString["type"] != null && Request.QueryString["type"] == "1")
{
//判断会员是否已注销
if (con1 == 1)
{
ScriptHelper.SetAlert(Page, GetTran("000599", "会员") + "" + number + "" + GetTran("001310", "已经注销，不需要再次注销了") + "！");
return;
}
}
else
{
if (con1 == 2)
{
ScriptHelper.SetAlert(Page, GetTran("000599", "会员") + "" + number + "" + GetTran("001310", "已经恢复注销，不需要再次恢复注销了") + "！");
return;
}
}
}
string zxname = GetTran("001286", "已注销");
zxname = Encryption.Encryption.GetEncryptionName(zxname);
DateTime nowTime = DateTime.Now.AddHours(Convert.ToDouble(Session["WTH"]));
string offReason = txtMemberOffreason.Text;
MemberOffModel mom = new MemberOffModel();
mom.Number = number;
mom.Zxqishu = CommonDataBLL.getMaxqishu();
mom.Zxfate = DateTime.UtcNow;
mom.OffReason = txtMemberOffreason.Text;
mom.OperatorNo = txtOperatorNo.Text;
mom.OperatorName = txtOperatorName.Text;
if (Request.QueryString["type"] != null && Request.QueryString["type"] == "1")
{
int insertCon = MemberOffBLL.getInsertMemberZX(mom, zxname);
if (insertCon > 0)
{
msg = "<script language='javascript'>alert('" + GetTran("001312", "注销会员成功") + "！');window.location.href='MemberOffView.aspx';</script>";
}
}
else
{
string id = DAL.DBHelper.ExecuteScalar("select top 1 id from memberOff where number='" + number + "' order by zxdate desc").ToString();
int insertCon = MemberOffBLL.getUpdateMemberZX(mom.Number, CommonDataBLL.getMaxqishu(), Convert.ToInt32(id), DateTime.UtcNow, mom.OperatorNo, mom.OperatorName);
if (insertCon > 0)
{
ScriptHelper.SetAlert(Page, GetTran("001338", "确定完成"));
}
else
{
ScriptHelper.SetAlert(Page, GetTran("007132", "恢复注销失败"));
}
}
}
