/// <summary>
/// 物料主数据搜索条件
/// </summary>
/// <returns></returns>
private MatModel MatQueryData()
{
var model = new MatModel()
{
MAT_ID = mat.Text.Trim(),
MAT_SPECI = spec.Text.Trim(),
//MAT_SNCONTROL = snControler.Text,
//MAT_OLD = oldMatNo.Text.Trim(),
//MAT_BATCHMODE = batMode.Text,
//MAT_STATUS = matNoType.Text
};
//if ("启用".Equals(snControler.Text.Trim()))
// model.MAT_SNCONTROL = "X";
//else
// model.MAT_SNCONTROL = "";
//if ("是".Equals(batMode.Text.Trim()))
// model.MAT_BATCHMODE = "X";
//else
// model.MAT_BATCHMODE = "";
//if ("激活".Equals(matNoType.Text.Trim()))
// model.MAT_STATUS = "1";
//else if ("冻结".Equals(matNoType.Text.Trim()))
// model.MAT_STATUS = "0";
//else
// model.MAT_STATUS = "";
return(model);
}
/// <summary>
/// 物料主数据分页查询
/// </summary>
/// <param name="model"></param>
/// <param name="page"></param>
/// <returns></returns>
public ReturnValue <List <tblMaterial> > GetMatInfo(MatModel model, Page page)
{
ReturnValue <List <tblMaterial> > rv = new ReturnValue <List <tblMaterial> >();
var matDao = SqlSugarDB.Instance <tblMaterial>();
List <tblMaterial> matList = matDao.Query()
.WhereIF(!string.IsNullOrEmpty(model.MAT_ID), p => p.MAT_ID.Equals(model.MAT_ID))
.WhereIF(!string.IsNullOrEmpty(model.MAT_SPECI), p => p.MAT_SPECI.Equals(model.MAT_SPECI))
.WhereIF(!string.IsNullOrEmpty(model.MAT_SNCONTROL), p => p.MAT_SNCONTROL.Equals(model.MAT_SNCONTROL))
.WhereIF(!string.IsNullOrEmpty(model.MAT_OLD), p => p.MAT_OLD.Equals(model.MAT_OLD))
.WhereIF(!string.IsNullOrEmpty(model.MAT_BATCHMODE), p => p.MAT_BATCHMODE.Equals(model.MAT_BATCHMODE))
.WhereIF(!string.IsNullOrEmpty(model.MAT_STATUS), p => p.MAT_STATUS == Convert.ToInt32(model.MAT_STATUS))
.OrderBy(p => p.MAT_ID, OrderByType.Asc).ToPageList(page.pageIndex, page.pageSize, ref page.totalCount)
.ToList();
return(rv.Success(matList, ""));
}
