/// <summary> /// 根据条件,获取T_FB_REPAYAPPLYDETAIL信息 /// </summary> /// <param name="strVacName"></param> /// <param name="strVacYear"></param> /// <param name="strCountyType"></param> /// <param name="strSortKey"></param> /// <returns></returns> public static IQueryable <T_FB_REPAYAPPLYDETAIL> GetAllRepayApplyDetailRdListByMultSearch(string strFilter, List <object> objArgs, string strSortKey) { RepayApplyDetailDAL dalRepayApplyDetail = new RepayApplyDetailDAL(); string strOrderBy = string.Empty; if (!string.IsNullOrEmpty(strSortKey)) { strOrderBy = strSortKey; } else { strOrderBy = " REPAYAPPLYDETAILID "; } try { var q = dalRepayApplyDetail.GetRepayApplyDetailRdListByMultSearch(strOrderBy, strFilter, objArgs.ToArray()); return(q); } catch (Exception ex) { string ErrInfo = new RepayApplyDetailBLL().GetType().ToString() + ":GetAllRepayApplyDetailRdListByMultSearch," + System.DateTime.Now.ToString() + "," + ex.Message; Tracer.Debug(ErrInfo); } return(null); }
/// <summary> /// 一起删除还款主表和明细表 add by zl /// </summary> /// <param name="repayMasterID"></param> /// <returns></returns> public bool DelRepayApplyMasterAndDetail(string repayMasterID) { try { RepayApplyDetailBLL repayDetailBll = new RepayApplyDetailBLL(); dal.BeginTransaction(); if (!repayDetailBll.DelRepayApplyDetail(repayMasterID)) { dal.RollbackTransaction(); return(false); } if (!DelRepayApplyMaster(repayMasterID)) { dal.RollbackTransaction(); return(false); } dal.CommitTransaction(); return(true); } catch (Exception ex) { string ErrInfo = this.GetType().ToString() + ":DelRepayApplyMasterAndDetail," + System.DateTime.Now.ToString() + "," + ex.Message; Tracer.Debug(ErrInfo); dal.RollbackTransaction(); return(false); } }
public int GetRepayApplyForMobile(string Repayid, string StrCheckState) { string sResult = string.Empty; T_FB_REPAYAPPLYMASTER master = new T_FB_REPAYAPPLYMASTER(); master = GetRepayApplyMasterByID(Repayid); master.CHECKSTATES = Convert.ToInt32(StrCheckState); RepayApplyDetailBLL bllRepayApplyDetail = new RepayApplyDetailBLL(); List <T_FB_REPAYAPPLYDETAIL> entRds = bllRepayApplyDetail.GetRepayApplyDetailByMasterID(Repayid); if (entRds != null) { //if (UptRepayApplyCheckState(master, entRds.ToList())) //{ // return 1; //} sResult = UptRepayApplyCheckState(master, entRds.ToList()); if (!string.IsNullOrEmpty(sResult)) { throw new Exception(sResult); } else { return(1); } } return(0); }
/// <summary> /// 修改还款申请记录 /// </summary> /// <param name="strActionType"></param> /// <param name="entity"></param> /// <param name="detailList"></param> /// <param name="strMsg"></param> public void UptRepayApplyMasterAndDetailForMobile(string strActionType, T_FB_REPAYAPPLYMASTER entity, List <T_FB_REPAYAPPLYDETAIL> detailList, ref string strMsg) { try { bool isReturn = CheckRepay(ref entity, ref detailList, ref strMsg, "2"); if (!isReturn) { return; } } catch { } bool re = false; if (LockOrder(entity.REPAYAPPLYMASTERID)) { strMsg = "单据正在提交或审核中,不可重复操作!"; return; } try { FBAEnums.CheckStates dOldChecksates = FBAEnums.CheckStates.UnSubmit; T_FB_REPAYAPPLYMASTER cha = GetRepayApplyMasterByID(entity.REPAYAPPLYMASTERID); if (cha == null) { strMsg = "提交的单据不存在或已删除,不可继续操作!"; return; } object checkStatesOld = cha.CHECKSTATES; dOldChecksates = (FBAEnums.CheckStates) int.Parse(checkStatesOld.ToString()); object checkStatesNew = entity.CHECKSTATES; FBAEnums.CheckStates dNewCheckStates = (FBAEnums.CheckStates) int.Parse(checkStatesNew.ToString()); if ((dOldChecksates == FBAEnums.CheckStates.Approved || dOldChecksates == FBAEnums.CheckStates.UnApproved) && strActionType.ToUpper() != "RESUBMIT") { strMsg = "单据已审核完毕,不可再次操作"; return; } Utility.CloneEntity(entity, cha); cha.UPDATEDATE = DateTime.Now; bool n = Update(cha); if (n == false) { dal.RollbackTransaction(); strMsg = "单据更新异常!"; return; } RepayApplyDetailBLL bllRepayDetail = new RepayApplyDetailBLL(); re = bllRepayDetail.UpdateRepayApplyDetail(cha.REPAYAPPLYMASTERID, detailList);//删除报销明细 if (!re) { dal.RollbackTransaction(); strMsg = "单据明细更新异常!"; return; } if (dOldChecksates == dNewCheckStates && dOldChecksates == (int)FBAEnums.CheckStates.UnSubmit && strActionType.ToUpper() == "EDIT") { strMsg = "单据更新成功!"; return; } } catch (Exception ex) { string ErrInfo = this.GetType().ToString() + ":UptRepayApplyMasterAndDetailForMobile," + System.DateTime.Now.ToString() + "," + ex.Message; Tracer.Debug(ErrInfo); } finally { ReleaseOrder(entity.REPAYAPPLYMASTERID); } }
/// <summary> /// 更新还款主从表数据 add by zl /// </summary> /// <param name="entity"></param> /// <param name="detailList"></param> /// <returns></returns> public void UptRepayApplyMasterAndDetail(string strActionType, T_FB_REPAYAPPLYMASTER entity, List <T_FB_REPAYAPPLYDETAIL> detailList, ref string strMsg) { try { var company = OrgClient.GetCompanyById(entity.OWNERCOMPANYID); if (company != null) { entity.OWNERCOMPANYNAME = company.CNAME; } } catch { } bool re = false; if (LockOrder(entity.REPAYAPPLYMASTERID)) { strMsg = "单据正在提交或审核中,不可重复操作!"; return; } try { FBAEnums.CheckStates dOldChecksates = FBAEnums.CheckStates.UnSubmit; T_FB_REPAYAPPLYMASTER cha = GetRepayApplyMasterByID(entity.REPAYAPPLYMASTERID); if (cha == null) { strMsg = "提交的单据不存在或已删除,不可继续操作!"; return; } object checkStatesOld = cha.CHECKSTATES; dOldChecksates = (FBAEnums.CheckStates) int.Parse(checkStatesOld.ToString()); object checkStatesNew = entity.CHECKSTATES; FBAEnums.CheckStates dNewCheckStates = (FBAEnums.CheckStates) int.Parse(checkStatesNew.ToString()); if ((dOldChecksates == FBAEnums.CheckStates.Approved || dOldChecksates == FBAEnums.CheckStates.UnApproved) && strActionType.ToUpper() != "RESUBMIT") { strMsg = "单据已审核完毕,不可再次操作"; return; } //不用月结可以进行借还款 //#region 是否本月有结算 //bool isChecked = SystemSettingsBLL.IsChecked; //// 没月结,只能处理报销。 //string entityType = entity.GetType().Name; //string[] EntityTypes = new string[] { typeof(T_FB_BORROWAPPLYMASTER).Name, // typeof(T_FB_REPAYAPPLYMASTER).Name, typeof(T_FB_CHARGEAPPLYMASTER).Name}; //// 月结不可操作:1.日常报销类型的单据的审核或提交,2.所有单据的提交或重新提交 //if (!isChecked && (EntityTypes.Contains(entityType) || (strActionType.ToUpper() == "SUBMIT") // || (strActionType.ToUpper() == "RESUBMIT"))) //{ // strMsg = "本月尚未结算,无法提交或审核!"; // return; //} //#endregion Utility.CloneEntity(entity, cha); cha.UPDATEDATE = DateTime.Now; bool n = Update(cha); if (n == false) { dal.RollbackTransaction(); strMsg = "单据更新异常!"; return; } RepayApplyDetailBLL bllRepayDetail = new RepayApplyDetailBLL(); re = bllRepayDetail.UpdateRepayApplyDetail(cha.REPAYAPPLYMASTERID, detailList);//删除报销明细 if (!re) { dal.RollbackTransaction(); strMsg = "单据明细更新异常!"; return; } if (dOldChecksates == dNewCheckStates && dOldChecksates == (int)FBAEnums.CheckStates.UnSubmit && strActionType.ToUpper() == "EDIT") { strMsg = "单据更新成功!"; return; } //if (dNewCheckStates == FBAEnums.CheckStates.Approving && ((strActionType.ToUpper() == "SUBMIT" && dOldChecksates == FBAEnums.CheckStates.UnSubmit) // || (strActionType.ToUpper() == "RESUBMIT" && dOldChecksates == FBAEnums.CheckStates.UnApproved))) //{ // BudgetAccountBLL budgetBLL = new BudgetAccountBLL(); // budgetBLL.UpdateAccount(cha, (int)dNewCheckStates); //} } catch (Exception ex) { string ErrInfo = this.GetType().ToString() + ":UptRepayApplyMasterAndDetail," + System.DateTime.Now.ToString() + "," + ex.Message; Tracer.Debug(ErrInfo); } finally { ReleaseOrder(entity.REPAYAPPLYMASTERID); } }