/// <summary>
/// 获取质量追溯产品列表
/// </summary>
/// <param name="condition">条件</param>
/// <param name="page">数据页</param>
/// <returns>数据页</returns>
public DataPage GetList(QualityTraceCondition condition, DataPage page)
{
string sql = null;
List <DataParameter> parameters = new List <DataParameter>();
try
{
sql = this.GetQuerySql(condition, ref parameters);
//分页关键字段及排序
page.KeyName = "ID";
if (string.IsNullOrEmpty(page.SortExpression))
{
page.SortExpression = "CREATETIME DESC";
}
using (IDataSession session = AppDataFactory.CreateMainSession())
{
page = session.GetDataPage <QualityTraceInfo>(sql, parameters.ToArray(), page);
}
return(page);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取质量追溯产品列表
/// </summary>
/// <param name="user">查询条件</param>
/// <returns>数据</returns>
public DataTable GetExportData(QualityTraceCondition condition)
{
DataTable dt = null;
string sql = null;
List <DataParameter> parameters = new List <DataParameter>();
try
{
//构成查询语句
sql = this.GetQuerySql(condition, ref parameters);
using (IDataSession session = AppDataFactory.CreateMainSession())
{
dt = session.GetTable(sql, parameters.ToArray());
dt.TableName = "T_FP_GoodInfo";
}
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
private void BindData()
{
QualityTraceQueryBLL bll = null;
DataPage dp = new DataPage();
QualityTraceCondition condition = new QualityTraceCondition();
try
{
bll = BLLFactory.CreateBLL <QualityTraceQueryBLL>();
condition.StartDate = this.StartDate.Text;
condition.EndDate = this.EndDate.Text;
condition.Factory = this.Factory.SelectedValue;
condition.ProductLine = this.ProductLine.SelectedValue;
condition.Product = this.Product.SelectedValue;
condition.ProductBatchNumber = this.ProductBatchNumber.Text;
condition.MatIDCode = this.MatIDCode.Text;
condition.ProductIDCode = this.ProductIDCode.Text;
PagerHelper.InitPageControl(this.AspNetPager1, dp, true);
dp = bll.GetList(condition, dp);
List <QualityTraceInfo> list = dp.Result as List <QualityTraceInfo>;
this.GvList.DataSource = list;
this.GvList.DataBind();
for (int i = 0; i < this.GvList.Rows.Count; i++)
{
LinkButton lbtQualityTrace = this.GvList.Rows[i].Cells[7].FindControl("lbtQualityTrace") as LinkButton;
lbtQualityTrace.OnClientClick = "viewTraceDetail('" + this.GvList.DataKeys[i]["PID"].ToString() + "');return false;";
}
PagerHelper.SetPageControl(AspNetPager1, dp, true);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取查询语句
/// </summary>
/// <param name="user">查询条件</param>
/// <param name="parameters">参数</param>
/// <returns>查询语句</returns>
private string GetQuerySql(QualityTraceCondition condition, ref List <DataParameter> parameters)
{
StringBuilder sqlBuilder = new StringBuilder();
StringBuilder whereBuilder = new StringBuilder();
try
{
//构成查询语句
sqlBuilder.Append(@"SELECT G.PID,G.GoodBarCode,p.PCODE as ProductCode,p.PNAME as ProductName,
G.BatchNumber,f.PNAME as FactoryName,l.PLNAME as LineName,G.PLANDATE,g.CREATETIME
FROM T_FP_GoodInfo G
left outer join T_FP_PRODUCTINFO p on g.ProductionID=p.PID
left outer join T_FP_FACTORYINFO f on g.FACTORYPID=f.PID
left outer join T_FP_PRODUCTLINE l on g.PRID=l.PID");
if (string.IsNullOrEmpty(condition.StartDate) == false)
{
whereBuilder.Append(" AND PLANDATE >= @StartDate");
parameters.Add(new DataParameter("StartDate", DateTime.Parse(condition.StartDate)));
}
if (string.IsNullOrEmpty(condition.EndDate) == false)
{
whereBuilder.Append(" AND PLANDATE <= @EndDate");
parameters.Add(new DataParameter("EndDate", DateTime.Parse(condition.EndDate)));
}
if (string.IsNullOrEmpty(condition.Factory) == false)
{
whereBuilder.Append(" AND FACTORYPID <= @Factory");
parameters.Add(new DataParameter("Factory", condition.Factory));
}
if (string.IsNullOrEmpty(condition.ProductLine) == false)
{
whereBuilder.Append(" AND PRID <= @ProductLine");
parameters.Add(new DataParameter("ProductLine", condition.ProductLine));
}
if (string.IsNullOrEmpty(condition.Product) == false)
{
whereBuilder.Append(" AND ProductionID <= @Product");
parameters.Add(new DataParameter("Product", condition.Product));
}
if (string.IsNullOrEmpty(condition.ProductBatchNumber) == false)
{
whereBuilder.Append(" AND BatchNumber <= @BatchNumber");
parameters.Add(new DataParameter("BatchNumber", condition.ProductBatchNumber));
}
if (string.IsNullOrEmpty(condition.MatIDCode) == false)
{
//whereBuilder.Append(" AND BatchNumber <= @BatchNumber");
//parameters.Add(new DataParameter("BatchNumber", condition.ProductBatchNumber));
}
if (string.IsNullOrEmpty(condition.ProductIDCode) == false)
{
whereBuilder.Append(" AND GoodBarCode <= @ProductIDCode");
parameters.Add(new DataParameter("ProductIDCode", condition.ProductIDCode));
}
//查询条件
if (whereBuilder.Length > 0)
{
sqlBuilder.Append(" WHERE " + whereBuilder.ToString().Substring(4));
}
return(sqlBuilder.ToString());
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取质量追溯产品列表
/// </summary>
/// <param name="user">查询条件</param>
/// <returns>数据</returns>
public DataTable GetExportData(QualityTraceCondition condition)
{
return(new QualityTraceQueryDAL().GetExportData(condition));
}
/// <summary>
/// 获取质量追溯产品列表
/// </summary>
/// <param name="condition">条件</param>
/// <param name="page">数据页</param>
/// <returns>数据页</returns>
public DataPage GetList(QualityTraceCondition condition, DataPage page)
{
return(new QualityTraceQueryDAL().GetList(condition, page));
}
