| | |
| | | var list = db.Queryable<CntrItemRel>().Where(a => a.S_CNTR_CODE == cntr).ToList(); |
| | | return list; |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 根据容器获取物料信息 |
| | | /// </summary> |
| | | /// <param name="cntr"></param> |
| | | /// <returns></returns> |
| | | internal static bool deleteCntrItemRelByCntr(string cntr) |
| | | { |
| | | var db = new SqlHelper<object>().GetInstance(); |
| | | var container = ContainerHelper.GetCntr(cntr); |
| | | if(container != null) |
| | | { |
| | | db.Deleteable<CntrItemRel>().Where(a => a.S_CNTR_CODE == cntr).ExecuteCommand(); |
| | | |
| | | container.N_DETAIL_COUNT = 0; |
| | | db.Updateable(container).ExecuteCommand(); |
| | | } |
| | | return true; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 根据容器来源和状态获取托盘 |
| | | /// </summary> |