/// <summary> /// 工具流水账记录 /// </summary> /// <param name="ctx">数据上下文</param> /// <param name="toolsInfo">工具台帐对象</param> /// <param name="billNo">单据号</param> public void DayToDayAccount(DepotManagementDataContext ctx, S_MachineAccount_Tools toolsInfo, string billNo) { S_DayToDay_Tools dayToDayInfo = new S_DayToDay_Tools(); dayToDayInfo.BillNo = billNo; dayToDayInfo.GoodsID = toolsInfo.GoodsID; dayToDayInfo.OpeartionCount = toolsInfo.StockCount; dayToDayInfo.OperationTime = ServerTime.Time; dayToDayInfo.Provider = toolsInfo.Provider; dayToDayInfo.StorageCode = toolsInfo.StorageCode; DayToDayAccount(ctx, dayToDayInfo); }
/// <summary> /// 流水账记录 /// </summary> /// <param name="ctx">数据上下文</param> /// <param name="dayToDayInfo">流水账对象</param> public void DayToDayAccount(DepotManagementDataContext ctx, S_DayToDay_Tools dayToDayInfo) { var varData = from a in ctx.S_DayToDay_Tools where a.BillNo == dayToDayInfo.BillNo && a.GoodsID == dayToDayInfo.GoodsID && a.Provider == dayToDayInfo.Provider && a.StorageCode == dayToDayInfo.StorageCode select a; if (varData.Count() == 0) { dayToDayInfo.OperationTime = ServerTime.Time; ctx.S_DayToDay_Tools.InsertOnSubmit(dayToDayInfo); } else { throw new Exception("流水账记录不唯一"); } }