/// <summary>
/// 调网
/// </summary>
/// <param name="tran"></param>
/// <param name="number">编号</param>
/// <param name="old">原位置</param>
/// <param name="newbh">新位置</param>
/// <param name="isAzTj">0：推荐；1：安置</param>
/// <param name="qishu">期数</param>
public static int ExecuteUpdateNet(string number, string old, string newbh, int isAzTj, int qishu, string opreateBH, DateTime adjustdate)
{
int newqushu = 1;
if (isAzTj == 1)
{
newqushu = AddOrderDataDAL.GetDistrict(newbh, 1);
}
SqlParameter[] parm2 = { new SqlParameter("@Number", SqlDbType.VarChar, 30),
new SqlParameter("@old", SqlDbType.VarChar, 30),
new SqlParameter("@new", SqlDbType.VarChar, 30),
new SqlParameter("@IsAz", SqlDbType.Bit, 2),
new SqlParameter("@qishu", SqlDbType.Int),
new SqlParameter("@newqushu", SqlDbType.Int),
new SqlParameter("@opreateBH", SqlDbType.VarChar, 50),
new SqlParameter("@adjustdate", SqlDbType.DateTime) };
parm2[0].Value = number;
parm2[1].Value = old;
parm2[2].Value = newbh;
parm2[3].Value = isAzTj;
parm2[4].Value = qishu;
parm2[5].Value = newqushu;
parm2[6].Value = opreateBH;
parm2[7].Value = adjustdate;
return(DBHelper.ExecuteDataTable("js_UpdateNet_w", parm2, CommandType.StoredProcedure).Rows.Count);
}
/// <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 ChenageNet(string number, string placement, string direct, string oldplacement, string olddirect, int flag, out bool isPass)
{
string topMemberID = BLL.CommonClass.CommonDataBLL.GetTopManageID(3);
int newqushu = 1;
//调安置
if (oldplacement.Trim() != placement.Trim())
{
newqushu = AddOrderDataDAL.GetDistrict(placement, 1);
}
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", "调网失败") + "!");
}
}
protected void btnOk_Click(object sender, EventArgs e)
{
string number = this.labBh.Text;
string placement = SearchPlacement_DoubleLines1.Placement;
string direct = DisposeString.DisString(this.txtDirect.Text, "'", "").Trim();
string oldplacement = ViewState["placement"].ToString();
string olddirect = ViewState["direct"].ToString();
string storeid = ViewState["storeid"].ToString();
if (placement == "" || direct == "")
{
lblmessage.Text = GetTran("000716", "推荐编号或安置编号都不能为空!");
return;
}
if (ChangeTeamBLL.CheckNum(direct))
{
lblmessage.Text = GetTran("000717", "推荐编号不存在!");
return;
}
if (ChangeTeamBLL.CheckNum(placement))
{
lblmessage.Text = GetTran("000718", "安置编号不存在!");
return;
}
string topMemberId = BLL.CommonClass.CommonDataBLL.getManageID(3);
int district = Convert.ToInt32(ViewState["district"]);;
if (placement != topMemberId)
{
int flag_xiou = ChangeTeamBLL.GetPlacementCount(placement, number);
if (flag_xiou >= 2)
{
ScriptHelper.SetAlert(Page, GetTran("000000", "此安置编号下已经安置了两个人！"));
return;
}
if (DBHelper.ExecuteScalar("select count(0) from memberinfo where placement='" + placement + "' and District=" + direct + "").ToString() != "0")
{
district = AddOrderDataDAL.GetDistrict(placement, 1);
if (district == 1)
{
if (DBHelper.ExecuteScalar("select count(0) from memberinfo where placement='" + placement + "' and District=2").ToString() != "0")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("000000", "安置人所选区位已有人安置！") + "');</script>", false);
return;
}
}
else if (district == 2)
{
if (DBHelper.ExecuteScalar("select count(0) from memberinfo where placement='" + placement + "' and District=1").ToString() != "0")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("000000", "安置人所选区位已有人安置！") + "');</script>", false);
return;
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("000000", "安置人所选区位已有人安置！") + "');</script>", false);
return;
}
}
RegistermemberBLL registermemberBLL = new RegistermemberBLL();
string CheckMember = registermemberBLL.CheckMemberInProc(number, placement, direct, storeid);
CheckMember = new GroupRegisterBLL().GerCheckErrorInfo(CheckMember);
if (CheckMember != null)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + CheckMember + "');</script>", false);
return;
}
string p_info = registermemberBLL.GetHavePlacedOrDriect(number, "", placement, direct);
if (p_info != null)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + p_info + "');</script>", false);
return;
}
//判断该编号是否有安置，推荐
string GetError = registermemberBLL.GetError(direct, placement);
if (GetError != null)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetError + "');</script>", false);
return;
}
string GetError1 = new AjaxClass().CheckNumberNetAn(direct, placement);
if (GetError1 != null && GetError1 != "")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("005986", "安置编号必须在推荐编号的安置网络下面！") + "');</script>", false);
return;
}
#region 安置推荐人必须要激活
if (Convert.ToInt32(DAL.DBHelper.ExecuteScalar("select COUNT(0) from MemberInfo where MemberState=1 and Number='" + direct + "'")) == 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("000000", "招商编号未激活！") + "');</script>", false);
return;
}
if (Convert.ToInt32(DAL.DBHelper.ExecuteScalar("select COUNT(0) from MemberInfo where MemberState=1 and Number='" + placement + "'")) == 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + this.GetTran("000000", "互助编号未激活！") + "');</script>", false);
return;
}
#endregion
}
bool ispass = false;
if (ViewState["placement"].ToString() != placement || ViewState["direct"].ToString() != direct)
{
Application.Lock();
string msg = ChangeTeamBLL.UpdateNet(number, placement, direct, oldplacement, olddirect, district, ChangeTeamBLL.GetFlag(number), out ispass);
Application.UnLock();
ScriptHelper.SetAlert(Page, msg);
}
else
{
ScriptHelper.SetAlert(Page, this.GetTran("000000", "推荐、安置人编号未变化！"));
}
}
public MemberInfoModel AddUserInfo()
{
MemberInfoModel memberInfoModel = new MemberInfoModel();
memberInfoModel.Number = CommonDataBLL.quanjiao(HFNumber.Value.ToUpper());
memberInfoModel.Placement = CommonDataBLL.quanjiao(hidplacemnet.Value);
memberInfoModel.Direct = txtDirect.Text.Trim(); //Session["Member"].ToString();
memberInfoModel.ExpectNum = BLL.CommonClass.CommonDataBLL.getMaxqishu();
memberInfoModel.OrderID = "";
memberInfoModel.StoreID = "8888888888";
memberInfoModel.Name = "";
memberInfoModel.PetName = Encryption.Encryption.GetEncryptionName(txtName.Text.Trim());
memberInfoModel.OrderType = 21;
memberInfoModel.LoginPass = Encryption.Encryption.GetEncryptionPwd(memberInfoModel.Number, memberInfoModel.Number);
memberInfoModel.AdvPass = Encryption.Encryption.GetEncryptionPwd(memberInfoModel.Number, memberInfoModel.Number);
memberInfoModel.LevelInt = 0;//会员级别
memberInfoModel.RegisterDate = DateTime.UtcNow;
memberInfoModel.PaperType.Id = 0;
memberInfoModel.Birthday = Convert.ToDateTime("1990-01-01");
memberInfoModel.Sex = 0;
memberInfoModel.Assister = "";
memberInfoModel.OfficeTele = "";
memberInfoModel.HomeTele = "";
memberInfoModel.MobileTele = txtTele.Text;
memberInfoModel.FaxTele = "";
string country = this.CountryCity2.Country; //控件
string province = this.CountryCity2.Province; //控件
string city = this.CountryCity2.City; //控件
string xian = this.CountryCity2.Xian;
memberInfoModel.City.Country = country;
memberInfoModel.City.Province = province;
memberInfoModel.City.City = city;
memberInfoModel.City.Xian = xian;
memberInfoModel.CPCCode = DAL.CommonDataDAL.GetCPCCode(country, province, city, xian);
memberInfoModel.Address = Encryption.Encryption.GetEncryptionAddress(CommonDataBLL.quanjiao(this.txtAddress.Text.Trim()));
memberInfoModel.PostalCode = ""; //CommonDataBLL.quanjiao(this.Txtyb.Text.Trim());
var insert = @"INSERT INTO [ConsigneeInfo]
([Number],[Consignee],[MoblieTele],[CPCCode],[Address]
,IsDefault
)
VALUES
(@Number,@Consignee,@MoblieTele,@CPCCode,@Address,@IsDefault)";
SqlParameter[] insertpara =
{
new SqlParameter("@Number", SqlDbType.VarChar),
new SqlParameter("@Consignee", SqlDbType.VarChar),
new SqlParameter("@MoblieTele", SqlDbType.VarChar),
new SqlParameter("@CPCCode", SqlDbType.VarChar),
new SqlParameter("@Address", SqlDbType.VarChar),
new SqlParameter("@IsDefault", SqlDbType.Bit),
};
insertpara[0].Value = CommonDataBLL.quanjiao(HFNumber.Value.ToUpper());
insertpara[1].Value = Encryption.Encryption.GetEncryptionName(txtName.Text.Trim());
insertpara[2].Value = txtTele.Text;
insertpara[3].Value = DAL.CommonDataDAL.GetCPCCode(country, province, city, xian);
insertpara[4].Value = Encryption.Encryption.GetEncryptionAddress(CommonDataBLL.quanjiao(this.txtAddress.Text.Trim()));
insertpara[5].Value = true;
var insertvalue = DBHelper.ExecuteNonQuery(insert, insertpara, CommandType.Text);
string paperCode = null;
paperCode = "";
memberInfoModel.PaperType.PaperTypeCode = ""; //证件类型
memberInfoModel.PaperNumber = "";
memberInfoModel.BankCode = "";
memberInfoModel.BankAddress = "";
memberInfoModel.BankBook = memberInfoModel.Name;
memberInfoModel.BankCard = "";
//country = "";
//province = "";//控件
//city = "";//控件
//xian = "";
memberInfoModel.BCPCCode = DAL.CommonDataDAL.GetCPCCode(country, province, city, xian);
memberInfoModel.Remark = "";
memberInfoModel.ChangeInfo = "";
memberInfoModel.Email = "";
//memberInfoModel.District = SearchPlacement_DoubleLines1.District;
memberInfoModel.District = AddOrderDataDAL.GetDistrict(hidplacemnet.Value, Convert.ToInt32(hidDistrict.Value));
memberInfoModel.Answer = "";
memberInfoModel.Question = "";
memberInfoModel.IsBatch = Convert.ToInt32(ViewState["isBatch"]); //不是批量注册 modify
memberInfoModel.Language = 1;
memberInfoModel.OperateIp = CommonDataBLL.OperateIP; //调用方法
memberInfoModel.OperaterNum = CommonDataBLL.OperateBh; //调用方法
memberInfoModel.Error = ViewState["Error"] == null ? "" : ViewState["Error"].ToString();
memberInfoModel.Bankbranchname = "";
return(memberInfoModel);
}
