private QuanlityExportInfo GetQualityExport_ModelFromDataReader(SqlDataReader dr)
{
QuanlityExportInfo model = new QuanlityExportInfo();
model.ID = dr["ID"].ToInt32();
model.CreateDate = dr["createdate"].ToDateTime();
model.VoucherNo = dr["VoucherNo"].ToDBString();
model.DeliveryNo = dr["DeliveryNo"].ToDBString();
model.SupplierNo = dr["SupplierNo"].ToDBString();
model.SupplierName = dr["SupplierName"].ToDBString();
model.Plant = dr["Plant"].ToDBString();
model.MoveType = dr["MoveType"].ToDBString();
model.MaterialDoc = dr["MaterialDoc"].ToDBString();
model.PrintedQty = dr["PrintedQty"].ToInt32();
model.PrintTime = dr["PrintTime"].ToDateTimeNull();
model.RowNo = dr["RowNo"].ToDBString();
model.MaterialNo = dr["MaterialNo"].ToDBString();
model.MaterialDesc = dr["MaterialDesc"].ToDBString();
model.ReceiveQty = dr["ReceiveQty"].ToDecimal();
model.Unit = dr["Unit"].ToDBString();
model.PrdVersion = dr["PrdVersion"].ToDBString();
model.QualityQty = dr["QualityQty"].ToDecimal();
model.UnQualityQty = dr["UnQualityQty"].ToDecimal();
model.QualityType = dr["QualityType"].ToInt32();
model.StrQualityType = dr["StrQualityType"].ToDBString();
return(model);
}
private string GetFilterSql(QuanlityExportInfo model, UserInfo user)
{
try
{
string strSql = "";
bool hadWhere = false;
if (!string.IsNullOrEmpty(model.MaterialDoc))
{
strSql = Common_Func.AddWhereAnd(strSql, hadWhere);
strSql += " MaterialDoc Like '%" + model.MaterialDoc + "%' ";
hadWhere = true;
}
if (!string.IsNullOrEmpty(model.VoucherNo))
{
strSql = Common_Func.AddWhereAnd(strSql, hadWhere);
strSql += " VoucherNo Like '%" + model.VoucherNo + "%' ";
hadWhere = true;
}
if (!string.IsNullOrEmpty(model.DeliveryNo))
{
strSql = Common_Func.AddWhereAnd(strSql, hadWhere);
strSql += " DeliveryNo Like '%" + model.DeliveryNo + "%' ";
hadWhere = true;
}
if (!string.IsNullOrEmpty(model.MaterialNo))
{
strSql = Common_Func.AddWhereAnd(strSql, hadWhere);
strSql += " (MaterialNo LIKE '%" + model.MaterialNo + "%' OR MaterialDesc Like '%" + model.MaterialNo + "%') ";
hadWhere = true;
}
if (model.StartTime != null)
{
strSql = Common_Func.AddWhereAnd(strSql, hadWhere);
strSql += " createdate >= " + model.StartTime.ToDateTime().Date.ToSqlTimeString();
hadWhere = true;
}
if (model.EndTime != null)
{
strSql = Common_Func.AddWhereAnd(strSql, hadWhere);
strSql += " createdate <= " + model.EndTime.ToDateTime().AddDays(1).Date.ToSqlTimeString();
hadWhere = true;
}
return(strSql);
}
catch
{
return(string.Empty);
}
}
/// <summary>
/// 获取检验通知书导出数据
/// </summary>
/// <param name="strErrMsg"></param>
/// <returns></returns>
public bool GetQualityExportListByPage(ref List <QuanlityExportInfo> modelList, QuanlityExportInfo model, ref DividPage page, UserInfo user, ref string strError)
{
if (page == null)
{
page = new DividPage();
}
List <QuanlityExportInfo> lstModel = new List <QuanlityExportInfo>();
try
{
using (SqlDataReader dr = Common_DB.QueryByDividPage(ref page, "V_GetQualityExportInfo", GetFilterSql(model, user), "*", "Order By CreateDate Desc"))
{
while (dr.Read())
{
lstModel.Add(GetQualityExport_ModelFromDataReader(dr));
}
}
modelList = lstModel;
return(true);
}
catch (Exception ex)
{
strError = ex.Message;
return(false);
}
finally
{
}
}
