/// <summary>
///核心企业修改经销商登录信息
/// </summary>
/// <param name="JSon"></param>
/// <returns></returns>
public ResultEditResellerAccount EditResellerAccount(string JSon)
{
string UserID = string.Empty;
string CompID = string.Empty;
string AccountID = string.Empty;
string TrueName = string.Empty;
string ts = string.Empty;
try
{
#region//JSon取值
JsonData JInfo = JsonMapper.ToObject(JSon);
if (JInfo["UserID"].ToString().Trim() == "" || JInfo["CompID"].ToString().Trim() == "" || JInfo["AccountID"].ToString().Trim() == "" ||
JInfo["TrueName"].ToString().Trim() == "" || JInfo["ts"].ToString().Trim() == "")
{
return(new ResultEditResellerAccount()
{
Result = "F", Description = "参数异常"
});
}
UserID = JInfo["UserID"].ToString();
CompID = JInfo["CompID"].ToString();
AccountID = JInfo["AccountID"].ToString();
TrueName = Common.NoHTML(JInfo["TrueName"].ToString());
ts = JInfo["ts"].ToString();
//判断登录信息是否异常
Hi.Model.SYS_Users one = new Hi.Model.SYS_Users();
if (!new Common().IsLegitUser(int.Parse(UserID), out one, Int32.Parse(CompID)))
{
return(new ResultEditResellerAccount()
{
Result = "F", Description = "登录信息异常"
});
}
//判断核心企业信息是否异常
Hi.Model.BD_Company comp = new Hi.BLL.BD_Company().GetModel(Int32.Parse(CompID));
if (comp == null || comp.dr == 1 || comp.IsEnabled == 0 || comp.AuditState == 0)
{
return new ResultEditResellerAccount()
{
Result = "F", Description = "核心企业信息异常"
}
}
;
#endregion
//根据登录信息ID获取对应的sys_users中数据
Hi.BLL.SYS_Users bll_users = new Hi.BLL.SYS_Users();
Hi.Model.SYS_Users account = bll_users.GetModel(Int32.Parse(AccountID));
//判断用户信息是否正常
if (account == null)
{
return new ResultEditResellerAccount()
{
Result = "F", Description = "登录信息异常"
}
}
;
if (account.dr == 1)
{
return new ResultEditResellerAccount()
{
Result = "F", Description = "登录信息已被删除"
}
}
;
if (ts != account.ts.ToString())
{
return new ResultEditResellerAccount()
{
Result = "F", Description = "登录信息已被他人修改，请稍后再试"
}
}
;
//修改姓名
account.TrueName = TrueName;
if (!bll_users.Update(account))
{
return new ResultEditResellerAccount()
{
Result = "F", Description = "修改失败"
}
}
;
//成功需要将新的登录信息返回回去
class_ver3.Account result_account = new class_ver3.Account();
result_account.AccountID = account.ID.ToString();
result_account.UserName = account.UserName;
result_account.TrueName = account.TrueName;
result_account.Phone = account.Phone;
return(new ResultEditResellerAccount()
{
Result = "T", Description = "返回成功", Account = result_account
});
}
catch (Exception ex)
{
Common.CatchInfo(ex.Message + ":" + ex.StackTrace, "EidtResellerAccount:" + JSon);
return(new ResultEditResellerAccount()
{
Result = "F", Description = "修改失败"
});
}
}
/// <summary>
/// 获取经销商详情
/// </summary>
/// <param name="JSon"></param>
/// <returns></returns>
public ResultResellerDetail GetResellerDetail(string JSon)
{
string UserID = string.Empty;
string CompID = string.Empty;
string DisID = string.Empty;
try
{
#region//JSon取值
JsonData JInfo = JsonMapper.ToObject(JSon);
if (JInfo["UserID"].ToString().Trim() == "" || JInfo["CompID"].ToString().Trim() == "" || JInfo["ResellerID"].ToString().Trim() == "")
{
return new ResultResellerDetail()
{
Result = "F", Description = "参数异常"
}
}
;
UserID = JInfo["UserID"].ToString();
CompID = JInfo["CompID"].ToString();
DisID = JInfo["ResellerID"].ToString();
//判断登录信息是否异常
Hi.Model.SYS_Users one = new Hi.Model.SYS_Users();
if (!new Common().IsLegitUser(int.Parse(UserID), out one, Int32.Parse(CompID)))
{
return(new ResultResellerDetail()
{
Result = "F", Description = "登录信息异常"
});
}
//判断核心企业信息是否异常
Hi.Model.BD_Company comp = new Hi.BLL.BD_Company().GetModel(Int32.Parse(CompID));
if (comp == null || comp.dr == 1 || comp.IsEnabled == 0 || comp.AuditState == 0)
{
return new ResultResellerDetail()
{
Result = "F", Description = "核心企业信息异常"
}
}
;
//判断经销商信息是否异常
Hi.Model.BD_Distributor dis = new Hi.BLL.BD_Distributor().GetModel(Int32.Parse(DisID));
if (dis == null)
{
return new ResultResellerDetail()
{
Result = "F", Description = "经销商信息异常"
}
}
;
if (dis.dr == 1)
{
return new ResultResellerDetail()
{
Result = "F", Description = "经销商已被删除"
}
}
;
if (dis.AuditState == 0)
{
return new ResultResellerDetail()
{
Result = "F", Description = "经销商未审核"
}
}
;
#endregion
//获取经销商的返回信息
class_ver3.Reseller res = new class_ver3.Reseller();
res.ResellerID = dis.ID.ToString();
res.ResellerName = dis.DisName;
//拼接经销商地址
string area = string.Empty;
area += dis.Province;
if (dis.City != "市辖区")
{
area += dis.City;
}
area += dis.Area;
area += dis.Address;
res.ResellerAddr = area;
res.ResellerProvince = dis.Province;
res.ResellerCity = dis.City;
res.ResellerArea = dis.Area;
res.Address = dis.Address;
res.ResellerCode = dis.DisCode;
res.ResellerClassifyID = dis.DisTypeID.ToString();
//根据经销商分类ID获取分类名称
Hi.Model.BD_DisType dis_type = new Hi.BLL.BD_DisType().GetModel(dis.DisTypeID);
if (dis_type != null)
{
res.ResellerClassify = dis_type.TypeName;
}
else
{
res.ResellerClassify = "";
}
res.Zip = dis.Zip;
res.Tel = dis.Tel;
res.Fax = dis.Fax;
res.Principal = dis.Principal;
res.Phone = dis.Phone;
res.AreaID = dis.AreaID.ToString();
//根据经销商区域ID获取区域名称
Hi.Model.BD_DisArea dis_area = new Hi.BLL.BD_DisArea().GetModel(dis.AreaID);
if (dis_area != null)
{
res.AreaName = dis_area.AreaName;
}
else
{
res.AreaName = "";
}
res.IsEnabled = dis.IsEnabled.ToString();
res.ts = dis.ts.ToString();
#region //获取此经销商的开票信息
List <Hi.Model.BD_DisAccount> list_disinvoce = new Hi.BLL.BD_DisAccount().GetList("", "DisID=" + dis.ID + " and isnull(dr,0)=0", "CreateDate desc");
List <class_ver3.Invoce> list_invoce = new List <class_ver3.Invoce>();
if (list_disinvoce != null && list_disinvoce.Count > 0)
{
//循环赋值开票信息的返回信息
foreach (Hi.Model.BD_DisAccount dis_invoce in list_disinvoce)
{
class_ver3.Invoce invoce = new class_ver3.Invoce();
invoce.InvoceID = dis_invoce.ID.ToString();
invoce.TRNumber = ClsSystem.gnvl(dis_invoce.TRNumber, "");
invoce.InvoceType = invoce.TRNumber == "" ? "普通发票" : "增值税发票";
invoce.Rise = dis_invoce.Rise;
invoce.Content = dis_invoce.Content;
invoce.OBank = dis_invoce.OBank;
invoce.OAccount = dis_invoce.OAccount;
list_invoce.Add(invoce);
}
}
#endregion
#region//获取经销商的管理员登录账号
//先从SYS_CompUser表中取出对应sys_user表的ID
List <Hi.Model.SYS_CompUser> list_compuser = new Hi.BLL.SYS_CompUser().GetList("UserID",
"DisID=" + dis.ID + " and UType = 5 and isnull(dr,0)=0 and isnull(IsEnabled,0)=1 and isnull(IsAudit,0)=2", "");
//根据userid取出sys_user表数据,赋值给返回信息
Hi.Model.SYS_Users user = new Hi.BLL.SYS_Users().GetModel(list_compuser[0].UserID);
class_ver3.Account account = new class_ver3.Account();
if (user != null && user.AuditState == 2 && user.IsEnabled == 1 && user.dr == 0)
{
account.AccountID = user.ID.ToString();
account.UserName = user.UserName;
account.TrueName = user.TrueName;
account.Phone = user.Phone;
account.ts = user.ts.ToString();
}
#endregion
res.InvoceList = list_invoce;
res.Account = account;
string sqlstr = string.Format(@"select b.DisID, a.type, a.validDate, a.fileName
from YZT_Annex a, YZT_FCmaterials b where b.dr=0 and a.dr=0 and
b.DisID={0} and b.ID=a.fcID and a.fileAlias=4", DisID);
DataSet ds = SqlHelper.Query(SqlHelper.LocalSqlServer, sqlstr);
if (ds.Tables.Count > 0)
{
List <class_ver3.FCMaterial> materials = new List <class_ver3.FCMaterial>();
foreach (DataRow r in ds.Tables[0].Rows)
{
class_ver3.FCMaterial fcMaterial = new class_ver3.FCMaterial();
fcMaterial.category = Common.GetAnnexDescription(SqlHelper.GetInt(r["type"]));
fcMaterial.validDate = SqlHelper.GetString(r["validDate"]);
DateTime expireDate = SqlHelper.GetDateTime(r["validDate"]);
if (expireDate != null && !string.IsNullOrEmpty(fcMaterial.validDate))
{
fcMaterial.dateDiff = (expireDate - DateTime.Now).Days;
}
fcMaterial.fileUrl = SqlHelper.GetString(r["fileName"]);
if (!string.IsNullOrEmpty(fcMaterial.fileUrl))
{
fcMaterial.fileUrl = ConfigurationManager.AppSettings["OssImgPath"] + "/UploadFile/" + fcMaterial.fileUrl;
}
fcMaterial.DisID = SqlHelper.GetInt(r["DisID"]);
materials.Add(fcMaterial);
}
res.FCMaterialList = materials;
}
return(new ResultResellerDetail()
{
Result = "T", Description = "获取成功", Reseller = res
});
}
catch (Exception ex)
{
Common.CatchInfo(ex.Message + ":" + ex.StackTrace, "GetResellerDetail:" + JSon);
return(new ResultResellerDetail()
{
Result = "F", Description = "获取失败"
});
}
}
