1

沈泽

2021-09-27 abd9a9d9ccdff4b77d23c88edb39c0284f365c7f

 WebAPI/Controllers/BaseSet/Gy_SupplierController.cs

@@ -31,12 +31,12 @@
            {
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_Gy_SupplierList " + sWhere, "h_v_Gy_SupplierList");
                    ds = oCN.RunProcReturn("select * from h_v_Gy_SupplierList " + sWhere + " order by HItemID desc", "h_v_Gy_SupplierList");
                }
                else
                {
                    string sql1 = "select * from h_v_Gy_SupplierList where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    string sql = sql1 + sWhere + " order by HItemID desc";
                    ds = oCN.RunProcReturn(sql, "h_v_Gy_SupplierList");
                }
                if (ds == null || ds.Tables[0].Rows.Count == 0)
@@ -109,7 +109,16 @@
        {
            try
            {
                ds = oCN.RunProcReturn("select * from Gy_Supplier where HItemID=" + HInterID, "Gy_Supplier");
                string sql = string.Format(@"select  s.HItemID,s.HNumber 编码,s.HName 名称,s.HHelpCode  助记码,s.HShortName 简称,s.HAddress 地址,s.HLinkMan 联系人,s.HLinkPhone 联系电话
                                            ,s.HMobilePhone 手机,s.HFax 传真,s.HPostalCode 邮编,s.HEmail 电子邮件,s.HCorMan 法人代表,s.HBank 开户银行,s.HBankAccount 银行账号,
                                           s.HTaxNum 税务登记号,s.HEnglishName 英文名称,s.HEngLishAddress 英文地址,s.HCountry 国家,s.HStopflag 禁用标志
                                           ,s.HRemark 备注,s.HAreaID 地区ID,a.HName 地区名称,s.HTaxRate 增值税率,s.HCurID 默认货币ID,r.HName 默认货币,
                                           s.HSSID 结算方式ID,e.HName 结算方式 from Gy_Supplier s
                                           left join Gy_AreaSet a on s.HAreaID=a.HItemID
                                           left join Gy_Currency r on s.HCurID=r.HItemID 
                                           left  join Gy_SettleStyle e on s.HSSID=e.HItemID
                                           where s.HItemID='" + HInterID + "'");
                ds = oCN.RunProcReturn(sql, "Gy_Supplier");

                objJsonResult.code = "1";
                objJsonResult.count = 1;
@@ -151,13 +160,14 @@

                List<Supplier> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Supplier>>(msg1);

                long HItemID = list[0].HItemID;
                long HItemID = list[0].HInterID;
                string HNumber = list[0].HNumber;
                string HShortNumber = list[0].HShortNumber;
                string HName = list[0].HName;
                long HParentID = list[0].HParentID;
                long HLevel = list[0].HLevel;
                string HEndFlag = list[0].HEnfFlag;
                string HStopflag = list[0].HStopflag;
                string HHelpCode = list[0].HHelpCode;
                string HShortName = list[0].HShortName;
                string HAddress = list[0].HAddress;
@@ -208,7 +218,7 @@
                    ",HTaxNum,HTaxRate,HCountry,HCorMan,HEnglishName" +
                    ",HEnglishAddress,HCurID,HSSID,HAreaID) " +
                " values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "','" + HParentID + "'" +
                "," + HLevel + ",'0','0','" + HRemark + "'" +
                "," + HLevel + ",0,'" + HStopflag + "','" + HRemark + "'" +
                ",'" + HShortName + "','" + HAddress + "','" + HLinkMan + "','" + HLinkPhone + "','" + HMobilePhone + "'" +
                ",'" + HFax + "','" + HPostalCode + "','" + HEmail + "','" + HBank + "','" + HBankAccount + "'" +
                ",'" + HTaxNum + "','" + HTaxRate + "','" + HCountry + "','" + HCorMan + "','" + HEnglishName + "'" +
@@ -253,21 +263,22 @@
                var _value = oMain["oMain"].ToString();
                string msg1 = _value.ToString();
                string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
                string msg2 = sArray[0].ToString();
                string msg3 = sArray[1].ToString();
                string msg4 = sArray[2].ToString();
                string msg5 = sArray[3].ToString();
                string msg2 = sArray[0].ToString();   //表头数据
                string msg3 = sArray[1].ToString();   //列表主ID
                string msg4 = sArray[2].ToString();   //登录人员
                string msg5 = sArray[3].ToString();   //权限模块代码
                //反序列化
                msg2 = "[" + msg2.ToString() + "]";
                List<Supplier> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Supplier>>(msg2);

                long HItemID = list[0].HItemID;
                long HItemID = list[0].HInterID;
                string HNumber = list[0].HNumber;
                string HShortNumber = list[0].HShortNumber;
                string HName = list[0].HName;
                long HParentID = list[0].HParentID;
                long HLevel = list[0].HLevel;
                string HEndFlag = list[0].HEnfFlag;
                string HStopflag = list[0].HStopflag;
                string HHelpCode = list[0].HHelpCode;
                string HShortName = list[0].HShortName;
                string HAddress = list[0].HAddress;
@@ -316,25 +327,39 @@
                    return objJsonResult;
                }

                if (oDept.HavSameNumber(HItemID, HNumber))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "代码重复！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }


                //若MAINDI重复则重新获取
                oCN.BeginTran();
                //主表
                oCN.RunProc("Update Gy_Supplier set " +
                    " HNumber='" + HNumber + "'" +
                    ",HName='" + HName + "'" +
                    ",HShortNumber='" + HShortNumber + "'" +
                    ",HParentID=" + HParentID +
                    ",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
                   " HNumber='" + HNumber + "'" +
                   ",HName='" + HName + "'" +
                   ",HShortNumber='" + HShortNumber + "'" +
                   ",HParentID=" + HParentID.ToString() +
                   ",HLevel=" + HLevel.ToString() +
                   ",HStopflag ='" + HStopflag + "'" +
                   ",HRemark= '" + HRemark + "'" +
                   ",HHelpCode='" + HHelpCode + "'" +
                   ",HShortName='" + HShortName + "'" +
                   ",HAddress='" + HAddress + "'" +
                   ",HLinkMan='" + HLinkMan + "'" +
                   ",HLinkPhone='" + HLinkPhone + "'" +
                   ",HMobilePhone='" + HMobilePhone + "'" +
                   ",HFax='" + HFax + "'" +
                   ",HPostalCode='" + HPostalCode + "'" +
                   ",HEmail='" + HEmail + "'" +
                   ",HBank='" + HBank + "'" +
                   ",HBankAccount='" + HBankAccount + "'" +
                   ",HTaxNum='" + HTaxNum + "'" +
                   ",HTaxRate=" + HTaxRate.ToString() +
                   ",HCountry='" + HCountry + "'" +
                   ",HCorMan='" +HCorMan + "'" +
                   ",HEnglishName='" + HEnglishName + "'" +
                   ",HEnglishAddress='" + HEnglishAddress + "'" +
                   ",HCurID=" + HCurID.ToString() +
                   ",HSSID=" + HSSID.ToString() +
                   ",HAreaID=" + HAreaID.ToString() + "Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);


                //修改子项目代码
                //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_Department,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo);
                //将上级 为非末级