public List <WMS_Models.CoLinModel.PutStorageModel> RkSearchs(string name, string jlid, string sid, string punum, string puname)
{
WMS_Models.CoLinModel.PutStorageModel m = new WMS_Models.CoLinModel.PutStorageModel {
PuName = name, JlName = jlid, SName = sid, PuAuditNum = punum, PuSupplierName = puname
};
return(bll.Searchs(m));
}
public List <WMS_Models.CoLinModel.PutStorageModel> RkSearch(string name, string jlid, string sid)
{
WMS_Models.CoLinModel.PutStorageModel m = new WMS_Models.CoLinModel.PutStorageModel {
PuName = name, JlName = jlid, SName = sid
};
return(bll.Search(m));
}
//入库高级查询
public List <WMS_Models.CoLinModel.PutStorageModel> Searchs(WMS_Models.CoLinModel.PutStorageModel m)
{
string sql = "select put.puid,put.puname,pro.prname,pro.PrNumber,put.PuBatch,spe.spname,put.puNumber,jli.StName,rul.jlname,put.PuSupplierName,put.PuPrepared,sta.SName,put.PuAudit,put.PuAuditTime from PutStorage put join ProductsTB pro on put.Prid = pro.prid join Specification spe on put.spid = spe.spid join Rulibrary rul on put.jlid = rul.jlid join State sta on put.Sid = sta.Sid join jlibrary jli on put.Stid = jli.Stid where 1=1 ";
if (!string.IsNullOrEmpty(m.PuName))
{
sql += $" and PuName= @PuName ";
}
if (!string.IsNullOrEmpty(m.Jlid))
{
sql += $" and Jlid =@Jlid ";
}
if (!string.IsNullOrEmpty(m.Sid))
{
sql += $" and Sid= @Sid ";
}
if (!string.IsNullOrEmpty(m.PuAuditNum))
{
sql += $" and PuAuditNum=@PuAuditNum ";
}
if (!string.IsNullOrEmpty(m.PuSupplierName))
{
sql += $" PuSupplierName=@PuSupplierName ";
}
// string sql = "select * from PutStorage where PuName= @PuName and Jlid =@Jlid and Sid= @Sid and PuAuditNum=@PuAuditNum and PuSupplierName=PuSupplierName";
return(dal.Search <WMS_Models.CoLinModel.PutStorageModel, WMS_Models.CoLinModel.PutStorageModel>(sql, m));
}
public int Delete(WMS_Models.CoLinModel.PutStorageModel m)
{
return(bll.Delete <WMS_Models.CoLinModel.PutStorageModel>(m));
}
public int RKFSUpdate(WMS_Models.CoLinModel.PutStorageModel m)
{
return(bll.Update(m));
}
public int UpdateZT(WMS_Models.CoLinModel.PutStorageModel id)
{
return(bll.UpdateZT(id));
}
public int RKUpdate(WMS_Models.CoLinModel.PutStorageModel id)
{
return(bll.Updates(id));
}
