public List <WMS_Models.CoLinModel.CheckStorageModel> PDSearch(string name, DateTime jlid, string sid)
{
WMS_Models.CoLinModel.CheckStorageModel m = new WMS_Models.CoLinModel.CheckStorageModel {
ChName = name, ChPreparedTime = jlid, SName = sid
};
return(bll.Search(m));
}
//盘点查询
public List <WMS_Models.CoLinModel.CheckStorageModel> Search(WMS_Models.CoLinModel.CheckStorageModel m)
{
string sql = "select put.Chid,put.ChName,sta.sname,rul.ClName, put.ChRelevance,put.chPrepared, put.ChPreparedTime from CheckStorage put join Clibrary rul on put.Clid = rul.Clid join State sta on put.Sid = sta.Sid where 1=1 ";
if (!string.IsNullOrEmpty(m.ChName))
{
sql += $" and ChName= @ChName ";
}
if (!string.IsNullOrEmpty(m.ClName))
{
sql += $" and ClName =@ClName ";
}
if (!string.IsNullOrEmpty(m.SName))
{
sql += $" and SName= @SName ";
}
//string sql = "select * from PutStorage where PuName= @PuName and Jlid =@Jlid and Sid= @Sid ";
return(dal.Search <WMS_Models.CoLinModel.CheckStorageModel, WMS_Models.CoLinModel.CheckStorageModel>(sql, m));
}
//修改状态
public int UpdateZT(WMS_Models.CoLinModel.CheckStorageModel m)
{
string sql = "update CheckStorage set Sid='" + m.Sid + "' where Chid ='" + m.Chid + "'";
return(dal.Updates(sql));
}
//修改
public int Updates(WMS_Models.CoLinModel.CheckStorageModel m)
{
string sql = "update CheckStorage set Clid='" + m.Clid + "',ChRelevance ='" + m.ChRelevance + "',Sid='" + m.Sid + "',ChPrepared = '" + m.ChPrepared + "',ChTake='" + m.ChTake + "', ChProfit='" + m.ChProfit + "', ChAddres='" + m.ChAddres + "' where Chid ='" + m.Chid + "'";
return(dal.Updates(sql));
}
public int UpdateZT(WMS_Models.CoLinModel.CheckStorageModel id)
{
return(bll.UpdateZT(id));
}
