| | |
| | | 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); |
| | |
| | | { |
| | | try |
| | | { |
| | | string s = ""; |
| | | |
| | | //查看权限 |
| | | if (!DBUtility.ClsPub.Security_Log("Xs_SeOrderBill_Drop", 1, false, user)) |
| | | { |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | if (BillOld.ShowBill(long.Parse(HInterID), ref s) == false) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "此单据有误!"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | //判断是否可编辑 |
| | | if (BillOld.omodel.HChecker != "" && BillOld.omodel.HChecker != null) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "此单据已经被审核,不允许删除!"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | |
| | | oCN.BeginTran(); |
| | | |
| | |
| | | //进行需要进行的审核/反审核操作 |
| | | 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"); |
| | | |