using HH.WMS.DAL.Algorithm; using HH.WMS.DAL.Common; using HH.WMS.DAL.MoveStock; using HH.WMS.Entitys.Algorithm; using HH.WMS.Entitys.Basic; using HH.WMS.Entitys.Common; using HH.WMS.Entitys.MoveStock; using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Text; using System.Threading.Tasks; namespace HH.WMS.BLL.MoveStock { public class TN_WM_MOVE_DTLBLL : DapperBaseBLL { #region 获取分页列表 /// /// 获取分页列表 /// /// /// /// [HanHe(lt)] CREATED 2018/9/11 public DataTable GetDataTable(dynamic obj) { return CreateDAL().GetDataTable(obj); } /// /// 获取列表 /// /// /// /// [HanHe(lt)] CREATED 2018/10/9 public DataTable getInfo(string sqlWhere) { return CreateDAL().getInfo(sqlWhere); } #endregion #region 新增 /// /// 增加一条数据 /// /// [HanHe(lt)] CREATED 2018/9/10 public SqlExecuteResult Add(TN_WM_MOVE_DTLEntity entity) { return CreateDAL().Add(entity, null); } #endregion #region 修改 /// /// 增加一条数据 /// /// [HanHe(lt)] CREATED 2018/9/11 public SqlExecuteResult Update(TN_WM_MOVE_DTLEntity entity) { return CreateDAL().Update(entity, null); } #endregion #region 删除 /// /// 删除一条数据 /// /// [HanHe(lt)] CREATED 2018/9/10 public SqlExecuteResult Delete(string sqlwhere) { return CreateDAL().Delete(sqlwhere, null); } #endregion #region 修改查询移库明细 /// /// 修改查询移库明细 /// /// [HanHe(lt)] CREATED 2018/9/19 public DataTable GetDtl(string sqlwhere) { DataTable dt = CreateDAL().GetDtl(sqlwhere); Dictionary stockDic = new Dictionary(); Dictionary areaDic = new Dictionary(); dt.Columns.Add("CN_S_STOCK_NAME"); dt.Columns.Add("CN_S_AREA_NAME"); for (int i = 0; i < dt.Rows.Count; i++) { if (!string.IsNullOrEmpty(dt.Rows[i]["CN_S_STOCK_CODE"].ToString())) //获取仓库名称 { if (!stockDic.ContainsKey(dt.Rows[i]["CN_S_STOCK_CODE"].ToString())) { TN_AB_STOCKEntity stockentity = CreateDAL().GetStockentity("CN_S_STOCK_CODE", dt.Rows[i]["CN_S_STOCK_CODE"].ToString());//获取仓库名称 if (stockentity != null) { dt.Rows[i]["CN_S_STOCK_NAME"] = stockentity.CN_S_STOCK_NAME; stockDic.Add(dt.Rows[i]["CN_S_STOCK_CODE"].ToString(), stockentity.CN_S_STOCK_NAME); } } else { dt.Rows[i]["CN_S_STOCK_NAME"] = stockDic[dt.Rows[i]["CN_S_STOCK_CODE"].ToString()]; } } if (!string.IsNullOrEmpty(dt.Rows[i]["CN_S_STOCK_AREA"].ToString()))//获取库区名称 { if (!areaDic.ContainsKey(dt.Rows[i]["CN_S_STOCK_AREA"].ToString())) { AutoBomStockAreaEntity areaentity = CreateDAL().GetModel(dt.Rows[i]["CN_S_STOCK_AREA"].ToString());//获取库区名称 if (areaentity != null) { dt.Rows[i]["CN_S_AREA_NAME"] = areaentity.CN_S_AREA_NAME; areaDic.Add(dt.Rows[i]["CN_S_STOCK_AREA"].ToString(), areaentity.CN_S_AREA_NAME); } } else { dt.Rows[i]["CN_S_AREA_NAME"] = areaDic[dt.Rows[i]["CN_S_STOCK_AREA"].ToString()]; } } } return dt; } #endregion } }