using HH.WMS.DAL.Algorithm; using HH.WMS.DAL.Check; using HH.WMS.DAL.Common; using HH.WMS.Entitys.Algorithm; using HH.WMS.Entitys.Basic; using HH.WMS.Entitys.Check; using HH.WMS.Entitys.Common; using System; using System.Collections.Generic; using System.Data; using System.Data.Common; using System.Linq; using System.Text; using System.Threading.Tasks; namespace HH.WMS.BLL.Check { public class TN_WM_CHECK_DTLBLL : DapperBaseBLL { #region 获取分页列表 /// /// 获取分页列表 /// /// /// /// [HanHe(lt)] CREATED 2018/7/3 public DataTable GetDataTable(dynamic obj) { DataTable dt = CreateDAL().GetDataTable(obj); dt.Columns.Add("CN_S_AREA_NAME"); Dictionary areaDic = new Dictionary(); for (int i = 0; i < dt.Rows.Count; i++) { 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 #region 新增 /// /// 增加一条数据 /// /// [HanHe(lt)] CREATED 2018/7/3 public SqlExecuteResult Add(TN_WM_CHECK_DTLEntity entity) { return CreateDAL().Add(entity, null); } /// /// 增加多条数据 /// /// [HanHe(lt)] CREATED 2018/8/23 public SqlExecuteResult Addlist(List entity) { return CreateDAL().Addlist(entity, null); } #endregion #region 修改 /// /// 更新一条数据 /// /// [HanHe(lt)] CREATED 2018/7/3 public SqlExecuteResult Update(TN_WM_CHECK_DTLEntity entity) { return CreateDAL().Update(entity, null); } #endregion #region 删除 /// /// 删除一条数据 /// /// [HanHe(lt)] CREATED 2018/7/3 public SqlExecuteResult Delete(string sqlwhere, DbTransaction trans) { return CreateDAL().Delete(sqlwhere, null); } #endregion #region 查询盘点业务主表 /// /// 查询盘点业务主表 /// /// 查询条件 /// /// [HanHe(lt)] CREATED 2018/7/3 public DataTable Getentity(string sqlwhere) { DataTable dt = CreateDAL().Getentity(sqlwhere); dt.Columns.Add("CN_S_AREA_NAME"); Dictionary areaDic = new Dictionary(); for (int i = 0; i < dt.Rows.Count; i++) { 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; } /// /// 查询盘点业务主表 /// /// 查询条件 /// /// [HanHe(lt)] CREATED 2018/7/3 public DataTable Getjoinentity(string sqlwhere) { DataTable dt = CreateDAL().Getjoinentity(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 #region 查询盘点结果明细表 /// /// 查询盘点结果明细表 /// /// 查询条件 /// /// [HanHe(lt)] CREATED 2018/7/143 public DataTable GetResultentity(string sqlwhere) { return CreateDAL().GetResultentity(sqlwhere); } public DataTable GetDataTableResult(dynamic obj) { return CreateDAL().GetDataTableResult(obj); } #endregion } }