242 lines
12 KiB
C#
Executable File
242 lines
12 KiB
C#
Executable File
using System;
|
|
using System.Collections.Generic;
|
|
using System.Data;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Threading.Tasks;
|
|
using Microsoft.Extensions.DependencyInjection;
|
|
using Opsoft.Data;
|
|
using Opsoft.NetCore.O3App.Domain;
|
|
using Opsoft.NetCore.O3App.Domain.Interface;
|
|
using Opsoft.NetCore.O3App.Domain.UnitOfWork.Equipment.IRepositories;
|
|
using Opsoft.NetCore.O3App.Domain.UnitOfWork.Equipment.Model;
|
|
using Opsoft.NetCore.O3App.Shared;
|
|
|
|
namespace Opsoft.NetCore.O3App.Repositories.Equipment
|
|
{
|
|
/// <summary>
|
|
/// 设备管理系统——备件
|
|
/// </summary>
|
|
[MapTo(typeof(ISpareParRepository), ServiceLifetime.Transient)]
|
|
public class SparePartRepository : RepositoryBase<BaseEntity>, ISpareParRepository
|
|
{
|
|
public SparePartRepository() : base()
|
|
{
|
|
|
|
}
|
|
|
|
/// <summary>
|
|
/// 获取备件列表
|
|
/// </summary>
|
|
/// <param name="data"></param>
|
|
/// <returns></returns>
|
|
public async Task<List<GetSparePart>> GetSparePart(dynamic data)
|
|
{
|
|
dynamic getData = JsonOperator.JsonDeserialize<dynamic>(data.ToString());
|
|
using APPServerContext context = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
|
|
List<GetSparePart> reData = new List<GetSparePart>();
|
|
string SQL = string.Empty;
|
|
SQL = $@"SELECT
|
|
S.FBILLNO,
|
|
S.FNAME,
|
|
S.FEQMODEL,
|
|
S.FINTERID,
|
|
ISNULL((SELECT SUM(FCOUNT) FROM T_ENG_SPAREINVENTORY WHERE FINTERID=S.FINTERID),0 ) AS FQTY
|
|
FROM T_ENG_EQSPAREPARTSLIST S";
|
|
if (!string.IsNullOrEmpty(getData.equipID.ToString()) && !string.IsNullOrEmpty(getData.sparePartName.ToString()))
|
|
{
|
|
SQL += $@" LEFT JOIN T_ENG_EQUIPMENTENTRY6 S2 ON S2.FSPAREPARTSID=S.FINTERID
|
|
WHERE S.FSTATUS=40 AND S.FDELETED=0 AND S2.FINTERID='{getData.equipID}' AND S.FNAME LIKE '%{getData.sparePartName}%'";
|
|
}
|
|
else if (!string.IsNullOrEmpty(getData.equipID.ToString()))
|
|
{
|
|
SQL += $@" LEFT JOIN T_ENG_EQUIPMENTENTRY6 S2 ON S2.FSPAREPARTSID=S.FINTERID
|
|
WHERE S.FSTATUS=40 AND S.FDELETED=0 AND S2.FINTERID='{getData.equipID}'";
|
|
}
|
|
else if (!string.IsNullOrEmpty(getData.sparePartName.ToString()))
|
|
{
|
|
SQL += $@" WHERE S.FSTATUS=40 AND S.FDELETED=0 AND S.FNAME LIKE '%{getData.sparePartName}%'";
|
|
}
|
|
else
|
|
{
|
|
SQL += " WHERE S.FSTATUS=40 AND S.FDELETED=0";
|
|
}
|
|
reData = await context.Database.SqlQueryAsync<GetSparePart>(SQL);
|
|
return reData;
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
/// 备件入库提交
|
|
/// </summary>
|
|
/// <param name="SData"></param>
|
|
/// <returns></returns>
|
|
public async Task<string> SparePartStorage(SparePartStorage SData)
|
|
{
|
|
using APPServerContext context = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
|
|
#region 自定义变量AND传参
|
|
string errMsg = string.Empty, SQL = string.Empty, interID = string.Empty, FSystemNO = string.Empty;
|
|
Dictionary<string, object> headData = SData.data;
|
|
List<Dictionary<string, object>> listData = SData.SData;
|
|
#endregion
|
|
|
|
if (headData["FAddStorageTypeID"].ToStringEx().IsNullOrEmpty())
|
|
{
|
|
throw new O3AppException("领用类型必填!");
|
|
}
|
|
#region 表头信息
|
|
interID = Guid.NewGuid().ToStringEx();
|
|
FSystemNO = CreateBilllNO(context, JsonOperator.JsonSerialize(new { FDATE = DateTime.Now }), "ENG_EqSparePartsCollection", "T_ENG_EQSPAREPARTSSTORAGE", "FSYSTEMNO", "", "");
|
|
await context.Database.SqlNonQueryAsync($@"INSERT INTO T_ENG_EQSPAREPARTSSTORAGE
|
|
(FINTERID,FISINANDOUT,FSOURCE,FSUPPLYID,FEQUIPMENTID,FADDSTORAGETYPEID
|
|
,FADDSTORAGEDATE,FNUMBER,FSYSTEMNO,FSTATUS,FCHECKERID,C_USER,C_YMD,FCHECKDATE,UID)
|
|
VALUES('{interID}',{SData.basicType.ToInt()},'移动端','{headData["FSupplyID"].ToStringEx()}'
|
|
,'{headData["FEquipmentID"].ToStringEx()}','{headData["FAddStorageTypeID"].ToStringEx()}'
|
|
,'{DateTime.Now}','{headData["FNumber"].ToStringEx()}','{FSystemNO}',{40},'{LoginInfo.UserID}'
|
|
,'{LoginInfo.UserID}','{DateTime.Now}','{DateTime.Now}','{Guid.NewGuid().ToStringEx()}')");
|
|
#endregion
|
|
|
|
#region 备件信息
|
|
int entryID = 1;
|
|
foreach (var sub in listData)
|
|
{
|
|
await context.Database.SqlNonQueryAsync($@"INSERT INTO T_ENG_EQSPAREPARTSSTORAGEENTRY
|
|
(FINTERID,FDETAILID,FENTRYID,FSPAREPARTSID
|
|
,FADDSTORAGEPRICE,FAMOUNT,FMONEY,FDESCRIPTION,UID)
|
|
VALUES('{interID}','{Guid.NewGuid().ToStringEx()}'
|
|
,{entryID++},'{sub["FSparePartID"]}',{sub["FAddStoragePrice"].ToDecimal()}
|
|
,{sub["FAmount"].ToDecimal()}
|
|
,{sub["FAddStoragePrice"].ToDecimal() * sub["FAmount"].ToDecimal()}
|
|
,'{sub["FNote"]}','{Guid.NewGuid().ToStringEx()}')");
|
|
}
|
|
#endregion
|
|
|
|
#region 更新库存
|
|
var groupForList = listData.GroupBy(x => x["FSparePartID"]).ToDictionary(a => a.Key, b => SData.basicType.ToDecimal() * b.Sum(o => o["FAmount"].ToDecimal())).ToList();
|
|
foreach (var sub in groupForList)
|
|
{
|
|
//检查库存信息
|
|
if (SData.basicType.ToInt() == -1)
|
|
{
|
|
object obj = context.Database.SqlQuery($@"SELECT SUM(FCOUNT) FROM T_ENG_SPAREINVENTORY WHERE FINTERID='{sub.Key}'");
|
|
if (obj.ToDecimal() < sub.Value.ToDecimal())
|
|
{
|
|
throw new O3AppException("备件领用失败,备件库存数量不足");
|
|
}
|
|
}
|
|
DataTable Inventory = context.Database.SqlQuery($@"SELECT * FROM T_ENG_SPAREINVENTORY WHERE FINTERID='{sub.Key}'");
|
|
if (Inventory.Rows.Count > 0)
|
|
{
|
|
await context.Database.SqlNonQueryAsync($@"UPDATE T_ENG_SPAREINVENTORY
|
|
SET FCOUNT={Inventory.Rows[0]["FCount"].ToDecimal() + sub.Value.ToDecimal()}
|
|
WHERE FINTERID='{sub.Key}'");
|
|
}
|
|
else
|
|
{
|
|
await context.Database.SqlNonQueryAsync($@"INSERT INTO T_ENG_SPAREINVENTORY(FINTERID,FCOUNT,UID)
|
|
VALUES('{sub.Key}',{sub.Value.ToDecimal()},'{Guid.NewGuid().ToStringEx()}')");
|
|
}
|
|
}
|
|
#endregion
|
|
return errMsg;
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
/// 备件盘点提交
|
|
/// </summary>
|
|
/// <param name="SData"></param>
|
|
/// <returns></returns>
|
|
public async Task<string> SparePartInventory(SparePartStorage SData)
|
|
{
|
|
using APPServerContext context = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
|
|
#region 自定义变量AND传参
|
|
string errMsg = string.Empty, SQL = string.Empty, interID = string.Empty, FBillNO = string.Empty, FSTOCKPEOID="";
|
|
Dictionary<string, object> headData = SData.data;
|
|
List<Dictionary<string, object>> listData = SData.SData;
|
|
#endregion
|
|
|
|
#region 表头信息
|
|
interID = Guid.NewGuid().ToStringEx();
|
|
|
|
DataTable FBillNOResult = null;
|
|
if (!headData["FNumber"].ToStringEx().IsNullOrEmpty())
|
|
{
|
|
FBillNOResult = context.Database.SqlQuery($@"SELECT
|
|
S.FBILLNO
|
|
FROM T_ENG_SPARESTOCK S WHERE S.FBILLNO='{headData["FNumber"].ToStringEx()}'");
|
|
if (FBillNOResult != null && FBillNOResult.Rows.Count == 1)
|
|
{
|
|
throw new O3AppException("盘点编号已重复!", 400); ;
|
|
}
|
|
else
|
|
{
|
|
FBillNO = headData["FNumber"].ToStringEx();
|
|
}
|
|
}
|
|
else
|
|
{
|
|
FBillNO = CreateBilllNO(context, JsonOperator.JsonSerialize(new { FDATE = DateTime.Now }), "ENG_SpareStock", "T_ENG_SPARESTOCK", "FBILLNO", "", "");
|
|
}
|
|
|
|
string FName = string.Empty;
|
|
if (string.IsNullOrEmpty(headData["FName"].ToStringEx()))
|
|
{
|
|
FName = "备件盘点";
|
|
}
|
|
else
|
|
{
|
|
FName = headData["FName"].ToStringEx();
|
|
}
|
|
if (headData["FSTOCKPEOID"].ToStringEx() != "")
|
|
{
|
|
FSTOCKPEOID = headData["FSTOCKPEOID"].ToStringEx();
|
|
}
|
|
else if (!LoginInfo.PAID.IsNullOrEmpty() && LoginInfo.PAType.Equals("1"))
|
|
{
|
|
string fStockpeoID = context.Database.SqlQueryString($@"SELECT FINTERID FROM T_HR_EMPINFO WHERE FNUMBER='{LoginInfo.PAID}'");
|
|
if (fStockpeoID != "")
|
|
{
|
|
FSTOCKPEOID = fStockpeoID;
|
|
}
|
|
}
|
|
else
|
|
{
|
|
FSTOCKPEOID = "";
|
|
}
|
|
if (!string.IsNullOrEmpty(LoginInfo.UserID))
|
|
{
|
|
await context.Database.SqlNonQueryAsync($@"INSERT INTO T_ENG_SPARESTOCK
|
|
(FINTERID,FSTOCKNAME,FSPAREDATE,FSTOCKPEOID,C_USER,FBILLNO,UID)
|
|
VALUES('{interID}','{FName}','{DateTime.Now}','{FSTOCKPEOID}','{LoginInfo.UserID}'
|
|
,'{FBillNO}','{Guid.NewGuid().ToStringEx()}')");
|
|
}
|
|
else
|
|
{
|
|
await context.Database.SqlNonQueryAsync($@"INSERT INTO T_ENG_SPARESTOCK
|
|
(FINTERID,FSTOCKNAME,FSPAREDATE,FBILLNO,UID)
|
|
VALUES('{interID}','{FName}','{DateTime.Now}'
|
|
,'{FBillNO}','{Guid.NewGuid().ToStringEx()}')");
|
|
}
|
|
#endregion
|
|
|
|
#region 备件信息
|
|
int entryID = 1;
|
|
foreach (var sub in listData)
|
|
{
|
|
decimal FSURPLUS = (sub["FAmount"].ToDecimal() - sub["FQty"].ToDecimal()) > 0 ? (sub["FAmount"].ToDecimal() - sub["FQty"].ToDecimal()) : 0;//盘盈数量
|
|
decimal FLose = (sub["FQty"].ToDecimal() - sub["FAmount"].ToDecimal()) > 0 ? (sub["FQty"].ToDecimal() - sub["FAmount"].ToDecimal()) : 0;//盘盈数量
|
|
await context.Database.SqlNonQueryAsync($@"INSERT INTO T_ENG_SPARESTOCKENTRY
|
|
(FINTERID,FDETAILID,FENTRYID,FSBOM
|
|
,FREALQUANTITY,FCOUNT,FSURPLUS,FLOSE,UID)
|
|
VALUES('{interID}','{Guid.NewGuid().ToStringEx()}'
|
|
,{entryID++},'{sub["FSparePartID"]}',{sub["FAmount"].ToDecimal()}
|
|
,{sub["FQty"].ToDecimal()},{FSURPLUS},{FLose},'{Guid.NewGuid().ToStringEx()}')");
|
|
}
|
|
#endregion
|
|
|
|
return errMsg;
|
|
}
|
|
}
|
|
}
|