public List <WMS_Models.CoLinModel.GoStorageModel> CKSearchs(string name, string jlid, string sid, string punum, string puname)
{
WMS_Models.CoLinModel.GoStorageModel m = new WMS_Models.CoLinModel.GoStorageModel {
GoName = name, GlName = jlid, SName = sid, GoAuditNum = punum, GoSupplierName = puname
};
return(bll.Searchs(m));
}
//出库高级查询
public List <WMS_Models.CoLinModel.GoStorageModel> Searchs(WMS_Models.CoLinModel.GoStorageModel m)
{
string sql = "select put.goid,put.goname,pro.prname,pro.PrNumber,put.goBatch,spe.spname,put.goNumber,jli.StName, rul.GlName,put.GoSupplierName,put.GoPrepared,sta.SName, put.GoAudit,put.GoAuditTime from GoStorage put join ProductsTB pro on put.Prid = pro.prid join Specification spe on put.spid = spe.spid join GLibrary rul on put.Glid = rul.Glid join State sta on put.Sid = sta.Sid join jlibrary jli on put.Stid = jli.Stid where 1=1 ";
if (!string.IsNullOrEmpty(m.GoName))
{
sql += $" and PuName= @GoName ";
}
if (!string.IsNullOrEmpty(m.Glid))
{
sql += $" and Jlid =@Jlid ";
}
if (!string.IsNullOrEmpty(m.Sid))
{
sql += $" and Sid= @Sid ";
}
if (!string.IsNullOrEmpty(m.GoAuditNum))
{
sql += $" and PuAuditNum=@GoAuditNum ";
}
if (!string.IsNullOrEmpty(m.GoSupplierName))
{
sql += $" PuSupplierName=@GoSupplierName ";
}
// 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.GoStorageModel, WMS_Models.CoLinModel.GoStorageModel>(sql, m));
}
public List <WMS_Models.CoLinModel.GoStorageModel> CKSearch(string name, string jlid, string sid)
{
WMS_Models.CoLinModel.GoStorageModel m = new WMS_Models.CoLinModel.GoStorageModel {
GoName = name, GlName = jlid, SName = sid
};
return(bll.Search(m));
}
public int ChuKuUpdate(WMS_Models.CoLinModel.GoStorageModel id)
{
id.GoAuditTime = DateTime.Now;
id.GoPreparedTime = DateTime.Now;
return(bll.Update(id));
}
public int UpdateZT(WMS_Models.CoLinModel.GoStorageModel id)
{
return(bll.UpdateZT(id));
}
public int CKUpdate(WMS_Models.CoLinModel.GoStorageModel id)
{
return(bll.Updates(id));
}
//修改状态
public int UpdateZT(WMS_Models.CoLinModel.GoStorageModel m)
{
string sql = "update GoStorage set Sid='" + m.Sid + "' where Goid ='" + m.Goid + "'";
return(dal.Updates(sql));
}
//修改
public int Updates(WMS_Models.CoLinModel.GoStorageModel m)
{
string sql = "update PutStorage set Glid ='" + m.Glid + "',GoRelevance='" + m.GoRelevance + "',GoAuditNum = '" + m.GoAuditNum + "',GoSupplierName='" + m.GoSupplierName + "',GoAuditPeople='" + m.GoAuditPeople + "', GoAuditPhone='" + m.GoAuditPhone + "', GoPrepared='" + m.GoPrepared + "', GoAddres='" + m.GoAddres + "' where Goid ='" + m.Goid + "'";
return(dal.Updates(sql));
}