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
}
}