| | |
| | | UserName = oItem.HMaker; //制单人 |
| | | oItem.HBillType = "1401"; |
| | | oItem.HBillSubType = "1401"; |
| | | oItem.HSALEORGID = oItem.HOrgID; |
| | | |
| | | oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); |
| | | oItem.HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month); |
| | |
| | | //进行需要进行的审核/反审核操作 |
| | | if (IsAudit == 0) //审核提交 |
| | | { |
| | | ds = oCN.RunProcReturn("exec h_p_Kf_CheckSeOrderBill_CrediControl " + oBill.omodel.HInterID, "h_p_Kf_CheckSeOrderBill_CrediControl"); |
| | | if(ds.Tables[0].Rows[0]["HBack"].ToString() == "1") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | //审核提交 |
| | | if (oBill.CheckBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) |
| | | { |
| | |
| | | ,cur.HName HCurName |
| | | ,cur.HExchangeRate HExRate |
| | | ,c.HTaxRate |
| | | ,c.HLinkMan |
| | | ,c.HLinkPhone |
| | | ,c.HMobilePhone |
| | | ,ISNULL(cre.HCreditRating_Now,0) HCreditRating_Now |
| | | from Gy_Customer as c |
| | | left join Gy_SettleStyle as s on c.HSSID = s.HItemID |
| | | left join Gy_Currency as cur on c.HCurID = cur.HItemID |
| | | left join Gy_Customer_Credit as cre on c.HItemID = cre.HCusID |
| | | where c.HItemID = " + HCusID; |
| | | ds = oCN.RunProcReturn(sql,"Gy_Customer"); |
| | | |