public async Task <KgmApiResultEntity> TempScanFinish(FinishTempScanDto dto)
{
SearchCondition search = new SearchCondition();
search.AddCondition("F_EnCode", dto.CMCWHCode, SqlOperator.Equal);
var warehouse = BLLFactory <Mst_Warehouse> .Instance.FindSingle(search.BuildConditionSql().Replace("Where", string.Empty));
search = new SearchCondition();
search.AddCondition("F_EnCode", dto.CMPosCode, SqlOperator.Equal);
var position = BLLFactory <Mst_CargoPosition> .Instance.FindSingle(search.BuildConditionSql().Replace("Where", string.Empty));
dto.CMCWHCode = warehouse == null ? "" : warehouse.F_Id;
dto.CMPosCode = position == null ? "" : position.F_Id;
KgmApiResultEntity result = new KgmApiResultEntity();
result.result = true;
return(await Task.Run(() =>
{
var dt = BLLFactory <AppCommon> .Instance.TempScanFinish(dto);
if (Convert.ToInt32(dt.Rows[0][0]) == 0)
{
result.result = false;
}
result.message = result.result == true ? "操作成功" : dt.Rows[0][1].ToString();
return result;
}));
}
/// <summary>
/// 删除单据
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public KgmApiResultEntity DeleteOrder(string ID)
{
List <SmartDbParameter> paramList = new List <SmartDbParameter>();
paramList.Add(CreateInSmartDbParameter("ID", DbType.String, ID));
KgmApiResultEntity entity = new KgmApiResultEntity();
return(entity);
}
public async Task <KgmApiResultEntity> LoginSystem([FromBody] LoginSystemModel loginModel)
{
if (string.IsNullOrEmpty(loginModel.Password))
{
loginModel.Password = string.Empty;
}
KgmApiResultEntity result = await loginSystemAsync(loginModel);
return(result);
}
public async Task <KgmApiResultEntity> GetCurrentUserMenu()
{
return(await Task.Run(() =>
{
KgmApiResultEntity result = new KgmApiResultEntity();
result.result = true;
result.message = JsonAppHelper.ToJson(BLLFactory <Sys_RoleAuthorize> .Instance.GetUserMenu(currentUserId));
return result;
}));
}
public async Task <KgmApiResultEntity> GetScanCyList(string orderNo, string orderType)
{
return(await Task.Run(() =>
{
KgmApiResultEntity resultEntity = new KgmApiResultEntity()
{
result = true,
message = JsonAppHelper.ToJson(BLLFactory <AppCommon> .Instance.GetScanCyList(orderNo, orderType))
};
return resultEntity;
}));
}
///// 获取审核状态
///// </summary>
///// <param name="KeyValue"></param>
///// <returns></returns>
//public string StatusSate(string KeyValue)
//{
// SO_HeadInfo soHeadInfo = BLLFactory<SO_Head>.Instance.FindByID(KeyValue);
// if (soHeadInfo.F_Status == "True")
// {
// return "该产品还没审核";
// }
// else
// {
// return "产品已审核";
// }
//}
/// <summary>
/// 删除
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public KgmApiResultEntity DeleteById(string Id)
{
Hashtable ht = new Hashtable();
ht.Add("@Id", Id);
DataSet ds = base.ExecuteDataSetByProc("DELETE_SO", ht);
KgmApiResultEntity result = new KgmApiResultEntity
{
result = ds.Tables[0].Rows[0][0].ToString() == "0" ? true : false,
message = ds.Tables[0].Rows[0][1].ToString()
};
return(result);
}
/// <summary>
/// 审核
/// </summary>
/// <param name="Id"></param>
/// <param name="user"></param>
/// <param name="orderType"></param>
/// <returns></returns>
public KgmApiResultEntity Verify(string Id, string user, int orderType)
{
Hashtable ht = new Hashtable();
ht.Add("@Id", Id);
ht.Add("@@USERNAME", user);
ht.Add("@ORDERTYPE", orderType);
DataSet ds = base.ExecuteDataSetByProc("[VERIFYLIST_SO]", ht);
KgmApiResultEntity result = new KgmApiResultEntity
{
result = ds.Tables[0].Rows[0][0].ToString() == "0" ? true : false,
message = ds.Tables[0].Rows[0][1].ToString()
};
return(result);
}
public async Task <KgmApiResultEntity> TempScanFinish(FinishTempScanDto dto)
{
KgmApiResultEntity result = new KgmApiResultEntity();
result.result = true;
return(await Task.Run(() =>
{
var dt = BLLFactory <AppCommon> .Instance.TempScanFinish(dto);
if (Convert.ToInt32(dt.Rows[0][0]) == 0)
{
result.result = false;
}
result.message = dt.Rows[0][1].ToString();
return result;
}));
}
public async Task <string> GetCurrentUser(LoginModel model)
{
KgmApiResultEntity result = new KgmApiResultEntity();//返回对象
SearchCondition condition = new SearchCondition();
condition.AddCondition("F_Account", model.Account, SqlOperator.Equal);
Sys_UserInfo loginResult = BLLFactory <Sys_User> .Instance.FindSingle(condition.BuildConditionSql().Replace(" Where (1=1) AND", string.Empty));
if (loginResult == null)
{
result.result = false;
result.message = "用户名不存在!";
}
else if (!loginResult.F_UserPassword.Equals(DESEncrypt.Encrypt(model.Password)))
{
result.result = false;
result.message = "用户名与密码不匹配!";
}
else
{
bool isadmin = false;
if (loginResult.F_EnabledMark == false)
{
result.result = false;
result.message = "该用户已被禁用，请联系管理员启用后再进行登录!";
}
else
{
if (loginResult.F_IsAdministrator == true)
{
isadmin = true;
}
//生成token
var token = await JWTTokenHelper.GetTokenAsync(loginResult.F_Id, "0", isadmin);
var id = currentUserId;
result.result = true;
result.message = token;
}
}
return(JsonAppHelper.ToJson(new { status = result.result, token = result.message, User = loginResult }));
}
public async Task <string> GetModuleTree()
{
return(await Task.Run(() =>
{
SearchCondition search = new SearchCondition();
search.AddCondition("F_IsApp", true, SqlOperator.Equal);
KgmApiResultEntity result = new KgmApiResultEntity();
List <GetModel> getModels = new List <GetModel>();
var moduleList = BLLFactory <Sys_Module> .Instance.Find(BuilderConditionStr(search));
for (int i = 0; i < moduleList.Count(); i++)
{
GetModel model = new GetModel();
model.icon = moduleList[i].F_Icon;
model.src = moduleList[i].F_UrlAddress;
model.title = moduleList[i].F_FullName;
model.parent = "inStock";
getModels.Add(model);
}
return JsonAppHelper.ToJson(new { result = true, message = getModels });
}));
}
public async Task <KgmApiResultEntity> GetWarSelectList()
{
return(await Task.Run(() => {
KgmApiResultEntity result = new KgmApiResultEntity();
List <Mst_WarehouseInfo> wList = BLLFactory <Mst_Warehouse> .Instance.GetAll();
List <SelectModel> list = new List <SelectModel>();
if (wList != null && wList.Count > 0)
{
foreach (var item in wList)
{
SelectModel select = new SelectModel()
{
id = item.F_EnCode,
text = "[" + item.F_EnCode + "]" + item.F_FullName
};
list.Add(select);
}
}
result.message = JsonAppHelper.ToJson(list);
return result;
}));
}
/// <summary>
/// 登录系统
/// </summary>
/// <param name="loginModel">登录对象</param>
/// <returns></returns>
private async Task <KgmApiResultEntity> loginSystemAsync(LoginSystemModel loginModel)
{
KgmApiResultEntity result = new KgmApiResultEntity();//返回对象
result.result = false;
result.message = "";
string errorInfo = string.Empty;
if (!bRegister(out errorInfo))
{
result.result = false;
result.message = errorInfo;
return(result);
}
Sys_UserInfo loginResult;//登录对象
bool bAdmin = false;
if (loginModel.Account.Equals(ConstValue.KGMADMIN_USERNAME) && loginModel.Password.Equals(ConstValue.KGMADMIN_PASSWORD))
{
//超级管理员
loginResult = new Sys_UserInfo();
loginResult.F_Id = ConstValue.KGMADMIN_USERID;
loginResult.F_UserPassword = ConstValue.KGMADMIN_PASSWORD;
loginResult.F_RealName = ConstValue.KGMADMIN_USERNAME;
bAdmin = true;
}
else
{
SearchCondition condition = new SearchCondition();
condition.AddCondition("F_Account", loginModel.Account, SqlOperator.Equal);
loginResult = BLLFactory <Sys_User> .Instance.FindSingle(condition.BuildConditionSql().Replace(" Where (1=1) AND", string.Empty));
}
if (loginResult == null)
{
SaveLoginLog(loginModel.Account, string.Empty, loginModel.LoginSystem.ToString(), false, "用户名不存在!");
result.result = false;
result.message = "用户名不存在!";
}
else if (!loginResult.F_UserPassword.Equals(DESEncrypt.Encrypt(loginModel.Password)))
{
SaveLoginLog(loginModel.Account, string.Empty, loginModel.LoginSystem.ToString(), false, "用户名与密码不匹配!");
result.result = false;
result.message = "用户名与密码不匹配!";
}
else
{
string token = ""; //token
//生成token
token = await JWTTokenHelper.GetTokenAsync(loginResult.F_Id, loginModel.LoginSystem, bAdmin);
SaveLoginLog(loginResult.F_Account, loginResult.F_NickName, loginModel.LoginSystem.ToString(), true, "登录成功");
result.result = true;
result.message = token;
}
return(result);
}
///// <summary>
/////审核单据
///// </summary>
///// <param name="Id">审核单据</param>
///// <param name="user">审核人</param>
//public string Audit(string Id, string user)
//{
// using (DbTransactionScope<SO_HeadInfo> dbtran = base.CreateTransactionScope())
// {
// DateTime time = DateTime.Now;
// try
// {
// SO_HeadInfo info = BLLFactory<SO_Head>.Instance.FindByID(Id);
// if (info.F_Status == "True") return "单据已审核出库";
// //根据单据找到需要出库的产品
// SearchCondition search = new SearchCondition();
// search.AddCondition("F_Hid", Id, SqlOperator.Equal);
// List<SO_BodyInfo> BodyInfo = BLLFactory<SO_Body>.Instance.Find(search.BuildConditionSql().Replace("Where (1=1) AND ", string.Empty).Replace("Where (1=1)", " ( 1 = 1 ) "));
// //获取单据
// SO_HeadInfo HeadInfo = BLLFactory<SO_Head>.Instance.FindByID(Id);
// //循环出库，添加记录
// List<Sys_StockInfo> list = BLLFactory<Sys_Stock>.Instance.GetAll();
// List<Sys_OutRecordsInfo> OutList = new List<Sys_OutRecordsInfo>();
// List<Sys_StockHistoryInfo> StockHisList = new List<Sys_StockHistoryInfo>();
// //客户Id
// string CustomerId = BLLFactory<SO_Head>.Instance.FindByID(Id).F_CustomerId;
// foreach (var item in BodyInfo)
// {
// Sys_StockInfo stockInfo = list.Find(u => u.F_CargoPositionId == item.F_CargoPositionId && u.F_WarehouseId == item.F_WarehouseId && u.F_GoodsId == item.F_GoodsId);
// if (stockInfo.F_Number - item.F_OutStockNum < 0)
// {
// return "产品数量发生了变化，请重新选择审核出库";
// }
// Hashtable has = new Hashtable();
// has.Add("F_Number", stockInfo.F_Number - item.F_OutStockNum);
// Sys_Stock.Instance.Update(stockInfo.F_Id, has, dbtran.Transaction);
// //产品出库记录
// Sys_OutRecordsInfo outInfo = new Sys_OutRecordsInfo();
// outInfo.F_Batch = info.F_EnCode;
// outInfo.F_GoodsId = item.F_GoodsId;
// outInfo.F_GoodsName = item.F_GoodsName;
// outInfo.F_EnCode = item.F_EnCode;
// outInfo.F_OutStockNum =item.F_OutStockNum;
// outInfo.F_CargoPositionId = item.F_CargoPositionId;
// outInfo.F_CargoPositionName = item.F_CargoPositionName;
// outInfo.F_WarehouseId = item.F_WarehouseId;
// outIn[';'' arehouseName = item.F_WarehouseName;
// outInfo.F_CreatorTime = DateTime.Now;
// outInfo.F_CreatorUserId = item.F_CreatorUserId;
// outInfo.F_Description = item.F_Description;
// outInfo.F_CustomerId = CustomerId;
// outInfo.F_Unit = item.F_Unit;
// outInfo.F_Address = info.F_Address;
// outInfo.F_Contacts = info.F_Contacts;
// outInfo.F_Operator = info.F_Operator;
// outInfo.F_CustomerName = info.F_CustomerName;
// outInfo.F_TelePhone = info.F_TelePhone;
// OutList.Add(outInfo);
// //添加库存信息
// Sys_StockHistoryInfo7 HistoryInfo = new Sys_StockHistoryInfo();
// HistoryInfo.F_CargoPositionId = item.F_CargoPositionId;
// HistoryInfo.F_CargoPositionName = item.F_CargoPositionName;
// HistoryInfo.F_WarehouseId = item.F_WarehouseId;
// HistoryInfo.F_WarehouseName = item.F_WarehouseName;
// HistoryInfo.F_EnCode= info.F_EnCode;
// HistoryInfo.F_Batch =item.F_Batch;
// HistoryInfo.F_BllCategory = "出库";
// HistoryInfo.F_OperationNum = 0 - item.F_OutStockNum;
// HistoryInfo.F_SpecifModel = item.F_SpecifModel;
// HistoryInfo.F_Vendor = user;
// HistoryInfo.F_GoodsId = item.F_GoodsId;
// HistoryInfo.F_GoodsName = item.F_GoodsName;
// HistoryInfo.F_Unit = item.F_Unit;
// HistoryInfo.F_VendorName = info.F_CustomerName;
// HistoryInfo.F_Contacts = info.F_Contacts;
// HistoryInfo.F_TelePhone = info.F_TelePhone;
// HistoryInfo.F_Maker = info.F_CreatorUserId;
// HistoryInfo.F_Verify = user;
// HistoryInfo.F_VeriDate = time;
// StockHisList.Add(HistoryInfo);
// }
// //添加出库记录
// Sys_OutRecords.Instance.InsertRange(OutList, dbtran.Transaction);
// //添加库存记录
// Sys_StockHistory.Instance.InsertRange(StockHisList, dbtran.Transaction);
// //审核单据
// Hashtable hash = new Hashtable();
// hash.Add("F_Status", 1);
// hash.Add("F_AuditingUser", user);
// hash.Add("F_VeriDate", time);
// SO_Head.Instance.Update(Id, hash, dbtran.Transaction);
// dbtran.Commit();
// return "审核出库成功";
// }
// catch (Exception)
// {
// dbtran.RollBack();
// throw;
// }
// }
//}
/// <summary>
/// 保存
/// </summary>
/// <returns></returns>
public KgmApiResultEntity Save(DataSet ds)
{
Hashtable ht = new Hashtable();
ht.Add("@PARM_SAVELIST_DP_HEAD", ds.Tables[0]);
ht.Add("@PARM_SAVELIST_DP_BODY", ds.Tables[1]);
ds = base.ExecuteDataSetByProc("SAVELIST_SO", ht);
KgmApiResultEntity result = new KgmApiResultEntity
{
result = ds.Tables[0].Rows[0][0].ToString() == "0" ? true : false,
message = ds.Tables[0].Rows[0][1].ToString()
};
return(result);
//using (DbTransactionScope<SO_HeadInfo> dbtran = base.CreateTransactionScope())
//{
// try
// {
// if (string.IsNullOrEmpty(info.F_EnCode))
// {
// string orderNo = "OT" + DateTime.Now.ToString("yyyyMMdd");
// Hashtable hash = new Hashtable();
// hash.Add("Prefix", orderNo);
// DataTable dt = base.StorePorcToDataTable("SYS_CREATESN", hash, null, dbtran.Transaction);
// string SN = dt.Rows[0][0].ToString().PadLeft(6, '0');
// info.F_EnCode = orderNo + SN;
// }
// else
// {
// //判断当前单据是否已经审核
// var head = this.FindByID(info.F_Id, dbtran.Transaction);
// if (head != null && head.F_Status == "True")
// {
// throw new ApplicationException("单据已经审核!");
// }
// }
// //添加主表
// info.F_Date = info.F_Date;
// SO_Head.Instance.InsertUpdate(info, info.F_Id, dbtran.Transaction);
// //删除子表
// SearchCondition condition = new SearchCondition();
// condition.AddCondition("F_HId", info.F_Id, SqlOperator.Equal);
// SO_Body.Instance.DeleteByCondition(condition.BuildConditionSql().Replace("Where (1=1) AND ", string.Empty), dbtran.Transaction);
// //循环添加子表
// foreach (SO_BodyInfo item in dInfo)
// {
// item.F_CreatorTime = DateTime.Now;
// item.F_CreatorUserId = info.F_CreatorUserId;
// item.F_Id = Guid.NewGuid().ToString();
// item.F_HId = info.F_Id;
// item.F_GoodsName = BLLFactory<Mst_Goods>.Instance.FindByID(item.F_GoodsId).F_FullName;
// }
// SO_Body.Instance.InsertRange(dInfo, dbtran.Transaction);
// dbtran.Commit();
// return info;
// }
// catch (Exception ex)
// {
// dbtran.RollBack();
// throw ex;
// }
}
public async Task <KgmApiResultEntity> SaveTempScan([FromBody] SaveTempScanModel dto)
{
string[] str = dto.Barcode.Split('|');
KgmApiResultEntity result = new KgmApiResultEntity();
SearchCondition search = new SearchCondition();
search.AddCondition("F_EnCode", dto.Warehouse, SqlOperator.Equal);
var warehouse = BLLFactory <Mst_Warehouse> .Instance.FindSingle(search.BuildConditionSql().Replace("Where", string.Empty));
if (warehouse == null)
{
result.result = false;
result.message = "仓库编码错误";
return(result);
}
;
dto.Warehouse = warehouse.F_Id;
search = new SearchCondition();
search.AddCondition("F_EnCode", str[0], SqlOperator.Equal);
search = new SearchCondition();
search.AddCondition("F_EnCode", dto.Position, SqlOperator.Equal);
var position = BLLFactory <Mst_CargoPosition> .Instance.FindSingle(search.BuildConditionSql().Replace("Where", string.Empty));
if (position == null)
{
result.result = false;
result.message = "货位编码错误";
return(result);
}
dto.Position = position.F_Id;
if (!String.IsNullOrEmpty(dto.DesPosition))
{
search = new SearchCondition();
search.AddCondition("F_EnCode", dto.DesPosition, SqlOperator.Equal);
var DesPosition = BLLFactory <Mst_CargoPosition> .Instance.FindSingle(search.BuildConditionSql().Replace("Where", string.Empty));
if (DesPosition == null)
{
result.result = false;
result.message = "目标仓库编码错误";
return(result);
}
}
if (!string.IsNullOrEmpty(dto.DesWarehouse))
{
search = new SearchCondition();
search.AddCondition("F_EnCode", dto.DesWarehouse, SqlOperator.Equal);
var DesWarehouse = BLLFactory <Mst_CargoPosition> .Instance.FindSingle(search.BuildConditionSql().Replace("Where", string.Empty));
if (DesWarehouse == null)
{
result.result = false;
result.message = "目标货位编码错误";
return(result);
}
}
result.result = true;
return(await Task.Run(() =>
{
var dt = BLLFactory <AppCommon> .Instance.SaveTempScan(dto);
if (!string.IsNullOrEmpty(dt.Rows[0][0].ToString()))
{
result.result = false;
}
result.message = result.result == true ? "操作成功" : dt.Rows[0][0].ToString();
if (dto.DeleteMark)
{
result.message = result.result == true ? "删除成功" : dt.Rows[0][0].ToString();
}
return result;
}));
}
public async Task <KgmApiResultEntity> GetBoolPostion(string orderNo, string orderType, string PositionCode)
{
return(await Task.Run(() =>
{
KgmApiResultEntity entity = new KgmApiResultEntity()
{
result = true
};
SearchCondition search = new SearchCondition();
search.AddCondition("F_EnCode", orderNo, SqlOperator.Equal);
switch (orderType.ToUpper())
{
case "PI":
var PIdata = BLLFactory <PI_Head> .Instance.FindSingle(search.BuildConditionSql().Replace("Where", string.Empty));
search = new SearchCondition();
search.AddCondition("F_EnCode", PositionCode, SqlOperator.Equal);
search.AddCondition("F_WarehouseId", PIdata.F_WarehouseId, SqlOperator.Equal);
if (BLLFactory <Mst_CargoPosition> .Instance.FindSingle(search.BuildConditionSql().Replace("Where", string.Empty)) == null)
{
var warehouse = BLLFactory <Mst_Warehouse> .Instance.FindByID(PIdata.F_WarehouseId);
entity.result = false;
entity.message = "货位编码错误或货位不属于仓库" + warehouse.F_Id;
return entity;
}
break;
case "SO":
var SOdata = BLLFactory <SO_Head> .Instance.FindSingle(search.BuildConditionSql().Replace("Where", string.Empty));
search = new SearchCondition();
search.AddCondition("F_EnCode", PositionCode, SqlOperator.Equal);
search.AddCondition("F_WarehouseId", SOdata.F_WarehouseId, SqlOperator.Equal);
if (BLLFactory <Mst_CargoPosition> .Instance.FindSingle(search.BuildConditionSql().Replace("Where", string.Empty)) == null)
{
var warehouse = BLLFactory <Mst_Warehouse> .Instance.FindByID(SOdata.F_WarehouseId);
entity.result = false;
entity.message = "货位编码错误或货位不属于仓库" + warehouse.F_Id;
return entity;
}
break;
case "CW":
var CWdata = BLLFactory <SO_Head> .Instance.FindSingle(search.BuildConditionSql().Replace("Where", string.Empty));
search = new SearchCondition();
search.AddCondition("F_EnCode", PositionCode, SqlOperator.Equal);
search.AddCondition("F_WarehouseId", CWdata.F_WarehouseId, SqlOperator.Equal);
if (BLLFactory <Mst_CargoPosition> .Instance.FindSingle(search.BuildConditionSql().Replace("Where", string.Empty)) == null)
{
var warehouse = BLLFactory <Mst_Warehouse> .Instance.FindByID(CWdata.F_WarehouseId);
entity.result = false;
entity.message = "货位编码错误或货位不属于仓库" + warehouse.F_Id;
return entity;
}
break;
//case "MP":
// var CWdata = BLLFactory<SO_Head>.Instance.FindSingle(search.BuildConditionSql().Replace("Where", string.Empty));
// search = new SearchCondition();
// search.AddCondition("F_EnCode", PositionCode, SqlOperator.Equal);
// search.AddCondition("F_WarehouseId", CWdata.F_WarehouseId, SqlOperator.Equal);
// if (BLLFactory<Mst_CargoPosition>.Instance.FindSingle(search.BuildConditionSql().Replace("Where", string.Empty)) == null)
// {
// var warehouse = BLLFactory<Mst_Warehouse>.Instance.FindByID(CWdata.F_WarehouseId);
// entity.result = false;
// entity.message = "货位编码错误或货位不属于仓库" + warehouse.F_Id;
// return entity;
// }
// break;
}
return entity;
}));
}
public async Task <KgmApiResultEntity> GetList([FromBody] SearchModel model)
{
return(await Task.Run(() =>
{
KgmApiResultEntity result = new KgmApiResultEntity();
var message = string.Empty;
if (string.IsNullOrEmpty(model.orderNo))
{
result.result = false;
result.message = "未获取到单据号";
return result;
}
var user = BLLFactory <Sys_User> .Instance.FindByID(model.UserId);
SearchCondition search = new SearchCondition();
search.AddCondition("F_EnCode", model.orderNo, SqlOperator.Equal);
switch (model.orderType.ToLower())
{
case "pi":
PI_HeadInfo PIhead = BLLFactory <PI_Head> .Instance.FindSingle(BuilderConditionStr(search));
var warehosue = BLLFactory <Mst_Warehouse> .Instance.FindByID(PIhead.F_WarehouseId);
if (PIhead == null)
{
result.result = false;
result.message = "未获取到单据信息，请输入正确的单据号！";
return result;
}
if (PIhead.F_Status == 0)
{
result.result = false;
result.message = "单据未审核，请先审核！";
return result;
}
if (PIhead.F_Status > 1)
{
result.result = false;
result.message = "单据已经完成,不允许扫描！";
return result;
}
if (user.F_IsAdministrator == false && PIhead.F_WarehouseId != user.F_WarehouseId)
{
result.result = false;
result.message = "用户" + user.F_FullName + "不允许操作仓库为" + warehosue.F_FullName + "的数据";
return result;
}
else
{
search = new SearchCondition();
search.AddCondition("F_Hid", PIhead.F_Id, SqlOperator.Equal);
var data = BLLFactory <PI_Body> .Instance.Find(BuilderConditionStr(search));
if (data != null && data.Count > 0)
{
foreach (var item in data)
{
// var position = BLLFactory<Mst_CargoPosition>.Instance.FindByID(item.F_CargoPositionId);
var goods = BLLFactory <Mst_Goods> .Instance.FindByID(item.F_GoodsId);
item.F_WarehouseName = warehosue == null ? "" : warehosue.F_FullName;
item.F_WarehouseCode = warehosue == null ? "" : warehosue.F_EnCode;
//item.F_CargoPositionName = position == null ? "" : position.F_FullName;
//item.F_CargoPositionCode = position == null ? "" : position.F_EnCode;
item.F_GoodsId = goods == null ? "" : goods.F_FullName;
item.F_BarCode = goods == null ? "|" : goods.F_EnCode + "|";
item.F_QTY = item.F_InStockNum;
}
}
result.result = true;
result.message = JsonAppHelper.ToJson(data);
}
break;
case "so":
SO_HeadInfo SOhead = BLLFactory <SO_Head> .Instance.FindSingle(BuilderConditionStr(search));
var SOwarehosue = BLLFactory <Mst_Warehouse> .Instance.FindByID(SOhead.F_WarehouseId);
if (SOhead == null)
{
result.result = false;
result.message = "未获取到单据信息，请输入正确的单据号！";
return result;
// return JsonAppHelper.ToJson(new { result = false, message = "未获取到单据信息，请输入正确的单据号！" });
}
if (int.Parse(SOhead.F_Status) == 0)
{
result.result = false;
result.message = "未审核，请先审核！";
return result;
// return JsonAppHelper.ToJson(new { result = false, message = "单据未审核，请先审核！" });
}
if (int.Parse(SOhead.F_Status) > 1)
{
result.result = false;
result.message = "单据已经完成,不允许扫描！";
return result;
// return JsonAppHelper.ToJson(new { result = false, message = "单据已经完成,不允许扫描！" });
}
if (user.F_IsAdministrator == false && SOhead.F_WarehouseId != user.F_WarehouseId)
{
result.result = false;
result.message = "用户" + user.F_FullName + "不允许操作仓库为" + SOwarehosue.F_FullName + "的数据";
return result;
}
else
{
search = new SearchCondition();
search.AddCondition("F_Hid", SOhead.F_Id, SqlOperator.Equal);
var data = BLLFactory <SO_Body> .Instance.Find(BuilderConditionStr(search));
if (data != null && data.Count > 0)
{
foreach (var item in data)
{
// var position = BLLFactory<Mst_CargoPosition>.Instance.FindByID(item.F_CargoPositionId);
var goods = BLLFactory <Mst_Goods> .Instance.FindByID(item.F_GoodsId);
item.F_WarehouseName = SOwarehosue == null ? "" : SOwarehosue.F_FullName;
item.F_WarehouseCode = SOwarehosue == null ? "" : SOwarehosue.F_EnCode;
//item.F_CargoPositionName = position == null ? "" : position.F_FullName;
//item.F_CargoPositionCode = position == null ? "" : position.F_EnCode;
item.F_GoodsId = goods == null ? "" : goods.F_FullName;
item.F_BarCode = goods == null ? "|" : goods.F_EnCode + "|" + item.F_Batch;
item.F_QTY = item.F_OutStockNum;
}
}
result.result = true;
result.message = JsonAppHelper.ToJson(data);
}
break;
case "cw":
SO_StockMakeHeadInfo CWhead = BLLFactory <SO_StockMakeHead> .Instance.FindSingle(BuilderConditionStr(search));
var Cwwarehosue = BLLFactory <Mst_Warehouse> .Instance.FindByID(CWhead.F_WarehouseId);
if (CWhead == null)
{
result.result = false;
result.message = "未获取到单据信息，请输入正确的单据号！";
return result;
// return JsonAppHelper.ToJson(new { result = false, message = "未获取到单据信息，请输入正确的单据号！" });
}
if (CWhead.F_Status == 0)
{
result.result = false;
result.message = "单据未审核，请先审核！";
return result;
//return JsonAppHelper.ToJson(new { result = false, message = "单据未审核，请先审核！" });
}
if (CWhead.F_Status > 1)
{
result.result = false;
result.message = "单据已经完成,不允许扫描！";
return result;
//return JsonAppHelper.ToJson(new { result = false, message = "单据已经完成,不允许扫描！" });
}
if (user.F_IsAdministrator == false && CWhead.F_WarehouseId != user.F_WarehouseId)
{
result.result = false;
result.message = "用户" + user.F_FullName + "不允许操作仓库为" + Cwwarehosue.F_FullName + "的数据";
return result;
}
else
{
search = new SearchCondition();
search.AddCondition("F_Hid", CWhead.F_Id, SqlOperator.Equal);
var data = BLLFactory <SO_StockMakeBody> .Instance.Find(BuilderConditionStr(search));
if (data != null && data.Count > 0)
{
foreach (var item in data)
{
var position = BLLFactory <Mst_CargoPosition> .Instance.FindByID(item.F_CargoPositionId);
var goods = BLLFactory <Mst_Goods> .Instance.FindByID(item.F_GoodsId);
item.F_WarehouseName = Cwwarehosue == null ? "" : Cwwarehosue.F_FullName;
item.F_WarehouseCode = Cwwarehosue == null ? "" : Cwwarehosue.F_EnCode;
item.F_CargoPositionName = position == null ? "" : position.F_FullName;
item.F_CargoPositionCode = position == null ? "" : position.F_EnCode;
item.F_GoodsId = goods == null ? "" : goods.F_FullName;
item.F_BarCode = goods == null ? "|" : goods.F_EnCode + "|" + item.F_Batch;
item.F_QTY = int.Parse(item.F_RealNumber);
}
}
result.result = true;
result.message = JsonAppHelper.ToJson(data);
}
break;
default:
result.message = "[]";
break;
}
return result;
//return JsonAppHelper.ToJson(new { result = t, message = "单据未审核，请先审核！" });
}));
}