/// <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();
}
}
}
