| | |
| | | |
| | | } |
| | | /// <summary> |
| | | /// 根据托盘编码查询托盘物料绑定 |
| | | /// </summary> |
| | | /// <param name="cntr"></param> |
| | | /// <returns></returns> |
| | | internal static CntrItemDetail FindCntrItemByCntr(string cntr) |
| | | { |
| | | //1.0 查货位容器表 |
| | | var db = new SqlHelper<object>().GetInstance(); |
| | | return db.Queryable<CntrItemDetail>().Where(a => a.S_ITEM_CODE.Trim() == cntr).First(); |
| | | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 修改入库时间 |
| | | /// </summary> |
| | | /// <param name="cntr"></param> |
| | | /// <returns></returns> |
| | | internal static bool UpdateInTime(CntrItemDetail cntrItem) |
| | | { |
| | | //1.0 查货位容器表 |
| | | var db = new SqlHelper<object>().GetInstance(); |
| | | cntrItem.T_INBOUND_TIME=DateTime.Now.ToString("yyyy-MM-dd"); |
| | | return db.Updateable<CntrItemDetail>(cntrItem).UpdateColumns(a => new { a.T_INBOUND_TIME }).ExecuteCommand()>0; |
| | | |
| | | } |
| | | /// <summary> |
| | | /// 根据容器号获取货位容器绑定关系 |
| | | /// </summary> |
| | | /// <param name="cntr"></param> |