| | |
|---|
| | | /// <param name="prdData">到期时间</param> |
|---|
| | | /// <returns></returns> |
|---|
| | | internal static bool CreateCntrItem(string loc, string cntr, string itemcode, string itemname, string itemtype, string cntrtype, |
|---|
| | | string batch, string wmslot, string weight, string unit, string tyreType, string supplier, string receiveLot, string subpool, string expData = "", string prdData = "", string level = "") |
|---|
| | | string batch, string wmslot, string weight, string unit, string tyreType, string supplier, string receiveLot, string subpool, string expData = "", string prdData = "", string level = "",int qty=0,int qtycfg=0) |
|---|
| | | { |
|---|
| | | var res = false; |
|---|
| | | var db = new SqlHelper<object>().GetInstance(); |
|---|
| | |
|---|
| | | ReceiveLot = receiveLot, |
|---|
| | | Subpool = subpool, |
|---|
| | | D_EXP_DATE = prdData, |
|---|
| | | D_PRD_DATE = expData |
|---|
| | | D_PRD_DATE = expData, |
|---|
| | | F_WEIGHT1= qty.ToString(), |
|---|
| | | F_QTY1= qtycfg |
|---|
| | | }; |
|---|
| | | db.Insertable<CntrItemDetail>(cir).ExecuteCommand(); |
|---|
| | | } |
|---|
| | |
|---|
| | | cntritem.Subpool = subpool; |
|---|
| | | cntritem.D_EXP_DATE = prdData; |
|---|
| | | cntritem.D_PRD_DATE = expData; |
|---|
| | | |
|---|
| | | cntritem. F_WEIGHT1 = qty.ToString(); |
|---|
| | | cntritem. F_QTY1 = qtycfg; |
|---|
| | | if (db.Updateable<CntrItemDetail>(cntritem).ExecuteCommand() > 0) |
|---|
| | | { |
|---|
| | | LogHelper.Info($"托盘{cntr}：更新物料{itemcode}绑定关系成功"); |
|---|
