using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using Model;
|
using Common;
|
using System.Data;
|
using System.Collections;
|
|
namespace BLL.DAL
|
{
|
public class DALDeliveryOutDetail
|
{
|
public IList<DeliveryOutDetail> GetList(AjaxOutDetail Json, ref PageInfo page)
|
{
|
try
|
{
|
string viewName = "View_DeliveryOutDetail";
|
if (Json.OrdnoType == "IN")
|
{
|
viewName = "View_DeliveryInDetail";
|
}
|
|
StringBuilder sqlString = new StringBuilder();
|
sqlString.Append("select * from " + viewName + " where 1=1 " + $" AND DepartGuid='{Json.DepartGuid}' ");
|
if (!string.IsNullOrEmpty(Json.LingNo))
|
{
|
sqlString.Append("and LingNo like '%" + Json.LingNo + "%' ");
|
}
|
if (!string.IsNullOrEmpty(Json.PageNo))
|
{
|
sqlString.Append("and PageNo like '%" + Json.PageNo + "%' ");
|
}
|
if (!string.IsNullOrEmpty(Json.MatNo))
|
{
|
sqlString.Append("and MatNo like '%" + Json.MatNo + "%' ");
|
}
|
if (!string.IsNullOrEmpty(Json.MatName))
|
{
|
sqlString.Append("and MatName like '%" + Json.MatName + "%' ");
|
}
|
if (!string.IsNullOrEmpty(Json.PickerUser))
|
{
|
sqlString.Append("and PickerUser like '%" + Json.PickerUser + "%' ");
|
}
|
if (!string.IsNullOrEmpty(Json.MatType))
|
{
|
sqlString.Append("and MatType = '" + Json.MatType + "' ");
|
}
|
// 时间段
|
if (Json.BeginTime != DateTime.MinValue && Json.BeginTime != null && Json.BeginTime != DateTime.MaxValue)
|
{
|
sqlString.Append("and CreateTime >= '" + Convert.ToDateTime(Json.BeginTime) + "' ");
|
}
|
|
// 合格证判定
|
if (!string.IsNullOrEmpty(Json.Certificate))
|
{
|
if (Json.Certificate == "有")
|
{
|
sqlString.Append("and LEN(isnull(certificate,'')) > 0 ");
|
}
|
else
|
{
|
sqlString.Append("and LEN(isnull(certificate,'')) = 0 ");
|
}
|
}
|
|
if (Json.EndTime != DateTime.MinValue && Json.EndTime != null && Json.EndTime != DateTime.MaxValue)
|
{
|
sqlString.Append("and CreateTime <= '" + Convert.ToDateTime(Json.EndTime).ToShortDateString() + " 23:59:59.999" + "' ");
|
}
|
|
SqlParam[] para = new SqlParam[] { };
|
DataTable dt = DataFactory.SqlDataBase().GetPageList(sqlString.ToString(), para, "CreateTime", "DESC", ref page);
|
IList<DeliveryOutDetail> list = ModelConvertHelper<DeliveryOutDetail>.DataTableToModel(dt);
|
|
return list;
|
}
|
catch
|
{
|
throw new NotImplementedException();
|
}
|
}
|
|
public DeliveryOutDetail GetCertificate(string ordNo, string matNo)
|
{
|
try
|
{
|
StringBuilder sqlString = new StringBuilder();
|
sqlString.Append("select *,HeGeZheng as Certificate from ErpInDetail where ordno='" + ordNo);
|
sqlString.Append("'and MatNo = '" + matNo + "';");
|
DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(sqlString);
|
|
IList<DeliveryOutDetail> list = ModelConvertHelper<DeliveryOutDetail>.DataTableToModel(dt);
|
return list[0];
|
}
|
catch
|
{
|
throw new NotImplementedException();
|
}
|
}
|
|
public bool SetCertificates(DeliveryOutDetail model)
|
{
|
bool bl = false;
|
try
|
{
|
if (String.IsNullOrEmpty(model.MatNo) || string.IsNullOrEmpty(model.OrdNo))
|
{
|
return bl;
|
}
|
|
StringBuilder sqlString = new StringBuilder();
|
sqlString.Append("UPDATE ErpInDetail SET HeGeZheng = '" + model.Certificate + "',");
|
sqlString.Append("Demo='" + model.Demo + "',PalNo='补录合格证' ");
|
sqlString.Append("WHERE OrdNo = '" + model.OrdNo + "' AND MatNo='" + model.MatNo + "';");
|
|
int rowCount = DataFactory.SqlDataBase().ExecuteBySql(sqlString);
|
if (rowCount > 0)
|
{
|
bl = true;
|
}
|
|
return bl;
|
}
|
catch (Exception)
|
{
|
return bl;
|
}
|
}
|
}
|
}
|
