| | |
| | | var list = db.Queryable<CntrItemRel>().Where(a => a.S_CNTR_CODE == cntr).ToList(); |
| | | return list; |
| | | } |
| | | internal static bool BindNewCntrItem(string loc,string cntrCode, string itemCode) { |
| | | var res = false; |
| | | var itemName = ItemHelper.GetItemInfo(itemCode).S_ITEM_NAME; |
| | | var db = new SqlHelper<object>().GetInstance(); |
| | | try { |
| | | db.BeginTran(); |
| | | var cntr = new Container { S_CODE = cntrCode, N_DETAIL_COUNT = 1 }; |
| | | db.Insertable(cntr).ExecuteCommand(); |
| | | //获取物料信息,填充到容器货品明细,方便人工查看 |
| | | var cir = new CntrItemRel { S_CNTR_CODE = cntr.S_CODE.Trim(), F_QTY = 1, S_ITEM_CODE = itemCode, S_ITEM_NAME = itemName }; |
| | | db.Insertable<CntrItemRel>(cir).ExecuteCommand(); |
| | | var lcr = new LocCntrRel { S_CNTR_CODE = cntrCode, S_LOC_CODE = loc }; |
| | | db.Insertable<LocCntrRel>(lcr).ExecuteCommand(); |
| | | db.CommitTran(); |
| | | res = true; |
| | | } |
| | | catch (Exception ex) { |
| | | db.RollbackTran(); |
| | | Console.WriteLine(ex.Message); |
| | | } |
| | | |
| | | return res; |
| | | } |
| | | |
| | | |
| | | internal static bool addCntrItem(string cntrCode, CntrItemRel cntrItemRel) |
| | | { |