| | |
|---|
| | | #region 物料校验 |
|---|
| | | [Route("MaterialHandingController/CheckMaterial")] |
|---|
| | | [HttpGet] |
|---|
| | | public object CheckMaterial(string HMaterID, string user, int param,string OrganizationID) |
|---|
| | | public object CheckMaterial(string HMaterID, string user, int param,string OrganizationID,string SupID) |
|---|
| | | { |
|---|
| | | try |
|---|
| | | { |
|---|
| | | //ds1获取的sql后期记得改回供应商，修改人->供应商 |
|---|
| | | var ds1 = oCN.RunProcReturn("select * from h_v_Gy_UserMaterRelationEdit where 物料代码='" + HMaterID + "'" + "and 创建人='" + user + "'", "h_v_Gy_UserMaterRelationEdit"); |
|---|
| | | var ds1 = oCN.RunProcReturn("select * from h_v_Gy_UserMaterRelationEdit where 物料代码='" + HMaterID + "'" + "and 供应商代码='" + SupID + "'", "h_v_Gy_UserMaterRelationEdit"); |
|---|
| | | var ds = oCN.RunProcReturn("select * from Gy_Material where HNumber='" + HMaterID+ "'"+ " and HUSEORGID="+"'"+ OrganizationID+"'", "Gy_Material"); |
|---|
| | | if(ds.Tables[0].Rows.Count == 0) |
|---|
| | | { |
|---|
