/// <summary>
/// 得到经销商信息
/// </summary>
/// <returns></returns>
public List <DistributorResultDTO> GetDistributorList(DistributorSearchDTO dto)
{
List <DistributorResultDTO> result = null;
var tcdmse = SingleQueryObject.GetObj();
var pp = tcdmse.master_DistributorInfo.AsNoTracking().Where(p => p.DistributorID != null);
if (dto.DistributorID != null)
{
pp = pp.Where(p => p.DistributorID == dto.DistributorID);
}
if (dto.DistributorTypeID != null)
{
pp = pp.Where(p => p.DistributorTypeID == dto.DistributorTypeID);
}
if (dto.DistributorServiceTypeID != null)
{
pp = pp.Where(p => p.DistributorServiceTypeID == dto.DistributorServiceTypeID);
}
if (!string.IsNullOrEmpty(dto.SearchText))
{
pp = pp.Where(p => p.DistributorCode.Contains(dto.SearchText) || p.DistributorName.Contains(dto.SearchText) || p.master_DistributorType.DistributorTypeName.Contains(dto.SearchText));
}
if (dto.IsActive != null)
{
pp = pp.Where(p => p.IsActive == dto.IsActive);
}
dto.Count = pp.Count();
pp = pp.OrderByDescending(m => m.IsActive).ThenBy(m => m.DistributorID).Skip((dto.page - 1) * dto.rows).Take(dto.rows);
result = Mapper.Map <List <master_DistributorInfo>, List <DistributorResultDTO> >(pp.ToList());
return(result);
}
/// <summary>
/// 得到经销商信息
/// </summary>
/// <returns></returns>
public static ResultData <List <DistributorResultDTO> > GetDistributorList(DistributorSearchDTO dto)
{
ResultData <List <DistributorResultDTO> > result = null;
result = GetAPI <ResultData <List <DistributorResultDTO> > >(WebConfiger.MasterDataServicesUrl + "DistributorManagerment?DistributorSearchDTO=" + TransformHelper.ConvertDTOTOBase64JsonString(dto));
return(result);
}
/// <summary>
/// 得到经销商信息
/// </summary>
/// <returns></returns>
public ActionResult GetDistributorList(DistributorSearchDTO dto)
{
ResultData <List <DistributorResultDTO> > result = null;
dto.page = 1;
dto.rows = 10000000;
result = ProductManagementProvider.GetDistributorList(dto);
return(Json(result.Object, JsonRequestBehavior.AllowGet));
}
public HttpResponseMessage GetDistributorList(string DistributorSearchDTO)
{
DistributorSearchDTO dto = TransformHelper.ConvertBase64JsonStringToDTO <DistributorSearchDTO>(DistributorSearchDTO);
ResultDTO <List <DistributorResultDTO> > actionresult = new ResultDTO <List <DistributorResultDTO> >();
actionresult.Object = _IDistributorServices.GetDistributorList(dto);
actionresult.SubmitResult = true;
actionresult.Count = dto.Count;
HttpResponseMessage result = new HttpResponseMessage
{
Content = new StringContent(JsonConvert.SerializeObject(actionresult),
System.Text.Encoding.GetEncoding("UTF-8"),
"application/json")
};
return(result);
}
/// <summary>
/// 得到一条经销商信息
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public static ResultData <DistributorModel> GetOneDistributor(DistributorSearchDTO dto)
{
ResultData <DistributorModel> result = new ResultData <DistributorModel>();
var pp = GetAPI <ResultData <List <DistributorModel> > >(WebConfiger.MasterDataServicesUrl + "DistributorManagerment?DistributorSearchDTO=" + TransformHelper.ConvertDTOTOBase64JsonString(dto));
if (pp.Object != null && pp.Object.Count > 0)
{
result.Object = pp.Object.First();
result.SubmitResult = true;
}
else
{
result.Message = "此条信息不存在！";
result.SubmitResult = false;
}
return(result);
}
/// <summary>
/// 得到所有经销商信息
/// </summary>
/// <returns></returns>
public static ResultData <List <DistributorModel> > GetDistributorList(DistributorSearchDTO dto, string strSaveDir = "")
{
ResultData <List <DistributorModel> > result = null;
result = GetAPI <ResultData <List <DistributorModel> > >(WebConfiger.MasterDataServicesUrl + "DistributorManagerment?DistributorSearchDTO=" + TransformHelper.ConvertDTOTOBase64JsonString(dto));
if (strSaveDir != "")
{
foreach (var f in result.Object)
{
var pp = System.IO.Directory.GetFiles(strSaveDir, f.DistributorID.Value.ToString("N") + ".*", System.IO.SearchOption.AllDirectories);
foreach (string p in pp)
{
f.IsAtt = true;
}
}
}
return(result);
}
public void TestMethod1()
{
//查询经销商
DistributorSearchDTO dto = new DistributorSearchDTO();
dto.page = 1;
dto.rows = 1;
List <DistributorResultDTO> list = _IDistributorServices.GetDistributorList(dto);
//经销商新增
DistributorOperateDTO dto1 = new DistributorOperateDTO();
dto1.DistributorID = Guid.NewGuid();
dto1.DistributorCode = "csjxsTest";
dto1.DistributorName = "测试经销商Test";
dto1.InvoiceCode = "测试发票编号地址Test";
dto1.DeliverCode = "测试送货编号地址Test";
dto1.Office = "办事处";
dto1.CSRNameReagent = "CRS用户名SJ";
dto1.CSRNameD = "CRS用户名B";
dto1.CSRNameB = "CRS用户名D";
dto1.IsActive = true;
dto1.CreateUser = "******";
dto1.CreateTime = DateTime.Now;
bool bl = _IDistributorServices.AddDistributor(dto1);
Assert.IsTrue(bl);
//查询经销商
DistributorSearchDTO dto2 = new DistributorSearchDTO();
dto2.SearchText = "测试经销商Test";
dto2.page = 1;
dto2.rows = 1;
List <DistributorResultDTO> list1 = _IDistributorServices.GetDistributorList(dto2);
Assert.IsNotNull(list1);
//修改经销商
DistributorOperateDTO dto3 = new DistributorOperateDTO();
dto3.DistributorID = list1.Select(s => s.DistributorID).FirstOrDefault();
dto3.DistributorCode = "csjxsTest";
dto3.DistributorName = "修改测试经销商Test";
dto3.InvoiceCode = "修改测试发票编号地址Test";
dto3.DeliverCode = "修改测试送货编号地址Test";
dto3.Office = "修改办事处";
dto3.CSRNameReagent = "修改CRS用户名SJ";
dto3.CSRNameD = "修改CRS用户名B";
dto3.CSRNameB = "修改CRS用户名D";
dto3.IsActive = true;
dto3.ModifyUser = "******";
dto3.ModifyTime = DateTime.Now;
bool bl1 = _IDistributorServices.UpdateDistributor(dto3);
Assert.IsTrue(bl1);
//停启用经销商
DistributorOperateDTO dto4 = new DistributorOperateDTO();
dto4.DistributorID = list1.Select(s => s.DistributorID).FirstOrDefault();
dto4.IsActive = true;
dto4.ModifyUser = "******";
dto4.ModifyTime = DateTime.Now;
bool bl2 = _IDistributorServices.StartOrStopDistributor(dto4);
Assert.IsTrue(bl2);
//删除经销商
DistributorOperateDTO dto5 = new DistributorOperateDTO();
dto5.DistributorID = list1.Select(s => s.DistributorID).FirstOrDefault();
bool bl3 = _IDistributorServices.DeleteDistributor(dto5);
Assert.IsTrue(bl3);
}
/// <summary>
/// 得到一条用户申请信息
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public ActionResult GetOneUserApply(UserApplySearchDTO dto)
{
ResultData <UserApplyResultDTOModel> result = new ResultData <UserApplyResultDTOModel>();
DistributorSearchDTO disdto = new DistributorSearchDTO();
try
{
string strSaveDir = this.Server.MapPath("~/Attachments");
result = UserAuthorityProvider.GetOneUserApply(dto);
result.SubmitResult = true;
string ViewdisNameStr = "";
if (!string.IsNullOrEmpty(result.Object.DistributorIDList))
{
//查询经销商ID字符串转List
string disString = string.Empty;
string Disstr = result.Object.DistributorIDList;
List <string> DisList = new List <string>();
Disstr.Split(',').ToList().ForEach(g =>
{
disString = g.Trim();
if (!string.IsNullOrEmpty(disString))
{
DisList.Add(disString);
}
});
//根据经销商ID的List查询到经销商的姓名，并且拼接成字符串
foreach (var q in DisList)
{
Guid guid = new Guid(q);
disdto.DistributorID = guid;
disdto.rows = 10000;
disdto.page = 1;
var OneDisName = DistributorProvider.GetOneDistributor(disdto);
var DisName = OneDisName.Object.DistributorName;
ViewdisNameStr += DisName + ",";
}
}
result.Object.DistributorIDList = ViewdisNameStr;
if (result.Object.BatchID != null)
{
AttachFileSearchDTO attdto = new AttachFileSearchDTO();
attdto.BelongModule = 2;
attdto.BelongModulePrimaryKey = result.Object.BatchID.Value.ToString();
var att = UserAuthorityProvider.GetAttachFileList(attdto);
if (att != null)
{
result.Object.AttName = att.AttachFileName;
result.Object.AttSrcName = att.AttachFileSrcName;
result.Object.AttExtentionName = att.AttachFileExtentionName;
result.Object.IsAtt = true;
}
}
}
catch (Exception ex)
{
result.SubmitResult = false;
result.Message = ex.Message;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
private bool CheckUserInfo(object obj)
{
bool result = true;
List <ExcelUser> exceldto = (List <ExcelUser>)obj;
UserSearchDTO dto = new UserSearchDTO();
dto.rows = 100000000;
dto.page = 1;
var UserInfoList = UserAuthorityProvider.GetUser(dto);
DistributorSearchDTO disdto = new DistributorSearchDTO();
disdto.page = 1;
disdto.rows = 1000000000;
var distributorlist = DistributorProvider.GetDistributorList(disdto);//所有经销商
RoleSearchDTO roleSearch = new RoleSearchDTO();
var rolelist = UserAuthorityProvider.GetRoleList(roleSearch);
string strimporter = ((UserLoginDTO)Session["UserLoginInfo"]).FullName;
foreach (var p in exceldto)
{
StringBuilder sb = new StringBuilder();
if (String.IsNullOrEmpty(p.UserCode))
{
sb.Append("用户编号不可为空！ ");
}
else
{
var UserID = UserInfoList.Object.Where(m => m.UserCode == p.UserCode).Select(m => m.UserID).FirstOrDefault();
if (UserID != null)
{
p.UserID = UserID;
p.UpLogic = 2;
}
else
{
p.UpLogic = 1;
}
}
if (String.IsNullOrEmpty(p.Email))
{
sb.Append("用户邮箱不可为空！ ");
}
if (String.IsNullOrEmpty(p.PhoneNumber))
{
sb.Append("用户手机号不可为空！ ");
}
else
{
//手机号在此不做唯一性判断。
//var PhoneNumber = UserInfoList.Object.Where(m => m.PhoneNumber == p.PhoneNumber).Select(m => m.PhoneNumber).FirstOrDefault();
//if (PhoneNumber != null)
//{
// sb.Append("用户手机号不可重复");
//}
}
if (String.IsNullOrEmpty(p.DistributorNamestr))
{
//sb.Append("所属经销商不可为空!");
}
else
{
foreach (var dis in p.DistributorNamelist)
{
var exist = distributorlist.Object.Where(m => m.DistributorName == dis).FirstOrDefault();
if (exist == null)
{
sb.Append("经销商名称填写错误！错误名称为" + dis + "请检查！");
}
else
{
}
}
}
if (String.IsNullOrEmpty(p.RoleNamestr))
{
//sb.Append("用户角色不可为空！ ");
}
else
{
foreach (var role in p.RoleNamelist)
{
var exist = rolelist.Where(m => m.RoleName == role).FirstOrDefault();
if (exist == null)
{
sb.Append("角色" + role + "不存在！");
}
}
}
if (String.IsNullOrEmpty(p.StopTime))
{
sb.Append("使用的截止日期不可为空！ ");
}
p.Importer = strimporter;
if (sb.Length > 0)
{
p.CheckInfo = sb.ToString();
result = false;
}
}
return(result);
}
public void TestMethod1()
{
//查询
DistributorSearchDTO dto = new DistributorSearchDTO();
dto.page = 1;
dto.rows = 1;
string dtostr = Common.TransformHelper.ConvertDTOTOBase64JsonString(dto);
var pp = DistributorManagermentController.GetDistributorList(dtostr);
//新增
DistributorOperateDTO dto1 = new DistributorOperateDTO();
dto1.DistributorID = Guid.NewGuid();
dto1.DistributorCode = "csjxsTest";
dto1.DistributorName = "测试经销商Test";
dto1.InvoiceCode = "测试发票编号地址Test";
dto1.DeliverCode = "测试送货编号地址Test";
dto1.Office = "办事处";
dto1.CSRNameReagent = "CRS用户名SJ";
dto1.CSRNameD = "CRS用户名B";
dto1.CSRNameB = "CRS用户名D";
dto1.IsActive = true;
dto1.CreateUser = "******";
dto1.CreateTime = DateTime.Now;
var pp1 = DistributorManagermentController.AddDistributor(dto1);
string strResult1 = pp1.Content.ReadAsStringAsync().Result;
ResultDTO <object> bl = JsonConvert.DeserializeObject <ResultDTO <object> >(strResult1);
Assert.IsTrue(bl.SubmitResult);
//查询
DistributorSearchDTO dto2 = new DistributorSearchDTO();
dto2.SearchText = "测试经销商Test";
dto2.page = 1;
dto2.rows = 1;
string dto2str = Common.TransformHelper.ConvertDTOTOBase64JsonString(dto2);
var pp2 = DistributorManagermentController.GetDistributorList(dto2str);
string strResult2 = pp2.Content.ReadAsStringAsync().Result;
ResultDTO <List <DistributorResultDTO> > result = JsonConvert.DeserializeObject <ResultDTO <List <DistributorResultDTO> > >(strResult2);
List <DistributorResultDTO> list1 = result.Object;
//修改
DistributorOperateDTO dto3 = new DistributorOperateDTO();
dto3.UpType = 1;
dto3.DistributorID = list1.Select(s => s.DistributorID).FirstOrDefault();
dto3.DistributorCode = "csjxsTest";
dto3.DistributorName = "修改测试经销商Test";
dto3.InvoiceCode = "修改测试发票编号地址Test";
dto3.DeliverCode = "修改测试送货编号地址Test";
dto3.Office = "修改办事处";
dto3.CSRNameReagent = "修改CRS用户名SJ";
dto3.CSRNameD = "修改CRS用户名B";
dto3.CSRNameB = "修改CRS用户名D";
dto3.IsActive = true;
dto3.ModifyUser = "******";
dto3.ModifyTime = DateTime.Now;
var pp3 = DistributorManagermentController.UpdateDistributor(dto3);
string strResult3 = pp3.Content.ReadAsStringAsync().Result;
ResultDTO <object> bl1 = JsonConvert.DeserializeObject <ResultDTO <object> >(strResult3);
Assert.IsTrue(bl1.SubmitResult);
//停启用经销商
DistributorOperateDTO dto4 = new DistributorOperateDTO();
dto4.UpType = 2;
dto4.DistributorID = list1.Select(s => s.DistributorID).FirstOrDefault();
dto4.IsActive = true;
dto4.ModifyUser = "******";
dto4.ModifyTime = DateTime.Now;
var pp4 = DistributorManagermentController.UpdateDistributor(dto4);
string strResult4 = pp4.Content.ReadAsStringAsync().Result;
ResultDTO <object> bl2 = JsonConvert.DeserializeObject <ResultDTO <object> >(strResult4);
Assert.IsTrue(bl2.SubmitResult);
//删除
DistributorOperateDTO dto5 = new DistributorOperateDTO();
dto5.DistributorID = list1.Select(s => s.DistributorID).FirstOrDefault();
string dto4str = Common.TransformHelper.ConvertDTOTOBase64JsonString(dto5);
var pp5 = DistributorManagermentController.DeleteDistributor(dto4str);
string strResult5 = pp5.Content.ReadAsStringAsync().Result;
ResultDTO <object> bl3 = JsonConvert.DeserializeObject <ResultDTO <object> >(strResult5);
Assert.IsTrue(bl3.SubmitResult);
}
