public void GetTest()
{
RequestAuth requestAuth = new RequestAuth();
requestAuth.Login = new Credentials()
{
ApiKey = ConfigurationManager.AppSettings["ApiKey"],
ClientID = ConfigurationManager.AppSettings["ClientID"],
ClientSecret = ConfigurationManager.AppSettings["ClientSecret"]
};
ResponseAuth responseAuth = this.Login(requestAuth);
RequestGet request = new RequestGet();
ResponseGet response = new ResponseGet();
request.AnalysisLocation = ConfigurationManager.AppSettings["AnalysisLocation"];
request.ApiKey = ConfigurationManager.AppSettings["ApiKey"];
request.LoginToken = responseAuth.Token.Value;
request.Orders = new List <string>()
{
"ORDER_ID"
};
response = this.GetOrders(request);
Assert.AreEqual(response.Orders[0].ID, "ORDER_ID");
}
private CacheObject ExecuteObject(RequestGet request)
{
var result = default(CacheObject);
DCT.DCT.Execute(c =>
{
var type = Type.GetType(request.CurrentType);
var convertor = GetConvertor(type);
switch (request.QueryType)
{
case "_ObjectLoad":
result = convertor.ObjectLoad(request.Ids.FirstOrDefault());
break;
case "_SaveChanges":
{
var obj = convertor._JSONGetCollection(request.JSONObjectCollections);
result = convertor.ObjectSave(obj).FirstOrDefault();
break;
}
default:
{
var code = request.QueryType;
var sessionUID = request.SessionUID;
var hashUID = request.HashUID;
Guid id = request.Ids == null ? Guid.Empty : request.Ids.FirstOrDefault();
result = convertor._CustomCollectionLoad(code, sessionUID, hashUID, request.JSONObjectCollections, new[] { id }).FirstOrDefault();
break;
}
}
});
return(result);
}
public async Task <ResponseObject <TPSMPurchaseOrderMainQueryModel> > GetWholeMainData(int requestObject, CurrentUser currentUser)
{
try
{
RequestGet requestGet = new RequestGet()
{
IsPaging = false,
QueryConditions = new List <QueryCondition>()
{
new QueryCondition()
{
Column = "ID", Condition = ConditionEnum.Equal, Content = requestObject.ToString()
}
}
};
var mainModel = await GetMainListAsync(requestGet, currentUser);
TPSMPurchaseOrderMainQueryModel tPSMPurchaseOrderMainQueryModel = mainModel.Data.FirstOrDefault();
var deatailModel = await GetDetialList(requestObject, currentUser);
tPSMPurchaseOrderMainQueryModel.ChildList = deatailModel.Data;
return(ResponseUtil <TPSMPurchaseOrderMainQueryModel> .SuccessResult(tPSMPurchaseOrderMainQueryModel));
}
catch (Exception ex)
{
return(ResponseUtil <TPSMPurchaseOrderMainQueryModel> .FailResult(null, ex.Message));
}
}
private IEnumerable <CacheObject> ExecuteObjectCollection(RequestGet request)
{
var result = Enumerable.Empty <CacheObject>();
DCT.DCT.Execute(c =>
{
var type = Type.GetType(request.CurrentType);
var convertor = GetConvertor(type);
switch (request.QueryType)
{
case "_CollectionLoad":
result = convertor.CollectionObjectLoad();
break;
case "_SaveChanges":
var obj = convertor._JSONGetCollection(request.JSONObjectCollections);
result = convertor.ObjectSave(obj);
break;
default:
var code = request.QueryType;
var sessionUID = request.SessionUID;
var hashUID = request.HashUID;
var ids = request.Ids;
result = convertor._CustomCollectionLoad(code, sessionUID, hashUID, request.JSONObjectCollections, ids);
break;
}
});
return(result);
}
private async void BtnLoad_Clicked(object sender, EventArgs e)
{
RequestGet request = new RequestGet();
request.FileId = fileId;
await LoadFileFormServe(request);
imgSignature.IsVisible = true;
}
async Task LoadFileFormServe(RequestGet request)
{
var apiReponse = RestService.For <IApiSaveFile>(_host);
var reponse = await apiReponse.GetFile(request);
if (reponse.Success == true)
{
imgSignature.Source = _host + reponse.LinkFile;
}
}
private ResponseGet GetOrders(RequestGet order)
{
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(ConfigurationManager.AppSettings["BaseUrl"]);
StringContent data = new StringContent(JsonConvert.SerializeObject(order).ToString(), Encoding.UTF8, "application/json");
string json = client.PostAsync("/api/order/get", data).Result.Content.ReadAsStringAsync().Result;
return(JsonConvert.DeserializeObject <ResponseGet>(json));
}
}
public Message CreateGetRequest(RmReference objectId, CultureInfo culture, string[] attributes)
{
if (objectId == null || string.IsNullOrEmpty(objectId.Value))
{
throw new ArgumentNullException("objectId");
}
Message msgGetRequest = null;
bool isAttributeSearchRequest = false;
RequestGet requestGet = new RequestGet()
{
ResourceReferenceProperty = objectId.Value
};
if (culture != null)
{
requestGet.ResourceLocaleProperty = culture.Name;
}
if (attributes != null && attributes.Length != 0)
{
isAttributeSearchRequest = true;
List <string> attributeList = new List <string>(attributes);
if (string.IsNullOrEmpty(attributeList.Find(a => a.ToLower() == "objecttype")))
{
attributeList.Add("ObjectType");
}
requestGet.RequestAttributeSearch = new RequestAttributeSearch(attributeList.ToArray());
}
if (!isAttributeSearchRequest)
{
msgGetRequest = Message.CreateMessage(MessageVersion.Default, Constants.WsTransfer.GetAction);
}
else
{
msgGetRequest = Message.CreateMessage(MessageVersion.Default, Constants.WsTransfer.GetAction,
requestGet.RequestAttributeSearch, new ClientSerializer(typeof(RequestAttributeSearch)));
ClientHelper.AddImdaHeaders(requestGet, msgGetRequest);
}
ClientHelper.AddRmHeaders(requestGet, msgGetRequest);
return(msgGetRequest);
}
/// <summary>
/// 验证多次登录失败短信验证码合法性
/// </summary>
/// <param name="requestObject"></param>
/// <returns></returns>
public async Task <ResponseObject <string> > GetVerificationCodeTimePass(RequestGet requestObject)
{
try
{
String Mobile = "";
String Code = "";
if (requestObject.QueryConditions != null && requestObject.QueryConditions.Count > 0)
{
var conditionals = SqlSugarUtil.GetConditionalModels(requestObject.QueryConditions);
foreach (ConditionalModel item in conditionals)
{
if (item.FieldName.ToLower() == "mobile")
{
Mobile = item.FieldValue;
continue;
}
if (item.FieldName.ToLower() == "code")
{
Code = item.FieldValue;
continue;
}
}
}
var redis = CacheFactory.Instance(CacheType.Redis);
string redisKey = string.Format(CacheKeyString.TimePassMsgCode, Mobile);
string RedisCode = redis.GetValueByKey <string>(redisKey);
if (RedisCode == "")
{
return(ResponseUtil <string> .SuccessResult("0"));
}
else if (RedisCode != Code)
{
return(ResponseUtil <string> .SuccessResult("2"));
}
return(ResponseUtil <string> .SuccessResult("1"));
}
catch (Exception ex)
{
return(ResponseUtil <string>
.FailResult(null, $"验证注册短信验证码合法性异常 {ex.Message}"));
}
}
public async Task <ResponseObject <TMMBOMMainQueryModel> > GetWholeMainData(int requestObject)
{
TMMBOMMainQueryModel result;
try
{
RequestGet requestGet = new RequestGet()
{
IsPaging = false,
QueryConditions =
new List <QueryCondition>()
{
new QueryCondition()
{
Column = "PackageId", Condition = ConditionEnum.Equal, Content = requestObject.ToString()
}
}
};
var main = await GetMainListAsync(requestGet);
result = main.Data.FirstOrDefault();
if (result != null)
{
var detailList = await GetDetailListAsync(result.ID);
result.ChildList = detailList.Data;
//_db.Instance.Queryable<TMMColorSolutionDetailDbModel, TBMDictionaryDbModel>((t, t1) => new object[] {
// JoinType.Left, t.ItemId==t1.ID
//}).Select((t,t1)=>new ItemModel() { ItemId=t.ItemId, ItemName=t1.DicValue });
}
//返回执行结果
return(ResponseUtil <TMMBOMMainQueryModel> .SuccessResult(result));
}
catch (Exception ex)
{
return(ResponseUtil <TMMBOMMainQueryModel> .FailResult(null, ex.Message));
}
}
public ResponseGet ExecuteQuery(RequestGet request)
{
var result = default(ResponseGet);
DCT.DCT.Execute(c =>
{
result = new ResponseGet();
result.QueryType = request.QueryType;
result.HasCollection = request.HasCollection;
var data = Enumerable.Empty <CacheObject>();
if (result.HasCollection)
{
data = ExecuteObjectCollection(request);
}
else
{
data = new CacheObject[] { ExecuteObject(request) }
};
result.SetObjectCollections(data);
});
return(result);
}
public IEnumerable <TCacheObject> RSendQueryCollection <TCacheObject>(string code, IEnumerable <TCacheObject> objects = null, IEnumerable <Guid> ids = null, bool hasCollection = true)
where TCacheObject : CacheObject
{
var result = Enumerable.Empty <TCacheObject>();
DCT.DCT.Execute(c =>
{
var request = new RequestGet();
request.CurrentType = typeof(TCacheObject).AssemblyQualifiedName;
request.HashUID = c._SessionInfo.HashUID;
request.SessionUID = c._SessionInfo.SessionUID;
request.QueryType = code;
request.HasCollection = hasCollection;
request.Ids = ids;
if (objects != null)
{
request.SetObjectCollections(objects);
}
var response = Execute <RequestGet, ResponseGet>(request);
result = response.GetObjectCollections <TCacheObject>().ToArray();
});
return(result);
}
/// <summary>
/// 获取表名页面列表
/// </summary>
private void GetRolePageList()
{
string errmsg = "";
DataTable dt = new DataTable();
string data = Request["data"];
RequestGet info = ObjectSerializeHelper.JsonToObject <RequestGet>(data);
string rolecode = info.rolecode;
BLLUserManage mybll = new BLLUserManage();
bool result = mybll.GetRolePageList(rolecode, ref dt, ref errmsg);
if (result)
{
string str = "\"data\":" + ObjectSerializeHelper.DataTableToJson(dt);
Response.Write(outjson.Replace("#code#", "0").Replace("#msg#", "").Replace("\"data\":null", str));
Response.End();
}
else
{
Response.Write(outjson.Replace("#code#", "-1").Replace("#msg#", errmsg));
Response.End();
}
}
public async Task <ResponseObject <TMMBOMNTempMainQueryModel> > GetWholeMainData(int requestObject, CurrentUser currentUser)
{
TMMBOMNTempMainQueryModel result;
try
{
RequestGet requestGet = new RequestGet()
{
IsPaging = false,
QueryConditions =
new List <QueryCondition>()
{
new QueryCondition()
{
Column = "Id", Condition = ConditionEnum.Equal, Content = requestObject.ToString()
}
}
};
var main = await GetMainListAsync(requestGet, currentUser);
result = main.Data.FirstOrDefault();
if (result != null)
{
var detailList = await GetDetailListAsync(result.ID);
result.ChildList = detailList.Data;
}
//返回执行结果
return(ResponseUtil <TMMBOMNTempMainQueryModel> .SuccessResult(result));
}
catch (Exception ex)
{
return(ResponseUtil <TMMBOMNTempMainQueryModel> .FailResult(null, ex.Message));
}
}
/// <summary>
/// 验证登录是否需要验证码
/// </summary>
/// <param name="requestObject"></param>
/// <returns></returns>
public async Task <ResponseObject <int> > GetVerification(RequestGet request)
{
try
{
String Mobile = "";
if (request.QueryConditions != null && request.QueryConditions.Count > 0)
{
var conditionals = SqlSugarUtil.GetConditionalModels(request.QueryConditions);
foreach (ConditionalModel item in conditionals)
{
if (item.FieldName.ToLower() == "mobile")
{
Mobile = item.FieldValue;
continue;
}
}
}
var verification = CacheFactory.Instance(CacheType.Redis);
if (verification.ContainsKey(string.Format(CacheKeyString.LoginTimes, Mobile)))
{
string RedisValue = verification.GetValueByKey <string>(string.Format(CacheKeyString.LoginTimes, Mobile));
if (Convert.ToInt32(RedisValue) >= 3)
{
return(ResponseUtil <int>
.FailResult(2, "登录次数超过限制，请输入验证码登录"));
}
}
return(ResponseUtil <int>
.FailResult(1, "无需验证"));
}
catch (Exception ex)
{
//返回异常信息
return(ResponseUtil <int>
.FailResult(0, ex.Message));
}
}
/// <summary>
/// 获取T_MM_BOMNTempMain主表数据数据
/// </summary>
/// <param name="requestObject">Get请求参数</param>
/// <returns>返回响应结果对象，包括响应代码，查询操作结果</returns>
public async Task <ResponseObject <List <TMMBOMNTempMainQueryModel> > > GetMainListAsync(RequestGet requestObject, CurrentUser currentUser)
{
try
{
List <TMMBOMNTempMainQueryModel> queryData = null; //查询结果集对象
RefAsync <int> totalNumber = -1; //总记录数
var query = _db.Instance.Queryable <TMMBOMNTempMainDbModel>();
//查询条件
if (requestObject.QueryConditions != null && requestObject.QueryConditions.Count > 0)
{
var conditionals = SqlSugarUtil.GetConditionalModels(requestObject.QueryConditions);
query.Where(conditionals);
}
//排序条件
if (requestObject.OrderByConditions != null && requestObject.OrderByConditions.Count > 0)
{
foreach (var item in requestObject.OrderByConditions)
{
var exp = SqlSugarUtil.GetOrderByLambda <TMMBOMNTempMainDbModel>(item.Column);
if (exp == null)
{
continue;
}
if (item.Condition.ToLower() != "asc" &&
item.Condition.ToLower() != "desc")
{
continue;
}
query.OrderBy($"{item.Column} {item.Condition}");
}
}
//执行查询
if (requestObject.IsPaging)
{
queryData = await query.Select((t) => new TMMBOMNTempMainQueryModel
{
ID = t.ID,
PackageId = t.PackageId,
PagerCode = t.PagerCode,
Maker = t.Maker,
FrontImgPath = t.FrontImgPath,
SideImgPath = t.SideImgPath,
BackImgPath = t.BackImgPath,
TempName = t.TempName,
CompanyId = t.CompanyId,
})
.ToPageListAsync(requestObject.PageIndex, requestObject.PageSize, totalNumber);
}
else
{
queryData = await query.Select((t) => new TMMBOMNTempMainQueryModel
{
ID = t.ID,
PackageId = t.PackageId,
PagerCode = t.PagerCode,
Maker = t.Maker,
FrontImgPath = t.FrontImgPath,
SideImgPath = t.SideImgPath,
BackImgPath = t.BackImgPath,
TempName = t.TempName,
CompanyId = t.CompanyId,
})
.ToListAsync();
}
//返回执行结果
return(ResponseUtil <List <TMMBOMNTempMainQueryModel> > .SuccessResult(queryData, totalNumber));
}
catch (Exception ex)
{
//返回查询异常结果
return(ResponseUtil <List <TMMBOMNTempMainQueryModel> > .FailResult(null, ex.Message));
}
}
public ResponseObject <List <ToDoMgModel> > GetToDoModel(RequestGet requestObject, CurrentUser currentUser)
{
ResponseObject <List <ToDoMgModel> > responseObject = new ResponseObject <List <ToDoMgModel> >();
responseObject.Code = 0;
try
{
List <ToDoMgModel> result = new List <ToDoMgModel>();
Expression <Func <ToDoMgModel, bool> > queryConditionLam = (x) => x.To == currentUser.UserID && x.CompanyID == currentUser.CompanyID;
if (requestObject.QueryConditions != null && requestObject.QueryConditions.Count > 0)
{
var conditionals = SqlSugarUtil.GetConditionalFull(requestObject.QueryConditions).Where(p => !string.IsNullOrWhiteSpace(p.FieldValue)).ToList();
var whereConditional = ConditionalModelToExpression.BuildExpression <ToDoMgModel>(conditionals);
queryConditionLam = queryConditionLam.And(whereConditional);
}
SortDefinition <ToDoMgModel> sort = null;
//排序条件
if (requestObject.OrderByConditions != null && requestObject.OrderByConditions.Count > 0)
{
foreach (var item in requestObject.OrderByConditions)
{
var exp = SqlSugarUtil.GetExpression <ToDoMgModel>(item.Column);
if (exp == null)
{
continue;
}
if (item.Condition.ToLower() == "asc")
{
if (sort == null)
{
sort = Builders <ToDoMgModel> .Sort.Ascending(exp);
}
else
{
sort = sort.Ascending(exp);
}
}
else if (item.Condition.ToLower() == "desc")
{
if (sort == null)
{
sort = Builders <ToDoMgModel> .Sort.Descending(exp);
}
else
{
sort = sort.Descending(exp);
}
}
}
}
long totalNum = 0;
if (requestObject.IsPaging == true)
{
result = MongoDbUtil.GetDoc <ToDoMgModel>(queryConditionLam, requestObject.PageIndex, requestObject.PageSize, sort, ref totalNum);
}
else
{
result = MongoDbUtil.GetDoc <ToDoMgModel>(queryConditionLam, sort).ToList();
}
return(ResponseUtil <List <ToDoMgModel> > .SuccessResult(result, totalNum));
}
catch (Exception ex)
{
return(ResponseUtil <List <ToDoMgModel> > .FailResult(null, ex.Message));
}
}
public void AddListener(RequestGet requestGet, Action action)
{
facebookButtonsDictionary[requestGet].AddListener(action);
}
/// <summary>
/// 获取T_WM_InventoryMain主表数据数据
/// </summary>
/// <param name="requestObject">Get请求参数</param>
/// <param name="currentUser"></param>
/// <returns>返回响应结果对象，包括响应代码，查询操作结果</returns>
public async Task <ResponseObject <List <TWMInventoryMainQueryModel> > > GetMainListAsync(RequestGet requestObject, CurrentUser currentUser)
{
try
{
List <TWMInventoryMainQueryModel> queryData = null; //查询结果集对象
RefAsync <int> totalNumber = -1; //总记录数
var query = _db.Instance.Queryable <TWMInventoryMainDbModel, TBMWarehouseFileDbModel, TSMUserAccountDbModel,
TSMUserAccountDbModel, TSMUserAccountDbModel, TSMUserAccountDbModel>(
(t, t0, t1, t2, t3, t4) => new object[]
{
JoinType.Left, t.WarehouseId == t0.ID,
JoinType.Left, t.OperatorId == t1.ID,
JoinType.Left, t.WhAdminId == t2.ID,
JoinType.Left, t.AuditId == t3.ID,
JoinType.Left, t.InventoryId == t4.ID
}
).Where((t, t0, t1, t2, t3, t4) => t.CompanyId == currentUser.CompanyID && !t.DeleteFlag);
//查询条件
if (requestObject.QueryConditions != null && requestObject.QueryConditions.Count > 0)
{
var conditionals = SqlSugarUtil.GetConditionalModels(requestObject.QueryConditions);
query.Where(conditionals);
}
//排序条件
if (requestObject.OrderByConditions != null && requestObject.OrderByConditions.Count > 0)
{
foreach (var item in requestObject.OrderByConditions)
{
var exp = SqlSugarUtil.GetOrderByLambda <TWMInventoryMainDbModel>(item.Column);
if (exp == null)
{
continue;
}
if (item.Condition.ToLower() != "asc" &&
item.Condition.ToLower() != "desc")
{
continue;
}
query.OrderBy($"{item.Column} {item.Condition}");
}
}
//执行查询
if (requestObject.IsPaging)
{
queryData = await query.Select(
(t, t0, t1, t2, t3, t4) => new TWMInventoryMainQueryModel
{
ID = t.ID,
WarehouseId = t.WarehouseId,
WarehouseName = t0.WarehouseName,
InventoryDate = t.InventoryDate,
InventoryOrder = t.InventoryOrder,
AuditStatus = t.AuditStatus,
OperatorId = t.OperatorId,
OperatorName = t1.AccountName,
WhAdminId = t.WhAdminId,
WhAdminName = t2.AccountName,
AuditId = t.AuditId,
AuditName = t3.AccountName,
AuditTime = t.AuditTime,
DeleteFlag = t.DeleteFlag,
CompanyId = t.CompanyId,
InventoryId = t.InventoryId,
InventoryName = t4.AccountName
})
.ToPageListAsync(requestObject.PageIndex, requestObject.PageSize, totalNumber);
}
else
{
queryData = await query.Select(
(t, t0, t1, t2, t3, t4) => new TWMInventoryMainQueryModel
{
ID = t.ID,
WarehouseId = t.WarehouseId,
WarehouseName = t0.WarehouseName,
InventoryDate = t.InventoryDate,
InventoryOrder = t.InventoryOrder,
AuditStatus = t.AuditStatus,
OperatorId = t.OperatorId,
OperatorName = t1.AccountName,
WhAdminId = t.WhAdminId,
WhAdminName = t2.AccountName,
AuditId = t.AuditId,
AuditName = t3.AccountName,
AuditTime = t.AuditTime,
DeleteFlag = t.DeleteFlag,
CompanyId = t.CompanyId,
InventoryId = t.InventoryId,
InventoryName = t4.AccountName
})
.ToListAsync();
}
//返回执行结果
return(ResponseUtil <List <TWMInventoryMainQueryModel> > .SuccessResult(queryData, totalNumber));
}
catch (Exception ex)
{
//返回查询异常结果
return(ResponseUtil <List <TWMInventoryMainQueryModel> > .FailResult(null, ex.Message));
}
}
public async Task <ResponseObject <TWMProductionWhMainQueryModel> > GetWholeMainData(int iMainId, CurrentUser currentUser)
{
try
{
RequestGet requestGet = new RequestGet()
{
IsPaging = false,
QueryConditions = new List <QueryCondition>()
{
new QueryCondition()
{
Column = "Id", Condition = ConditionEnum.Equal, Content = iMainId.ToString()
}
}
};
var allMain = await GetMainListAsync(requestGet, currentUser);
var mainModel = allMain.Data.FirstOrDefault();
var materList = BasicCacheGet.GetMaterial(currentUser);
var dicList = BasicCacheGet.GetDic(currentUser);
var detailModels = await _db.Instance.Queryable <TWMProductionWhDetailDbModel, TWMProductionWhMainDbModel,
TBMMaterialFileDbModel, TMMWhApplyMainDbModel, TMMWhApplyDetailDbModel,
TMMProductionOrderDetailDbModel, TMMColorSolutionMainDbModel, TBMPackageDbModel, TBMDictionaryDbModel, TSMUserAccountDbModel, TBMDictionaryDbModel>(
(t, t0, t1, t2, t3, t4, t5, t6, t7, t8, t9) => new object[] {
JoinType.Inner, t.MainId == t0.ID,
JoinType.Inner, t.MaterialId == t1.ID,
JoinType.Inner, t0.SourceId == t2.ID,
JoinType.Inner, t.ProOrderDetailId == t3.ID,
JoinType.Inner, t3.ProOrderDetailId == t4.ID,
JoinType.Left, t4.ColorSolutionId == t5.ID,
JoinType.Left, t4.PackageId == t6.ID,
JoinType.Left, t.WorkshopId == t7.ID,
JoinType.Left, t4.PrincipalId == t8.ID,
JoinType.Left, t.SiteId == t9.ID
}
).Select((t, t0, t1, t2, t3, t4, t5, t6, t7, t8, t9) => new TWMProductionWhDetailQueryModel
{
ID = t.ID,
MainId = t.MainId,
MaterialId = t.MaterialId,
MaterialName = t1.MaterialName,
MaterialCode = t1.MaterialCode,
WarehouseId = t.WarehouseId,
ActualNum = t.ActualNum,
ProActualNum = t.ProActualNum,
UnitPrice = t.UnitPrice,
Amount = t.Amount,
MaterialTypeId = t1.MaterialTypeId,
//MaterialTypeName = t1.TypeName,
ColorId = t1.ColorId,
//ColorName = t2.DicValue,
BaseUnitId = t1.BaseUnitId,
//BaseUnitName = t3.DicValue,
WarehouseUnitId = t1.WarehouseUnitId,
//WarehouseUnitName = t4.DicValue,
WarehouseRate = t1.WarehouseRate,
ProduceRate = t1.ProduceRate,
ProduceUnitId = t1.ProduceUnitId,
//ProduceUnitName = t5.DicValue,
Spec = t1.Spec,
Remark = t.Remark,
SourceCode = t2.WhApplyNo,
TransNum = t3.TransNum,
PackageId = t4.PackageId,
ColorSolutionId = t4.ColorSolutionId,
ColorSolutionName = t5.SolutionCode,
PackageCode = t6.DicCode,
PackageName = t6.DicValue,
WorkshopName = t7.DicValue,
PrincipalName = t8.AccountName,
ProOrderDetailId = t.ProOrderDetailId,
SiteName = t9.DicValue
})
.Where(t => t.MainId == iMainId)
.ToListAsync();
detailModels.ForEach((x) =>
{
var thisMaterial = materList.Where(p => p.ID == x.MaterialId).FirstOrDefault();
if (mainModel.AuditStatus != 2)
{
x.TransNum = x.TransNum + x.ProActualNum;
}
x.MaterialTypeName = thisMaterial.MaterialTypeName;
x.ColorName = thisMaterial.ColorName;
x.BaseUnitName = thisMaterial.BaseUnitName;
x.WarehouseUnitName = thisMaterial.WarehouseUnitName;
x.ProduceUnitName = thisMaterial.ProduceUnitName;
});
mainModel.ChildList = detailModels;
return(ResponseUtil <TWMProductionWhMainQueryModel> .SuccessResult(mainModel));
}
catch (Exception ex)
{
return(ResponseUtil <TWMProductionWhMainQueryModel> .FailResult(null));
}
}
/// <summary>
/// 获取T_MM_ColorSolutionMain主表数据数据
/// </summary>
/// <param name="requestObject">Get请求参数</param>
/// <returns>返回响应结果对象，包括响应代码，查询操作结果</returns>
public async Task <ResponseObject <DataTable> > GetAsync(RequestGet requestObject, CurrentUser currentUser)
{
try
{
List <TMMColorSolutionMainQueryModel> queryData = null; //查询结果集对象
RefAsync <int> totalNumber = -1; //总记录数
var query = _db.Instance.Queryable <TMMColorSolutionMainDbModel>().Where(t => t.CompanyId == currentUser.CompanyID && t.DeleteFlag == false);
//查询条件
if (requestObject.QueryConditions != null && requestObject.QueryConditions.Count > 0)
{
var conditionals = SqlSugarUtil.GetConditionalModels(requestObject.QueryConditions);
query.Where(conditionals);
}
//排序条件
if (requestObject.OrderByConditions != null && requestObject.OrderByConditions.Count > 0)
{
foreach (var item in requestObject.OrderByConditions)
{
var exp = SqlSugarUtil.GetOrderByLambda <TMMColorSolutionMainDbModel>(item.Column);
if (exp == null)
{
continue;
}
if (item.Condition.ToLower() != "asc" &&
item.Condition.ToLower() != "desc")
{
continue;
}
query.OrderBy($"{item.Column} {item.Condition}");
}
}
//执行查询
if (requestObject.IsPaging)
{
queryData = await query.Where(t => !t.DeleteFlag)
.Select((t) => new TMMColorSolutionMainQueryModel
{
ID = t.ID,
PackageId = t.PackageId,
SolutionCode = t.SolutionCode,
ImagePath = t.ImagePath,
})
.ToPageListAsync(requestObject.PageIndex, requestObject.PageSize, totalNumber);
}
else
{
queryData = await query.Where(t => !t.DeleteFlag)
.Select((t) => new TMMColorSolutionMainQueryModel
{
ID = t.ID,
PackageId = t.PackageId,
SolutionCode = t.SolutionCode,
ImagePath = t.ImagePath,
})
.ToListAsync();
}
List <TMMColorSolutionDetailQueryModel> detailList = null;
if (queryData != null && queryData.Count > 0)
{
detailList = await _db.Instance.Queryable <TMMColorSolutionDetailDbModel, TBMDictionaryDbModel, TBMDictionaryDbModel>(
(t, t0, t1) => new object[]
{
JoinType.Left, t.ItemId == t0.ID,
JoinType.Left, t.ColorId == t1.ID
}
)
.In(t => t.MainId, queryData.Select(p => p.ID).ToArray())
.Select((t, t0, t1) => new TMMColorSolutionDetailQueryModel
{
ID = t.ID,
MainId = t.MainId,
ItemId = t.ItemId,
ItemName = t0.DicValue,
ColorId = t.ColorId,
ColorName = t1.DicValue
})
.ToListAsync();
}
var returnTable = GetReturnDataTable(queryData, detailList);
//返回执行结果
return(ResponseUtil <DataTable> .SuccessResult(returnTable, totalNumber));
}
catch (Exception ex)
{
//返回查询异常结果
return(ResponseUtil <DataTable> .FailResult(null, ex.Message));
}
}
/// <summary>
/// 采购一览表
/// </summary>
/// <param name="currentUser"></param>
/// <returns></returns>
public async Task <ResponseObject <PurchaseListModel> > GetPurchaseCountList(RequestGet request, CurrentUser currentUser)
{
try
{
List <PurchaseCountListModel> queryData = null; //查询结果集对象
RefAsync <int> totalNumber = -1; //总记录数
var query = _db.Instance.Queryable <TPSMPurchaseOrderDetailDbModel, TPSMPurchaseOrderMainDbModel
, TBMDictionaryDbModel, TBMSupplierFileDbModel, TSMUserAccountDbModel, TBMMaterialFileDbModel>(
(t1, t2, t3, t4, t5, t6) => new object[]
{
JoinType.Left, t1.MainId == t2.ID,
JoinType.Left, t2.OrderTypeId == t1.ID,
JoinType.Left, t1.SupplierId == t4.ID,
JoinType.Left, t2.BuyerId == t5.ID,
JoinType.Left, t1.MaterialId == t6.ID
}
).Where((t1, t2, t3, t4, t5, t6) => t2.CompanyId == currentUser.CompanyID)
.OrderBy((t1, t2, t3, t4, t5, t6) => t2.OrderNo);
//查询条件
if (request.QueryConditions != null && request.QueryConditions.Count > 0)
{
var conditionals = SqlSugarUtil.GetConditionalModels(request.QueryConditions);
foreach (ConditionalModel item in conditionals)
{
if (item.FieldName.ToLower() == "orderdate" ||
item.FieldName.ToLower() == "supplierid" ||
item.FieldName.ToLower() == "ordertypeid" ||
item.FieldName.ToLower() == "orderno")
{
item.FieldName = $"t2.{item.FieldName}";
continue;
}
}
query.Where(conditionals);
}
//排序条件
if (request.OrderByConditions != null && request.OrderByConditions.Count > 0)
{
foreach (var item in request.OrderByConditions)
{
var exp = SqlSugarUtil.GetOrderByLambda <TPSMPurchaseOrderMainDbModel>(item.Column);
if (exp == null)
{
continue;
}
if (item.Condition.ToLower() != "asc" &&
item.Condition.ToLower() != "desc")
{
continue;
}
query.OrderBy($"t2.{item.Column} {item.Condition}");
}
}
PurchaseListModel _list = new PurchaseListModel();
_list.Total_Number = query.Count();
#region 统计数量
var PurchaseNum = query.Select((t1, t2, t3, t4, t5, t6) => SqlFunc.AggregateSum(t1.PurchaseNum)).ToList();
_list.Total_Num = PurchaseNum.Count > 0 ? Convert.ToDecimal(PurchaseNum.ToList()[0]) : 0;
#endregion
#region 统计金额
var PurchaseAmount = query.Select((t1, t2, t3, t4, t5, t6) => SqlFunc.AggregateSum(t1.PurchaseAmount)).ToList();
_list.Total_Amount = PurchaseAmount.Count > 0 ? Convert.ToDecimal(PurchaseAmount.ToList()[0]) : 0;
#endregion
if (request.IsPaging)
{
int skipNum = request.PageSize * (request.PageIndex - 1);
queryData = await query
.Select((t1, t2, t3, t4, t5, t6) => new PurchaseCountListModel
{
OrderNo = t2.OrderNo,
OrderTypeId = t2.OrderTypeId,
OrderTypeName = t3.DicValue,
MaterialCode = t6.MaterialCode,
MaterialName = t6.MaterialName,
SupplierId = Convert.ToInt32(t1.SupplierId),
SupplierName = t4.SupplierName,
BuyerId = t2.BuyerId,
BuyerName = t5.AccountName,
PurchaseNum = t1.PurchaseNum,
UnitPrice = t1.UnitPrice,
PurchaseAmount = t1.PurchaseAmount,
AuditStatus = (byte)t2.AuditStatus,
OrderDate = t2.OrderDate
}).Skip(skipNum).Take(request.PageSize).ToListAsync();
}
else
{
queryData = await query
.Select((t1, t2, t3, t4, t5, t6) => new PurchaseCountListModel
{
OrderNo = t2.OrderNo,
OrderTypeId = t2.OrderTypeId,
OrderTypeName = t3.DicValue,
MaterialCode = t6.MaterialCode,
MaterialName = t6.MaterialName,
SupplierId = Convert.ToInt32(t1.SupplierId),
SupplierName = t4.SupplierName,
BuyerId = t2.BuyerId,
BuyerName = t5.AccountName,
PurchaseNum = t1.PurchaseNum,
UnitPrice = t1.UnitPrice,
PurchaseAmount = t1.PurchaseAmount,
AuditStatus = (byte)t2.AuditStatus,
OrderDate = t2.OrderDate
})
.ToListAsync();
}
_list.List = queryData;
return(ResponseUtil <PurchaseListModel> .SuccessResult(_list));
}
catch (Exception ex)
{
return(ResponseUtil <PurchaseListModel>
.FailResult(null, $"统计采购列表发生异常{System.Environment.NewLine} {ex.Message}"));
}
}
/// <summary>
/// 获取T_SSM_SalesOrderMain主表数据数据
/// </summary>
/// <param name="requestObject">Get请求参数</param>
/// <param name="currentUser"></param>
/// <returns>返回响应结果对象，包括响应代码，查询操作结果</returns>
public async Task <ResponseObject <List <TSSMSalesOrderMainQueryModel> > > GetMainListAsync(RequestGet requestObject, CurrentUser currentUser)
{
try
{
List <TSSMSalesOrderMainQueryModel> queryData = null; //查询结果集对象
RefAsync <int> totalNumber = -1; //总记录数
var query = _db.Instance.Queryable <TSSMSalesOrderMainDbModel, TBMCustomerFileDbModel, TSMUserAccountDbModel,
TBMDictionaryDbModel, TBMDictionaryDbModel, TSMUserAccountDbModel, TSMUserAccountDbModel>
(
(t, t0, t1, t2, t3, t4, t5) => new object[]
{
JoinType.Left, t.CustomerId == t0.ID,
JoinType.Left, t.SalesmanId == t1.ID,
JoinType.Left, t.OrderTypeId == t2.ID,
JoinType.Left, t.SettlementTypeId == t3.ID,
JoinType.Left, t.AuditId == t4.ID,
JoinType.Left, t.OperatorId == t5.ID
}
).Where((t, t0, t1, t2, t3, t4, t5) => t.DeleteFlag == false && SqlFunc.IsNull(t.IsMaterial, false) == false);
//查询条件
if (requestObject.QueryConditions != null && requestObject.QueryConditions.Count > 0)
{
//只能查询主表数据，且主表别名必须是t
var conditionals = SqlSugarUtil.GetConditionalModels(requestObject.QueryConditions);
foreach (ConditionalModel item in conditionals)
{
if (item.FieldName.ToLower() == "customername")
{
item.FieldName = $"t0.{item.FieldName}";
continue;
}
item.FieldName = $"t.{item.FieldName}";
}
query.Where(conditionals);
}
//排序条件
if (requestObject.OrderByConditions != null && requestObject.OrderByConditions.Count > 0)
{
foreach (var item in requestObject.OrderByConditions)
{
var exp = SqlSugarUtil.GetOrderByLambda <TSSMSalesOrderMainDbModel>(item.Column);
if (exp == null)
{
continue;
}
if (item.Condition.ToLower() != "asc" && item.Condition.ToLower() != "desc")
{
continue;
}
query.OrderBy($"{item.Column} {item.Condition}");
}
}
//执行查询
if (requestObject.IsPaging)
{
queryData = await query
.Select((t, t0, t1, t2, t3, t4, t5) => new TSSMSalesOrderMainQueryModel
{
ID = t.ID,
CustomerId = t.CustomerId,
CustomerName = t0.CustomerName,
SalesmanId = t.SalesmanId,
SalesmanName = t1.AccountName,
OrderNo = t.OrderNo,
OrderTypeId = t.OrderTypeId,
OrderTypeName = t2.DicValue,
SettlementTypeId = t.SettlementTypeId,
SettementTypeName = t3.DicValue,
Currency = t.Currency,
ReceiptAddress = t.ReceiptAddress,
OrderDate = t.OrderDate,
AuditStatus = t.AuditStatus,
AuditId = t.AuditId,
AuditName = t4.AccountName,
AuditTime = t.AuditTime,
OperatorId = t.OperatorId,
OperatorName = t5.AccountName,
ContactName = t.ContactName,
ContactNumber = t.ContactNumber,
CompanyId = t.CompanyId,
DeleteFlag = t.DeleteFlag,
TransferStatus = t.TransferStatus,
SalesAmount = t.SalesAmount,
SalesNum = t.SalesNum,
TransProdStatus = t.TransProdStatus
})
.Where(t => t.CompanyId == currentUser.CompanyID && !t.DeleteFlag)
.ToPageListAsync(requestObject.PageIndex, requestObject.PageSize, totalNumber);
}
else
{
queryData = await query
.Select((t, t0, t1, t2, t3, t4, t5) => new TSSMSalesOrderMainQueryModel
{
ID = t.ID,
CustomerId = t.CustomerId,
CustomerName = t0.CustomerName,
SalesmanId = t.SalesmanId,
SalesmanName = t1.AccountName,
OrderNo = t.OrderNo,
OrderTypeId = t.OrderTypeId,
OrderTypeName = t2.DicValue,
SettlementTypeId = t.SettlementTypeId,
SettementTypeName = t3.DicValue,
Currency = t.Currency,
ReceiptAddress = t.ReceiptAddress,
OrderDate = t.OrderDate,
AuditStatus = t.AuditStatus,
AuditId = t.AuditId,
AuditName = t4.AccountName,
AuditTime = t.AuditTime,
OperatorId = t.OperatorId,
OperatorName = t5.AccountName,
ContactName = t.ContactName,
ContactNumber = t.ContactNumber,
CompanyId = t.CompanyId,
DeleteFlag = t.DeleteFlag,
TransferStatus = t.TransferStatus,
SalesAmount = t.SalesAmount,
SalesNum = t.SalesNum,
TransProdStatus = t.TransProdStatus
})
.Where(t => t.CompanyId == currentUser.CompanyID && !t.DeleteFlag)
.ToListAsync();
}
//是否可编辑
queryData.ForEach(p => p.AllowEdit = p.AuditStatus != 2 && p.OperatorId == currentUser.UserID);
//返回执行结果
return(ResponseUtil <List <TSSMSalesOrderMainQueryModel> > .SuccessResult(queryData, totalNumber));
}
catch (Exception ex)
{
//返回查询异常结果
return(ResponseUtil <List <TSSMSalesOrderMainQueryModel> > .FailResult(null, ex.Message));
}
}
/// <summary>
/// 获取T_BM_CustomerFile主表数据数据
/// </summary>
/// <param name="requestObject">Get请求参数</param>
/// <param name="currentUser"></param>
/// <returns>返回响应结果对象，包括响应代码，查询操作结果</returns>
public async Task <ResponseObject <List <TBMCustomerFileQueryModel> > > GetMainListAsync(RequestGet requestObject, CurrentUser currentUser)
{
try
{
List <TBMCustomerFileQueryModel> queryData = new List <TBMCustomerFileQueryModel>(); //查询结果集对象
RefAsync <int> totalNumber = -1; //总记录数
var query = _db.Instance.Queryable <TBMCustomerFileDbModel, TBMCustomerContactDbModel>((t, t1) => new object[] {
JoinType.Left, t1.CustomerId == t.ID
}).Where((t, t1) => t.CompanyId == currentUser.CompanyID && t.DeleteFlag == false);
//数据字典
List <TBMDictionaryCacheModel> dics = BasicCacheGet.GetDic(currentUser);
List <ChinaAreaRecord> Areas = BasicCacheGet.GetChinaArea(currentUser);
//查询条件
if (requestObject.QueryConditions != null && requestObject.QueryConditions.Count > 0)
{
var customerConditions1 = requestObject.QueryConditions.Where(p => p.Column.ToLower() == "contactname").ToList();
if (customerConditions1 != null && customerConditions1.Count() > 0)
{
var conditionals = SqlSugarUtil.GetConditionalModels(customerConditions1);
foreach (ConditionalModel item in conditionals)
{
item.FieldName = $"t1.{item.FieldName}";
}
query.Where(conditionals);
}
var customerConditions2 = requestObject.QueryConditions.Where(p => p.Column.ToLower() != "contactname").ToList();
if (customerConditions2 != null && customerConditions2.Count() > 0)
{
var conditionals = SqlSugarUtil.GetConditionalModels(customerConditions2);
foreach (ConditionalModel item in conditionals)
{
item.FieldName = $"t.{item.FieldName}";
}
query.Where(conditionals);
}
}
//排序条件
if (requestObject.OrderByConditions != null && requestObject.OrderByConditions.Count > 0)
{
foreach (var item in requestObject.OrderByConditions)
{
var exp = SqlSugarUtil.GetOrderByLambda <TBMCustomerFileDbModel>(item.Column);
if (exp == null)
{
continue;
}
if (item.Condition.ToLower() != "asc" &&
item.Condition.ToLower() != "desc")
{
continue;
}
query.OrderBy($"{item.Column} {item.Condition}");
}
}
var query1 = query.Select((t, t1) => t).Distinct();
List <TBMCustomerFileDbModel> queryDataTemp = new List <TBMCustomerFileDbModel>();
//执行查询
if (requestObject.IsPaging)
{
queryDataTemp = await query1
.Where(t => !t.DeleteFlag)
.Select((t) => t)
.ToPageListAsync(requestObject.PageIndex, requestObject.PageSize, totalNumber);
}
else
{
queryDataTemp = await query1
.Where(t => !t.DeleteFlag)
.Select(t => t)
.ToListAsync();
}
queryDataTemp.ForEach((x) =>
{
var itemEnity = ExpressionGenericMapper <TBMCustomerFileDbModel, TBMCustomerFileQueryModel> .Trans(x);
itemEnity.ChildList = new List <TBMCustomerContactQueryModel>();
foreach (var citem in x.Child.OrderBy(p => p.Priority))
{
var citemEnity = ExpressionGenericMapper <TBMCustomerContactDbModel, TBMCustomerContactQueryModel> .Trans(citem);
itemEnity.ChildList.Add(citemEnity);
}
var item = dics.Where(p => p.ID == x.CustomerTypeId).FirstOrDefault();
if (item != null)
{
itemEnity.CustomerTypeName = item.DicValue;
}
if (x.IndustryId != null)
{
var industry = dics.Where(p => p.ID == x.IndustryId).FirstOrDefault();
if (x.IndustryId != null)
{
itemEnity.IndustryName = industry?.DicValue;
}
}
if (!string.IsNullOrEmpty(x.City))
{
var cityEntity = Areas.Where(p => p.Code == x.City).FirstOrDefault();
itemEnity.CityName = cityEntity?.FullName;
}
queryData.Add(itemEnity);
});
//返回执行结果
return(ResponseUtil <List <TBMCustomerFileQueryModel> > .SuccessResult(queryData, totalNumber));
}
catch (Exception ex)
{
//返回查询异常结果
return(ResponseUtil <List <TBMCustomerFileQueryModel> > .FailResult(null, ex.Message));
}
}
/// <summary>
/// 获取销售一览表信息
/// </summary>
/// <param name="request"></param>
/// <param name="currentUser"></param>
/// <returns></returns>
public async Task <ResponseObject <SalesListModel> > GetSalesList(RequestGet request, CurrentUser currentUser)
{
try
{
List <SalesCountListModel> queryData = null; //查询结果集对象
RefAsync <int> totalNumber = -1; //总记录数
var query = _db.Instance.Queryable <TSSMSalesOrderDetailDbModel, TSSMSalesOrderMainDbModel,
TBMDictionaryDbModel, TBMCustomerFileDbModel, TSMUserAccountDbModel, TBMPackageDbModel>(
(t, t0, t1, t2, t3, t4) => new object[]
{
JoinType.Left, t.MainId == t0.ID,
JoinType.Left, t0.OrderTypeId == t1.ID,
JoinType.Left, t0.CustomerId == t2.ID,
JoinType.Left, t0.SalesmanId == t3.ID,
JoinType.Left, t.PackageId == t4.ID
})
.Where((t, t0, t1, t2, t3, t4) => t0.CompanyId == currentUser.CompanyID && t4.DicValue != null);
//.OrderBy((t, t0, t1, t2, t3, t4) => t0.OrderNo);
//查询条件
if (request.QueryConditions != null && request.QueryConditions.Count > 0)
{
var conditionals = SqlSugarUtil.GetConditionalModels(request.QueryConditions);
foreach (ConditionalModel item in conditionals)
{
if (item.FieldName.ToLower() == "orderdate" ||
item.FieldName.ToLower() == "customerid" ||
item.FieldName.ToLower() == "ordertypeid" ||
item.FieldName.ToLower() == "salesmanid")
{
item.FieldName = $"t0.{item.FieldName}";
continue;
}
}
query.Where(conditionals);
}
//排序条件
if (request.OrderByConditions != null && request.OrderByConditions.Count > 0)
{
foreach (var item in request.OrderByConditions)
{
var exp = SqlSugarUtil.GetOrderByLambda <TSSMSalesOrderMainDbModel>(item.Column);
if (exp == null)
{
continue;
}
if (item.Condition.ToLower() != "asc" &&
item.Condition.ToLower() != "desc")
{
continue;
}
query.OrderBy($"t0.{item.Column} {item.Condition}");
}
}
else
{
query.OrderBy((t, t0, t1, t2, t3, t4) => t0.OrderNo);
}
SalesListModel _list = new SalesListModel();
_list.Total_Number = query.Count();
#region 统计数量
var SalesNum = query.Select((t, t0, t1, t2, t3, t4) => SqlFunc.AggregateSum(t.SalesNum)).ToList();
_list.Total_Num = SalesNum.Count > 0 ? Convert.ToDecimal(SalesNum.ToList()[0]) : 0;
#endregion
#region 统计金额
var SalesAmount = query.Select((t, t0, t1, t2, t3, t4) => SqlFunc.AggregateSum(t.SalesAmount)).ToList();
_list.Total_Amount = SalesAmount.Count > 0 ? Convert.ToDecimal(SalesAmount.ToList()[0]) : 0;
#endregion
if (request.IsPaging)
{
int skipNum = request.PageSize * (request.PageIndex - 1);
queryData = await query
.Select((t, t0, t1, t2, t3, t4) => new SalesCountListModel
{
OrderNo = t0.OrderNo,
OrderTypeId = t0.OrderTypeId,
OrderTypeName = t1.DicValue,
CustomerId = t0.CustomerId,
CustomerName = t2.CustomerName,
SalesManId = t0.SalesmanId,
SalesManName = t3.AccountName,
PackageId = t.PackageId,
PackageName = t4.DicValue,
SalesNum = t.SalesNum,
SalesAmount = t.UnitPrice,
AuditStatus = (byte)t0.AuditStatus,
OrderDate = t0.OrderDate
}).Skip(skipNum).Take(request.PageSize).ToListAsync();
}
else
{
queryData = await query
.Select((t, t0, t1, t2, t3, t4) => new SalesCountListModel
{
OrderNo = t0.OrderNo,
OrderTypeId = t0.OrderTypeId,
OrderTypeName = t1.DicValue,
CustomerId = t0.CustomerId,
CustomerName = t2.CustomerName,
SalesManId = t0.SalesmanId,
SalesManName = t3.AccountName,
PackageId = t.PackageId,
PackageName = t4.DicValue,
SalesNum = t.SalesNum,
SalesAmount = t.UnitPrice,
AuditStatus = (byte)t0.AuditStatus,
OrderDate = t0.OrderDate
})
.ToListAsync();
}
_list.List = queryData;
return(ResponseUtil <SalesListModel> .SuccessResult(_list));
}
catch (Exception ex)
{
return(ResponseUtil <SalesListModel>
.FailResult(null, $"查询销售一览表发生异常{System.Environment.NewLine}{ex.Message}"));
}
}
/// <summary>
/// 获取T_PSM_PurchaseOrderMain主表数据数据
/// </summary>
/// <param name="requestObject">Get请求参数</param>
/// <param name="currentUser"></param>
/// <returns>返回响应结果对象，包括响应代码，查询操作结果</returns>
public async Task <ResponseObject <List <TPSMPurchaseOrderMainQueryModel> > > GetMainListAsync(RequestGet requestObject, CurrentUser currentUser)
{
try
{
List <TPSMPurchaseOrderMainQueryModel> queryData = null; //查询结果集对象
RefAsync <int> totalNumber = -1; //总记录数
var query = _db.Instance.Queryable <TPSMPurchaseOrderMainDbModel,
TSMUserAccountDbModel, TBMDictionaryDbModel, TBMDictionaryDbModel, TSMUserAccountDbModel,
TSMUserAccountDbModel, TMMPurchaseApplyMainDbModel>(
(t, t1, t2, t3, t4, t5, t6) => new object[]
{
JoinType.Left, t.BuyerId == t1.ID,
JoinType.Left, t.OrderTypeId == t2.ID,
JoinType.Left, t.SettlementTypeId == t3.ID,
JoinType.Left, t.AuditId == t4.ID,
JoinType.Left, t.OperatorId == t5.ID,
JoinType.Left, t.SourceId == t6.ID
});
//查询条件
if (requestObject.QueryConditions != null && requestObject.QueryConditions.Count > 0)
{
var lessSourceID = requestObject.QueryConditions.Where(p => p.Column.ToLower() == "sourceid" && p.Condition == ConditionEnum.LessThan).FirstOrDefault();
if (lessSourceID != null)
{
requestObject.QueryConditions.Remove(lessSourceID);
query = query.Where((t, t1, t2, t3, t4, t5, t6) => SqlFunc.IsNull(t6.SourceId, 0) == 0);
}
if (requestObject.QueryConditions.Count > 0)
{
var conditionals = SqlSugarUtil.GetConditionalModels(requestObject.QueryConditions);
foreach (ConditionalModel item in conditionals)
{
if (item.FieldName.ToLower() == "suppliername")
{
item.FieldName = $"t0.{item.FieldName}";
continue;
}
item.FieldName = $"t.{item.FieldName}";
}
query.Where(conditionals);
}
}
//排序条件
if (requestObject.OrderByConditions != null && requestObject.OrderByConditions.Count > 0)
{
foreach (var item in requestObject.OrderByConditions)
{
var exp = SqlSugarUtil.GetOrderByLambda <TPSMPurchaseOrderMainDbModel>(item.Column);
if (exp == null)
{
continue;
}
if (item.Condition.ToLower() != "asc" &&
item.Condition.ToLower() != "desc")
{
continue;
}
query.OrderBy($"{item.Column} {item.Condition}");
}
}
//执行查询
if (requestObject.IsPaging)
{
queryData = await query
.Select((t, t1, t2, t3, t4, t5, t6) => new TPSMPurchaseOrderMainQueryModel
{
ID = t.ID,
BuyerId = t.BuyerId,
BuyerName = t1.AccountName,
OrderNo = t.OrderNo,
OrderDate = t.OrderDate,
OrderTypeId = t.OrderTypeId,
OrderTypeName = t2.DicValue,
SettlementTypeId = t.SettlementTypeId,
SettlementTypeName = t3.DicValue,
Currency = t.Currency,
AuditStatus = t.AuditStatus,
AuditId = t.AuditId,
AuditName = t4.AccountName,
AuditTime = t.AuditTime,
OperatorId = t.OperatorId,
OperatorName = t5.AccountName,
ContactName = t.ContactName,
ContactNumber = t.ContactNumber,
CompanyId = t.CompanyId,
DeleteFlag = t.DeleteFlag,
TransferStatus = t.TransferStatus,
PurchaseNum = t.PurchaseNum,
PurchaseAmount = t.PurchaseAmount,
AllowEdit = t.AuditStatus != 2 && t.OperatorId == currentUser.UserID,
SourceId = t.SourceId,
SourceNo = t6.PurchaseNo
})
.Where((t) => t.CompanyId == currentUser.CompanyID && !t.DeleteFlag)
.ToPageListAsync(requestObject.PageIndex, requestObject.PageSize, totalNumber);
}
else
{
queryData = await query
.Select((t, t1, t2, t3, t4, t5, t6) => new TPSMPurchaseOrderMainQueryModel
{
ID = t.ID,
BuyerId = t.BuyerId,
BuyerName = t1.AccountName,
OrderNo = t.OrderNo,
OrderDate = t.OrderDate,
OrderTypeId = t.OrderTypeId,
OrderTypeName = t2.DicValue,
SettlementTypeId = t.SettlementTypeId,
SettlementTypeName = t3.DicValue,
Currency = t.Currency,
AuditStatus = t.AuditStatus,
AuditId = t.AuditId,
AuditName = t4.AccountName,
AuditTime = t.AuditTime,
OperatorId = t.OperatorId,
OperatorName = t5.AccountName,
ContactName = t.ContactName,
ContactNumber = t.ContactNumber,
CompanyId = t.CompanyId,
DeleteFlag = t.DeleteFlag,
TransferStatus = t.TransferStatus,
PurchaseNum = t.PurchaseNum,
PurchaseAmount = t.PurchaseAmount,
SourceNo = t6.PurchaseNo,
SourceId = t.SourceId
})
.Where((t) => t.CompanyId == currentUser.CompanyID && !t.DeleteFlag)
.ToListAsync();
}
//返回执行结果
return(ResponseUtil <List <TPSMPurchaseOrderMainQueryModel> > .SuccessResult(queryData, totalNumber));
}
catch (Exception ex)
{
//返回查询异常结果
return(ResponseUtil <List <TPSMPurchaseOrderMainQueryModel> > .FailResult(null, ex.Message));
}
}
/// <summary>
/// 获取T_PM_SeedUsers数据
/// </summary>
/// <param name="requestObject">返回响应结果对象，包括响应代码，查询操作结果</param>
/// <returns></returns>
public async Task <ResponseObject <List <TPMSeedUsersQueryModel> > > GetAsync(RequestGet requestObject)
{
try
{
List <TPMSeedUsersQueryModel> queryData = null; //查询结果集对象
RefAsync <int> totalNumber = -1; //总记录数
var query = _db.Instance.Queryable <TPMSeedUsersDbModel>();
//查询条件
if (requestObject.QueryConditions != null && requestObject.QueryConditions.Count > 0)
{
var conditionals = SqlSugarUtil.GetConditionalModels(requestObject.QueryConditions);
query.Where(conditionals);
}
//排序条件
if (requestObject.OrderByConditions != null && requestObject.OrderByConditions.Count > 0)
{
foreach (var item in requestObject.OrderByConditions)
{
var exp = SqlSugarUtil.GetOrderByLambda <TPMSeedUsersDbModel>(item.Column);
if (exp == null)
{
continue;
}
if (item.Condition.ToLower() != "asc" &&
item.Condition.ToLower() != "desc")
{
continue;
}
query.OrderBy($"{item.Column} {item.Condition}");
}
}
//执行查询
if (requestObject.IsPaging)
{
queryData = await query.Select(
(t) => new TPMSeedUsersQueryModel
{
ID = t.ID,
Name = t.Name,
MobileNO = t.MobileNO,
EnterpriseName = t.EnterpriseName,
Address = t.Address,
CreateTime = t.CreateTime,
ChannelNo = t.ChannelNo,
})
.ToPageListAsync(requestObject.PageIndex, requestObject.PageSize, totalNumber);
}
else
{
queryData = await query.Select(
(t) => new TPMSeedUsersQueryModel
{
ID = t.ID,
Name = t.Name,
MobileNO = t.MobileNO,
EnterpriseName = t.EnterpriseName,
Address = t.Address,
CreateTime = t.CreateTime,
ChannelNo = t.ChannelNo,
})
.ToListAsync();
}
//返回执行结果
return(ResponseUtil <List <TPMSeedUsersQueryModel> > .SuccessResult(queryData, totalNumber));
}
catch (Exception ex)
{
//返回查询异常结果
return(ResponseUtil <List <TPMSeedUsersQueryModel> > .FailResult(null, ex.Message));
}
}
/// <summary>
/// 获取T_WM_SalesMain主表数据数据
/// </summary>
/// <param name="requestObject">Get请求参数</param>
/// <returns>返回响应结果对象，包括响应代码，查询操作结果</returns>
public async Task <ResponseObject <List <TWMSalesMainQueryModel> > > GetMainListAsync(RequestGet requestObject, CurrentUser currentUser)
{
try
{
List <TWMSalesMainQueryModel> queryData = null; //查询结果集对象
RefAsync <int> totalNumber = -1; //总记录数
var query = _db.Instance.Queryable <TWMSalesMainDbModel, TSSMSalesOrderMainDbModel, TBMCustomerFileDbModel,
TSMUserAccountDbModel, TSMUserAccountDbModel, TSMUserAccountDbModel, TSMUserAccountDbModel>((t, t1, t2, t3, t4, t5, t6) => new object[] {
JoinType.Inner, t.SourceId == t1.ID,
JoinType.Inner, t1.CustomerId == t2.ID,
JoinType.Left, t.OperatorId == t3.ID,
JoinType.Left, t.SendId == t4.ID,
JoinType.Left, t.WhAdminId == t5.ID,
JoinType.Left, t.AuditId == t6.ID
}).Where((t, t1, t2, t3, t4, t5, t6) => t.DeleteFlag == false && t.CompanyId == currentUser.CompanyID);
List <string> cQuery = new List <string>()
{
"customerid"
};
//查询条件
if (requestObject.QueryConditions != null && requestObject.QueryConditions.Count > 0)
{
var mconditionals = requestObject.QueryConditions.Where(p => !cQuery.Contains(p.Column.ToLower())).ToList();
if (mconditionals.Count() > 0)
{
List <IConditionalModel> conditionals = SqlSugarUtil.GetConditionalModels(mconditionals);
foreach (ConditionalModel item in conditionals)
{
item.FieldName = $"t.{item.FieldName}";
}
query.Where(conditionals);
}
var mconditionals2 = requestObject.QueryConditions.Where(p => cQuery.Contains(p.Column.ToLower())).ToList();
if (mconditionals2.Count() > 0)
{
List <IConditionalModel> conditionals = SqlSugarUtil.GetConditionalModels(mconditionals2);
foreach (ConditionalModel item in conditionals)
{
item.FieldName = $"t1.{item.FieldName}";
}
query.Where(conditionals);
}
}
//排序条件
if (requestObject.OrderByConditions != null && requestObject.OrderByConditions.Count > 0)
{
foreach (var item in requestObject.OrderByConditions)
{
var exp = SqlSugarUtil.GetOrderByLambda <TWMSalesMainDbModel>(item.Column);
if (exp == null)
{
continue;
}
if (item.Condition.ToLower() != "asc" &&
item.Condition.ToLower() != "desc")
{
continue;
}
query.OrderBy($"{item.Column} {item.Condition}");
}
}
//执行查询
if (requestObject.IsPaging)
{
queryData = await query.Select((t, t1, t2, t3, t4, t5, t6) => new TWMSalesMainQueryModel
{
ID = t.ID,
WhSendType = t.WhSendType,
WhSendDate = t.WhSendDate,
WhSendOrder = t.WhSendOrder,
AuditStatus = t.AuditStatus,
CustomerName = t2.CustomerName,
CustomerId = t1.CustomerId,
OperatorId = t.OperatorId,
OperatorName = t3.AccountName,
SendId = t.SendId,
SendName = t4.AccountName,
WhAdminId = t.WhAdminId,
WhAdminName = t5.AccountName,
AuditId = t.AuditId,
AuditName = t6.AccountName,
AuditTime = t.AuditTime,
DeleteFlag = t.DeleteFlag,
SourceId = t.SourceId,
Number = t.Number,
Amount = t.Amount,
ReceiptAddress = t.ReceiptAddress,
SaleOrder = t1.OrderNo,
IsShowEdit = (t.AuditStatus != 2 && t.OperatorId == currentUser.UserID) ? true : false
}).ToPageListAsync(requestObject.PageIndex, requestObject.PageSize, totalNumber);
}
else
{
queryData = await query.Select((t, t1, t2, t3, t4, t5, t6) => new TWMSalesMainQueryModel
{
ID = t.ID,
WhSendType = t.WhSendType,
WhSendDate = t.WhSendDate,
WhSendOrder = t.WhSendOrder,
AuditStatus = t.AuditStatus,
CustomerName = t2.CustomerName,
CustomerId = t1.CustomerId,
OperatorId = t.OperatorId,
OperatorName = t3.AccountName,
SendId = t.SendId,
SendName = t4.AccountName,
WhAdminId = t.WhAdminId,
WhAdminName = t5.AccountName,
AuditId = t.AuditId,
AuditName = t6.AccountName,
AuditTime = t.AuditTime,
DeleteFlag = t.DeleteFlag,
SourceId = t.SourceId,
Number = t.Number,
Amount = t.Amount,
ReceiptAddress = t.ReceiptAddress,
SaleOrder = t1.OrderNo,
IsShowEdit = (t.AuditStatus != 2 && t.OperatorId == currentUser.UserID) ? true : false
}).ToListAsync();
}
//返回执行结果
return(ResponseUtil <List <TWMSalesMainQueryModel> > .SuccessResult(queryData, totalNumber));
}
catch (Exception ex)
{
//返回查询异常结果
return(ResponseUtil <List <TWMSalesMainQueryModel> > .FailResult(null, ex.Message));
}
}
/// <summary>
/// 获取T_WM_ProductionWhMain主表数据数据
/// </summary>
/// <param name="requestObject">Get请求参数</param>
/// <returns>返回响应结果对象，包括响应代码，查询操作结果</returns>
public async Task <ResponseObject <List <TWMProductionWhMainQueryModel> > > GetMainListAsync(RequestGet requestObject, CurrentUser currentUser)
{
try
{
List <TWMProductionWhMainQueryModel> queryData = null; //查询结果集对象
RefAsync <int> totalNumber = -1; //总记录数
var query = _db.Instance.Queryable <TWMProductionWhMainDbModel, TMMWhApplyMainDbModel,
TSMUserAccountDbModel, TSMUserAccountDbModel, TSMUserAccountDbModel, TSMUserAccountDbModel, TMMProductionOrderMainDbModel>((t, t1, t2, t3, t4, t5, t6) => new object[] {
JoinType.Inner, t.SourceId == t1.ID,
JoinType.Left, t.OperatorId == t2.ID,
JoinType.Left, t.WhAdminId == t3.ID,
JoinType.Left, t.AuditId == t4.ID,
JoinType.Left, t.ReceiptId == t5.ID,
JoinType.Left, t1.SourceId == t6.ID
}).Where((t, t1, t2, t3, t4, t5, t6) => t.DeleteFlag == false && t.CompanyId == currentUser.CompanyID);
//查询条件
if (requestObject.QueryConditions != null && requestObject.QueryConditions.Count > 0)
{
var conditionals = SqlSugarUtil.GetConditionalModels(requestObject.QueryConditions);
foreach (ConditionalModel item in conditionals)
{
item.FieldName = $"t.{item.FieldName}";
}
query.Where(conditionals);
}
//排序条件
if (requestObject.OrderByConditions != null && requestObject.OrderByConditions.Count > 0)
{
foreach (var item in requestObject.OrderByConditions)
{
var exp = SqlSugarUtil.GetOrderByLambda <TWMProductionWhMainDbModel>(item.Column);
if (exp == null)
{
continue;
}
if (item.Condition.ToLower() != "asc" &&
item.Condition.ToLower() != "desc")
{
continue;
}
query.OrderBy($"{item.Column} {item.Condition}");
}
}
//执行查询
if (requestObject.IsPaging)
{
queryData = await query.Select((t, t1, t2, t3, t4, t5, t6) => new TWMProductionWhMainQueryModel
{
ID = t.ID,
WarehousingType = t.WarehousingType,
WarehousingDate = t.WarehousingDate,
WarehousingOrderNo = t.WarehousingOrderNo,
AuditStatus = t.AuditStatus,
OperatorId = t.OperatorId,
OperatorName = t2.AccountName,
ReceiptId = t.ReceiptId,
ReceiptName = t5.AccountName,
WhAdminId = t.WhAdminId,
WhAdminName = t3.AccountName,
AuditId = t.AuditId,
AuditName = t4.AccountName,
AuditTime = t.AuditTime,
CompanyId = t.CompanyId,
DeleteFlag = t.DeleteFlag,
SourceId = t.SourceId,
SourceCode = t1.WhApplyNo,
Number = t.Number,
Amount = t.Amount,
IsShowEdit = (t.AuditStatus != 2 && t.OperatorId == currentUser.UserID) ? true : false,
ProductionNo = t6.ProductionNo,
ProductionID = t6.ID
})
.ToPageListAsync(requestObject.PageIndex, requestObject.PageSize, totalNumber);
}
else
{
queryData = await query.Select((t, t1, t2, t3, t4, t5, t6) => new TWMProductionWhMainQueryModel
{
ID = t.ID,
WarehousingType = t.WarehousingType,
WarehousingDate = t.WarehousingDate,
WarehousingOrderNo = t.WarehousingOrderNo,
AuditStatus = t.AuditStatus,
OperatorId = t.OperatorId,
OperatorName = t2.AccountName,
ReceiptId = t.ReceiptId,
ReceiptName = t5.AccountName,
WhAdminId = t.WhAdminId,
WhAdminName = t3.AccountName,
AuditId = t.AuditId,
AuditName = t4.AccountName,
AuditTime = t.AuditTime,
CompanyId = t.CompanyId,
DeleteFlag = t.DeleteFlag,
SourceId = t.SourceId,
SourceCode = t1.WhApplyNo,
Number = t.Number,
Amount = t.Amount,
IsShowEdit = (t.AuditStatus != 2 && t.OperatorId == currentUser.UserID) ? true : false,
ProductionNo = t6.ProductionNo,
ProductionID = t6.ID
})
.ToListAsync();
}
//返回执行结果
return(ResponseUtil <List <TWMProductionWhMainQueryModel> > .SuccessResult(queryData, totalNumber));
}
catch (Exception ex)
{
//返回查询异常结果
return(ResponseUtil <List <TWMProductionWhMainQueryModel> > .FailResult(null, ex.Message));
}
}
/// <summary>
/// 获取盘点单明细列表
/// </summary>
/// <returns></returns>
public async Task <ResponseObject <List <TWMInventoryMainQueryModel> > > GetInventoryOrderListAsync(RequestGet requestGet, CurrentUser currentUser)
{
try
{
var mainList = GetMainListAsync(requestGet, currentUser).Result;
var mainIds = mainList.Data.Select(p => p.ID);
if (mainIds == null || mainIds.Count() < 1)
{
return(ResponseUtil <List <TWMInventoryMainQueryModel> > .SuccessResult(mainList.Data));
}
foreach (var item in mainList.Data)
{
item.ChildList = await _db.Instance.Queryable <TWMInventoryDetailDbModel, TBMMaterialFileDbModel, TBMDictionaryDbModel,
TBMDictionaryDbModel, TBMDictionaryDbModel, TBMDictionaryDbModel, TBMWarehouseFileDbModel>
(
(t, t0, t1, t2, t3, t4, t5) => new object[]
{
JoinType.Left, t.MaterialId == t0.ID,
JoinType.Left, t0.MaterialTypeId == t1.ID,
JoinType.Left, t0.ColorId == t2.ID,
JoinType.Left, t0.BaseUnitId == t3.ID,
JoinType.Left, t0.WarehouseUnitId == t4.ID,
JoinType.Left, t.WarehouseId == t5.ID
}
)
.Select((t, t0, t1, t2, t3, t4, t5) => new TWMInventoryDetailQueryModel
{
ID = t.ID,
MainId = t.MainId,
MaterialId = t.MaterialId,
MaterialCode = t0.MaterialCode,
MaterialName = t0.MaterialName,
MaterialTypeId = t0.MaterialTypeId,
MaterialTypeName = t1.DicValue,
ColorId = t0.ColorId,
ColorName = t2.DicValue,
Spec = t0.Spec,
BaseUnitId = t0.BaseUnitId,
BaseUnitName = t3.DicValue,
WarehouseUnitId = t0.WarehouseUnitId,
WarehouseUnitName = SqlFunc.IsNullOrEmpty(t4.ID) ? t3.DicValue : t4.DicValue,
WarehouseRate = t0.WarehouseRate,
WarehouseId = t.WarehouseId,
WarehouseName = t5.WarehouseName,
AccountNum = t.AccountNum,
ActualNum = t.ActualNum,
ProfitNum = t.ProfitNum,
DeficitNum = t.DeficitNum,
Remark = t.Remark,
})
.Where(t => t.MainId == item.ID)
.Take(2)
.ToListAsync();
}
return(ResponseUtil <List <TWMInventoryMainQueryModel> > .SuccessResult(mainList.Data, mainList.TotalNumber));
}
catch (Exception ex)
{
//返回查询异常结果
return(ResponseUtil <List <TWMInventoryMainQueryModel> > .FailResult(null, $"查询数据发生异常{Environment.NewLine}{ex.Message}"));
}
}
