| | |
|---|
| | | /// <returns></returns> |
|---|
| | | public List<MaterialsDto> GetMateList(string skuNo, string skuName, string auditStatusNo, string type, string isControlled, string isInspect, string environment, string categoryNo) |
|---|
| | | { |
|---|
| | | string str = "select mate.*,user1.RealName CreateUserName,pack.PackagName PackagName,unit.UnitName UnitName,matec.CategoryName from SysMaterials mate left join SysUserInfor user1 on mate.CreateUser = user1.Id left join SysPackag pack on mate.PackagNo = pack.PackagNo left join SysUnit unit on mate.UnitNo = unit.UnitNo left join SysMaterialCategory matec on mate.CategoryNo = matec.CategoryNo where mate.IsDel = @isdel"; |
|---|
| | | string str = "select mate.*,user1.RealName CreateUserName,pack.PackagName PackagName,unit.UnitName UnitName,matec.CategoryName from SysMaterials mate left join SysUserInfor user1 on mate.CreateUser = user1.Id left join SysPackag pack on mate.PackagNo = pack.PackagNo left join SysUnit unit on mate.UnitNo = unit.UnitNo left join SysMaterialCategory matec on mate.CategoryNo = matec.CategoryNo where mate.IsDel = @isdel and pack.IsDel = @isdel"; |
|---|
| | | //判断物料编码 |
|---|
| | | if (!string.IsNullOrEmpty(skuNo)) |
|---|
| | | { |
|---|
| | |
|---|
| | | /// <returns></returns> |
|---|
| | | public List<SysMaterials> GetMateByNo(string SkuNo) |
|---|
| | | { |
|---|
| | | string str = "select * from SysMaterials where SkuNo = @skuno"; |
|---|
| | | string str = "select * from SysMaterials where SkuNo = @skuno and isdel = '0'"; |
|---|
| | | List<SysMaterials> mate = Db.Ado.SqlQuery<SysMaterials>(str, new |
|---|
| | | { |
|---|
| | | skuno = SkuNo //物料编号 |
|---|
