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)); }