| | |
| | | { |
| | | //ds1获取的sql后期记得改回供应商,修改人->供应商 |
| | | var ds1 = oCN.RunProcReturn("select * from h_v_Gy_UserMaterRelationEdit where 物料代码='" + HMaterID + "'" + "and 修改人='" + user + "'", "h_v_Gy_UserMaterRelationEdit"); |
| | | var ds = oCN.RunProcReturn("select * from Gy_Material where HNumber='" + HMaterID+ "'", "Gy_Material"); |
| | | |
| | | var ds = oCN.RunProcReturn("select * from Gy_Material where HNumber='" + HMaterID+ "'"+ " and HUSEORGID="+"'"+ OrganizationID+"'", "Gy_Material"); |
| | | if(ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | return 2; |
| | | } |
| | | if (param == 0) |
| | | { |
| | | if (ds1.Tables[0].Rows.Count > 0) |
| | | if (ds1.Tables[0].Rows.Count > 0)//物料重复,弹出询问 |
| | | { |
| | | return 1; |
| | | |
| | | } |
| | | else |
| | | { |
| | |
| | | msg2 = "[" + msg2.ToString() + "]"; |
| | | |
| | | List<Model.Cls_MaterialHandingModel> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.Cls_MaterialHandingModel>>(msg2); |
| | | |
| | | var ds = oCN.RunProcReturn("select * from Gy_Material where HNumber='" + list[0].HMaterNumber + "'", "Gy_Material"); |
| | | |
| | | |
| | | int HItemID =Convert.ToInt32(list[0].HItemID); |
| | | string HMaterNumber = list[0].HMaterNumber; |
| | | int HMaterID =Convert.ToInt32(ds.Tables[0].Rows[0]["HItemID"]); |
| | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | LogService.Write("送货物料信息保存异常:" + e.Message); |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |