|  |  |  | 
|---|
|  |  |  | objJsonResult.data = null; | 
|---|
|  |  |  | return objJsonResult; | 
|---|
|  |  |  | } | 
|---|
|  |  |  | string sql1 = string.Format(@"select * from h_v_Gy_CustomerList where 组织名称='" + Organization + "'"); | 
|---|
|  |  |  | string sql1 = ""; | 
|---|
|  |  |  | //客户制定 | 
|---|
|  |  |  | string sErr = ""; | 
|---|
|  |  |  | if (oSystemParameter.ShowBill(ref sErr)) | 
|---|
|  |  |  | { | 
|---|
|  |  |  | if (oSystemParameter.omodel.WMS_CampanyName == "乔一") | 
|---|
|  |  |  | { | 
|---|
|  |  |  | sql1 = string.Format(@"select * from h_v_Gy_CustomerList where 1=1"); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | else | 
|---|
|  |  |  | { | 
|---|
|  |  |  | sql1 = string.Format(@"select * from h_v_Gy_CustomerList where 组织名称='" + Organization + "'"); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | } | 
|---|
|  |  |  |  | 
|---|
|  |  |  |  | 
|---|
|  |  |  | if (sWhere == null || sWhere.Equals("")) | 
|---|
|  |  |  | { | 
|---|
|  |  |  | ds = oCN.RunProcReturn(sql1 + sWhere + " order by 客户代码 ", "h_v_Gy_CustomerList"); | 
|---|
|  |  |  | 
|---|
|  |  |  | ",HEmpID,HCreditDate,HCreditRatingDate,HMaxCreditRatingDate" + | 
|---|
|  |  |  | ",HMonthUseQty,HForecastCreditRating,HCreditLevelID,HCountAccrualRating" + | 
|---|
|  |  |  | ",HSubsidyAccrualRating,HCreditRating,HMaxCreditRating" + | 
|---|
|  |  |  | ",HCusTypeID) " + | 
|---|
|  |  |  | ",HCusTypeID,HCREATEORGID,HUSEORGID) " + | 
|---|
|  |  |  | " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID + | 
|---|
|  |  |  | ", " + HLevel + ",0,'" + HStopflag + "','" + HRemark + "'" + | 
|---|
|  |  |  | ",'" + HShortName + "','" + HAddress + "','" + HLinkMan + "','" + HLinkPhone + "','" + HMobilePhone + "'" + | 
|---|
|  |  |  | 
|---|
|  |  |  | "," + HEmpID + "," + HCreditDate + "," + HCreditRatingDate + "," + HMaxCredRatingDate + | 
|---|
|  |  |  | "," + HMonthUseQty + "," + HForecastCreditRating + "," + HCreditLevelID + "," + HCountAccrualRating + | 
|---|
|  |  |  | "," + HSubsidyAccrualRating + "," + HCreditRating + "," + HMaxCreditRating + | 
|---|
|  |  |  | ", " + HCusTypeID + ")"); | 
|---|
|  |  |  | ", " + HCusTypeID + ","+ HCreateOrgID + ","+ HUseOrgID + ")"); | 
|---|
|  |  |  | //修改上级为非末级代码 | 
|---|
|  |  |  | oCN.RunProc("Update Gy_Customer set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); | 
|---|
|  |  |  | oCN.Commit(); | 
|---|