智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
zzr99
2021-10-08 c058d5c799e122ed77da81dfe37bf877300b9b5d 
 WebAPI/Controllers/ReportPlatFormController.cs


@@ -70,28 +70,31 @@




            try


            {


                //ds = oCN.RunProcReturn("select * from Gy_SourceRelationSet where HSourceID='" + HSourceID + "'", "Gy_SourceRelationSet");


                //if (ds.Tables[0].Rows.Count > 0)


                //{




                //    objJsonResult.code = "0";


                //    objJsonResult.count = 0;


                //    objJsonResult.Message = "生产资源已存在！";


                //    objJsonResult.data = null;


                //    return objJsonResult;


                //}


                oCN.BeginTran();


                //写入产线绑定


                string sql = string.Format(@"insert into Gy_SourceRelationSet (HSourceID,HUserName,HGroupID,HManagerID,HRemark,HCreateDate,HCreator,HNowFlag,HCheckManID) 


                ds = oCN.RunProcReturn("select * from Gy_SourceRelationSet where HSourceID='" + HSourceID + "' and HUserName='" + HUserName + "'", "Gy_SourceRelationSet");


              


                if (ds.Tables[0].Rows.Count > 0)


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "当前人员创建此生产资源,不允许重复创建！";


                    objJsonResult.data = null;


                    


                }


                else


                {


                    oCN.BeginTran();


                    //写入产线绑定


                    string sql = string.Format(@"insert into Gy_SourceRelationSet (HSourceID,HUserName,HGroupID,HManagerID,HRemark,HCreateDate,HCreator,HNowFlag,HCheckManID) 


                                           values('" + HSourceID + "','" + HUserName + "','" + HGroupID + "','" + HManagerID + "','" + HRemark + "','" + DateTime.Parse(HCreateDate).ToShortDateString() + "','" + HUserName + "','0','')");


                oCN.RunProc(sql);


                oCN.Commit();


                    oCN.RunProc(sql);


                    oCN.Commit();






                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "保存成功！";


                objJsonResult.data = null;


                    objJsonResult.code = "1";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "保存成功！";


                    objJsonResult.data = null;


                }


            }


            catch (Exception e)


            {