客户列表、供应商列表

zzr99

2021-08-27 058ccce4c336af1e7c32d0e6f164ed28ed0ac54c

 WebAPI/Controllers/ReportPlatFormController.cs

@@ -70,17 +70,17 @@

            try
            {
                ds = oCN.RunProcReturn("select * from Gy_SourceRelationSet where HSourceID='" + HSourceID + "'", "Gy_SourceRelationSet");
                if (ds.Tables[0].Rows.Count > 0)
                {
                //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();
                //    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) 
                                           values('" + HSourceID + "','" + HUserName + "','" + HGroupID + "','" + HManagerID + "','" + HRemark + "','" + DateTime.Parse(HCreateDate).ToShortDateString() + "','" + HUserName + "','0','')");