/// <summary>
/// 查询审批物料
/// </summary>
/// <param name="Material_Id">物料编号</param>
/// <param name="Material_Name">物料名称</param>
/// <param name="Order_Proposer">申请人</param>
/// <param name="Order_ApplyTime">申请时间</param>
/// <param name="Order_ApproveTime">审批时间</param>
/// <param name="PageIndex">当前页</param>
/// <param name="PageSize">页大小</param>
/// <param name="Material_Approval">审批类型</param>
/// <returns></returns>
public PageShowMaterial SelApproval(string Material_Id, string Material_Name, string Order_Proposer, DateTime?Order_SubmissionTime, DateTime?Order_ApproveTime, int PageIndex = 1, int PageSize = 2, int Material_Approval = -1)
{
string sql = "select * from MaterialTable m join OrderTable o on o.Order_MId = m.Id join MaterialTypeTable t on m.Material_TypeId = t.Id join ActivityTable a on m.Material_Activity_Id = a.Id join UserTable u on o.Order_User_Id = u.Id join ProductTable p on o.Order_Product_Id = p.Id join DepartmentTable d on o.Order_Department_Id = d.Id join JobTable j on o.Order_Job_Id = j.Id join PlaceTable g on o.Order_Area_Id = g.Id where 1 = 1";
if (Material_Id != null)
{
sql += " and Material_Id like '%" + Material_Id + "%'";
}
if (Material_Name != null)
{
sql += " and Material_Name like '%" + Material_Name + "%'";
}
if (Material_Approval != -1)
{
sql += " and Material_Approval = '" + Material_Approval + "'";
}
if (Order_Proposer != null)
{
sql += " and Order_Proposer like '%" + Order_Proposer + "%'";
}
if (Order_SubmissionTime != null)
{
sql += " and Order_SubmissionTime > '" + Order_SubmissionTime + "'";
}
if (Order_ApproveTime != null)
{
sql += " and Order_ApproveTime < '" + Order_ApproveTime + "'";
}
List <ApprovalMaterial> list = new List <ApprovalMaterial>();
list = conn.Query <ApprovalMaterial>(sql).ToList();
var pagelist = list.Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList();
PageShowMaterial PageShowData = new PageShowMaterial();
PageShowData.PageShowMateriallist2 = pagelist;
PageShowData.DataCount = list.Count();
PageShowData.PageSize = PageSize;
return(PageShowData);
}
/// <summary>
/// 查询订单
/// </summary>
/// <param name="Material_Id">物料编号</param>
/// <param name="Material_Name">物料名称</param>
/// <param name="Order_State">物料状态</param>
/// <param name="Order_Proposer">申请人</param>
/// <param name="Order_ApplyTime">申请时间</param>
/// <param name="PageIndex">当前页</param>
/// <param name="PageSize">页大小</param>
/// <returns></returns>
public PageShowMaterial SelOrder(string Material_Id, string Material_Name, string Order_Proposer, DateTime?Order_ApplyTime, int PageIndex = 1, int PageSize = 2, int Order_State = -1)
{
string sql = "select m.Id,m.Material_Id,m.Material_Name,m.Material_Image,t.MType_Name,o.Order_Proposer,g.Place_Name,o.Order_ApplyTime,o.Order_State,a.Activity_Name,m.Material_Price,m.Material_Number,p.Product_Name,d.Department_Name,j.Job_Name,u.User_Phone from MaterialTable m join OrderTable o on o.Order_MId = m.Id join MaterialTypeTable t on m.Material_TypeId = t.Id join ActivityTable a on m.Material_Activity_Id = a.Id join UserTable u on o.Order_User_Id = u.Id join ProductTable p on o.Order_Product_Id = p.Id join DepartmentTable d on o.Order_Department_Id = d.Id join JobTable j on o.Order_Job_Id = j.Id join PlaceTable g on o.Order_Area_Id = g.Id where 1 = 1";
if (Material_Id != null)
{
sql += " and Material_Id like '%" + Material_Id + "%'";
}
if (Material_Name != null)
{
sql += " and Material_Name like '%" + Material_Name + "%'";
}
if (Order_State != -1)
{
sql += " and Order_State = '" + Order_State + "'";
}
if (Order_Proposer != null)
{
sql += " and Order_Proposer like '%" + Order_Proposer + "%'";
}
if (Order_ApplyTime != null)
{
sql += " and Order_ApplyTime = '" + Order_ApplyTime + "'";
}
List <ShowMaterialApprove> list = new List <ShowMaterialApprove>();
list = conn.Query <ShowMaterialApprove>(sql).ToList();
var pagelist = list.Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList();
PageShowMaterial PageShowData = new PageShowMaterial();
PageShowData.PageShowMateriallist1 = pagelist;
PageShowData.DataCount = list.Count();
PageShowData.PageSize = PageSize;
return(PageShowData);
}
/// <summary>
/// 多条件查询物料信息
/// </summary>
/// <param name="materialid"></param>
/// <param name="materialname"></param>
/// <param name="materialprice"></param>
/// <returns></returns>
public PageShowMaterial SelMaterial(string Materialid, string Materialname, float Materialprice = -1, float Materialprice1 = -1, int PageIndex = 1, int PageSize = 3)
{
string sql = "select m.*,t.MType_Name from MaterialTable m join MaterialTypeTable t on m.Material_TypeId = t.Id where 1=1";
if (Materialid != null)
{
sql += " and Material_Id like '%" + Materialid + "%'";
}
if (Materialname != null)
{
sql += " and Material_Name like '%" + Materialname + "%'";
}
if (Materialprice != -1)
{
sql += " and Material_Price >" + Materialprice;
}
if (Materialprice1 != -1)
{
sql += " and Material_Price <" + Materialprice1;
}
// sql += " and Id between" + (PageIndex - 1) * PageSize + 1 + " and " + PageIndex * PageSize;
List <MaterialTableModel> list = new List <MaterialTableModel>();
list = conn.Query <MaterialTableModel>(sql).ToList();
var pagelist = list.Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList();
PageShowMaterial PageShowData = new PageShowMaterial();
PageShowData.PageShowMateriallist = pagelist;
PageShowData.DataCount = list.Count();
PageShowData.PageSize = PageSize;
return(PageShowData);
}
