protected void btn_re_Click(object sender, EventArgs e)
{
string number = txtbh.Text.Trim();
string direct = DisposeString.DisString(this.txttuijian.Text, "'", "").Trim();
string sqltele = "select number from MemberInfo where MobileTele='" + direct + "'";
DataTable shjjjj = DBHelper.ExecuteDataTable(sqltele);
string sql = "select number from MemberInfo where MobileTele='" + number + "'";
DataTable shj = DBHelper.ExecuteDataTable(sql);
number = shj.Rows[0][0].ToString();
if (shjjjj.Rows.Count > 0)
{
direct = shjjjj.Rows[0][0].ToString();
string olddirect = "";
if (ViewState["oldTj"] != null)
{
olddirect = ViewState["oldTj"].ToString();
}
if (this.lblbh.Text.Trim() == "")
{
lblmessage.Text = GetTran("000723", "会员编号不能为空!");
return;
}
if (direct == "")
{
lblmessage.Text = GetTran("000716", "推荐编号不能为空!");
return;
}
if (ChangeTeamBLL.CheckNum(direct))
{
lblmessage.Text = GetTran("000717", "推荐编号不存在!");
return;
}
string manageId = BLL.CommonClass.CommonDataBLL.getManageID(3);
if (this.txtbh.Text.Trim() == manageId)
{
ScriptHelper.SetAlert(Page, manageId + GetTran("000714", "不可以调网") + "！");
return;
}
lblmessage.Text = "";
Application.Lock();
int newqushu = 1; //AddOrderDataDAL.GetDistrict(placement, 1);
DateTime nowTime = DateTime.UtcNow;
int maxExpectNum = CommonDataBLL.GetMaxqishu();
int j = 0;
j = TempHistoryDAL.ExecuteUpdateNet(number, olddirect, direct, 0, maxExpectNum, newqushu, CommonDataBLL.OperateBh, nowTime);
if (j >= 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('调网成功');window.location.href='../twQuery.aspx';</script>");
}
else
{
this.lblwz.Text = "";
this.lblbh.Text = "";
this.lbltuijian.Text = "";
this.txttuijian.Text = "";
this.txtbh.Text = "";
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('调网失败');</script>");
}
Application.UnLock();
}
}
/// <summary>
/// 获取网络信息
/// </summary>
/// <param name="number"></param>
/// <returns></returns>
public static DataTable GetNetMessage(string number)
{
return(TempHistoryDAL.GetNetMessage(number));
}
/// <summary>
/// 调整网络方法
/// </summary>
/// <param name="number">会员编号</param>
/// <param name="placement">新安置</param>
/// <param name="direct">新推荐</param>
/// <param name="oldplacement">原安置</param>
/// <param name="olddirect">原推荐</param>
/// <param name="newqushu"></param>
/// <param name="flag"></param>
/// <param name="isPass"></param>
/// <returns></returns>
public static string ChenageNet(string number, string placement, string direct, string oldplacement, string olddirect, int newqushu, int flag, out bool isPass)
{
string topMemberID = BLL.CommonClass.CommonDataBLL.GetTopManageID(3);
int xs = 0;
//if (placement != topMemberID)
//{
// xs = 3;
//}
//@bianhao--调网编号
//@srcAnZhi--原安置
//@dirAnZhi--新安置
//@srcTuiJian--原推荐
//@dirTuiJian--新推荐
//@azXianShu--0:表示无限制，大于0则表示最大的线数
//@info output --失败时返回错误信息，反之返回'OK'
string info = "";
/*
* @bianhao nvarchar(20), --调网编号
* @srcAnZhi nvarchar(20), --原安置
* @dirAnZhi nvarchar(20), --新安置
* @srcTuiJian nvarchar(20), --原推荐
* @dirTuiJian nvarchar(20), --新推荐
* @azXianShu int, --0:表示无限制，大于0则表示最大的线数
* @info nvarchar(200) output --失败时返回错误信息，反之返回'OK' */
//info = TempHistoryDAL.ChangeCheck(number, placement, direct, oldplacement, olddirect, newqushu, xs, info);
//if (info != "OK")
//{
// isPass = false;
// return info;
//}
int maxExpectNum = CommonDataBLL.GetMaxqishu();
//调层位序号
//@bianhao varchar(20), --编号
//@old varchar(20),--原位置
//@new varchar(20),--新位置
//@IsAz bit, --0：推荐；1：安置
//@qishu int --调网期
//TempHistoryDAL.ExecuteUpdateNew(number, placement, direct, tran, maxExpectNum, flag);
DateTime nowTime = DateTime.UtcNow;
int j = 0;
//调安置
//if (oldplacement.Trim() != placement.Trim())
//{
// j = TempHistoryDAL.ExecuteUpdateNet(number, oldplacement, placement, 1, maxExpectNum, newqushu, CommonDataBLL.OperateBh, nowTime);
//}
//调推荐
if (olddirect.Trim() != direct.Trim())
{
j = TempHistoryDAL.ExecuteUpdateNet(number, olddirect, direct, 0, maxExpectNum, newqushu, CommonDataBLL.OperateBh, nowTime);
}
if (j >= 0)
{
isPass = true;
return(new BLL.TranslationBase().GetTran("007134", "调网成功") + "!");
}
else
{
isPass = false;
return(new BLL.TranslationBase().GetTran("007135", "调网失败") + "!");
}
}
public static int GetFlag(string number)
{
return(TempHistoryDAL.GetFlag(number));
}
/// <summary>
/// 修改推荐或者安置编号
/// </summary>
/// <param name="number">会员编号</param>
/// <param name="placement">新安置</param>
/// <param name="direct">新推荐</param>
/// <param name="oldplacement">原安置</param>
/// <param name="olddirect">原推荐</param>
/// <returns></returns>
public static string UpdateNet(string number, string placement, string direct, string oldplacement, string olddirect, int qushu, int flag, out bool isPass)
{
BLL.CommonClass.ChangeLogs cl_h_info = new BLL.CommonClass.ChangeLogs("MemberInfo", "Number");//申明日志对象
using (SqlConnection conn = new SqlConnection(DBHelper.connString))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
int xs = 0;
string info = "";
try
{
/*
* @bianhao nvarchar(20), --调网编号
* @srcAnZhi nvarchar(20), --原安置
* @dirAnZhi nvarchar(20), --新安置
* @srcTuiJian nvarchar(20), --原推荐
* @dirTuiJian nvarchar(20), --新推荐
* @azXianShu int, --0:表示无限制，大于0则表示最大的线数
* @info nvarchar(200) output --失败时返回错误信息，反之返回'OK'
*/
info = TempHistoryDAL.ChangeCheck(number, placement, direct, oldplacement, olddirect, qushu, tran, xs, info);
if (info != "OK")
{
isPass = false;
return(info);
}
int maxExpectNum = CommonDataBLL.GetNumberRegExpect(number);
//调层位序号
//@bianhao varchar(20), --编号
//@old varchar(20),--原位置
//@new varchar(20),--新位置
//@IsAz bit, --0：推荐；1：安置
//@qishu int --调网期
TempHistoryDAL.UpdateNet(number, placement, direct, tran, maxExpectNum, flag);
int count = TempHistoryDAL.UpdateMemberinfo(number, placement, direct, tran);
if (count == 0)
{
isPass = false;
tran.Rollback();
return("修改失败！");
}
count = TempHistoryDAL.UpdateConfig(maxExpectNum, tran);
if (count == 0)
{
isPass = false;
tran.Rollback();
return("修改失败！");
}
cl_h_info.AddRecordtran(tran, number);
if (System.Web.HttpContext.Current.Session["Company"] != null)
{
cl_h_info.ModifiedIntoLogstran(tran, CommonClass.ChangeCategory.Order, number, BLL.CommonClass.ENUM_USERTYPE.objecttype5);
}
else if (System.Web.HttpContext.Current.Session["Store"] != null)
{
cl_h_info.ModifiedIntoLogstran(tran, CommonClass.ChangeCategory.Order, number, BLL.CommonClass.ENUM_USERTYPE.objecttype5);
}
}
catch (Exception ex)
{
isPass = false;
string assdgs = ex.Message;
tran.Rollback();
return(assdgs);
}
tran.Commit();
isPass = true;
return("修改成功!");
}
catch
{
tran.Rollback();
throw;
}
finally
{
conn.Close();
conn.Dispose();
}
}
}
