yusijie
2025-09-10 951ef0297938e31101147174ee82c84316ebab96
WebAPI/Controllers/MaterialHandingController.cs
@@ -263,13 +263,17 @@
            {
                //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
                    {
@@ -365,8 +369,9 @@
                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"]);
@@ -426,6 +431,7 @@
            }
            catch (Exception e)
            {
                LogService.Write("送货物料信息保存异常:" + e.Message);
                oCN.RollBack();
                objJsonResult.code = "0";
                objJsonResult.count = 0;