public ChargeRule GetChargeRuleBy(ChargeRule _ChargeRule) { try { if (_ChargeRule == null) { return(_ChargeRule); } return(_IUoW.Repository <ChargeRule>().GetBy(x => x.ChargeRuleId == _ChargeRule.ChargeRuleId && x.AuthStatusId == "A" && x.LastAction != "DEL")); } catch (Exception ex) { throw ex; } }
public int DeleteChargeRule(ChargeRule _ChargeRule) { try { int result = 0; bool IsRecordExist; if (!string.IsNullOrWhiteSpace(_ChargeRule.ChargeRuleId)) { IsRecordExist = _IUoW.Repository <ChargeRule>().IsRecordExist(x => x.ChargeRuleId == _ChargeRule.ChargeRuleId); if (IsRecordExist) { var _oldChargeRule = _IUoW.Repository <ChargeRule>().GetBy(x => x.ChargeRuleId == _ChargeRule.ChargeRuleId); var _oldChargeRuleForLog = ObjectCopier.DeepCopy(_oldChargeRule); _oldChargeRule.AuthStatusId = _ChargeRule.AuthStatusId = "U"; _oldChargeRule.LastAction = _ChargeRule.LastAction = "DEL"; _oldChargeRule.LastUpdateDT = _ChargeRule.LastUpdateDT = System.DateTime.Now; result = _IUoW.Repository <ChargeRule>().Update(_oldChargeRule); #region Auth Log if (result == 1) { _IAuthLogService = new AuthLogService(); long _outMaxSlAuthLogDtl = 0; _IAuthLogService.AddAuthLog(_IUoW, _oldChargeRuleForLog, _ChargeRule, "DEL", "0001", "090102003", 1, "ChargeRule", "MTK_CHG_RULE", "ChargeRuleId", _ChargeRule.ChargeRuleId, "mtaka", _outMaxSlAuthLogDtl, out _outMaxSlAuthLogDtl); } #endregion if (result == 1) { _IUoW.Commit(); } return(result); } //result = _IUoW.Repository<ChargeRule>().Delete(_ChargeRule); return(result); } return(result); } catch (Exception ex) { _ObjErrorLogService = new ErrorLogService(); _ObjErrorLogService.AddErrorLog(ex, string.Empty, "DeleteChargeRule(obj)", string.Empty); return(0); } }
public JsonResult CustomerDetail(string customerID) { if (!string.IsNullOrEmpty(customerID)) { // 客户信息 var customer = new CustomerRule().CustomerDetail(customerID); // 缴费项目信息 List <dynamic> chargeItemList = new ChargeItemRule().SearchChargeItem(customerID); var chargeItem = from chargeItems in chargeItemList select new { Name = chargeItems.NAME, Price = chargeItems.UNITPRICE, Count = chargeItems.COUNT, AgreeMentMoney = chargeItems.AGREEMENTMONEY, ItemCount = 0 }; // 协议信息 var agreements = new AgreementsRule().GetAgreementObjectByCustomerID(customerID); // 子客户信息 var childCustomer = new CustomerRule().GetChildrenCustomer(customerID); // 缴费历史 //int itemCount = 0; var chargeHistory = new ChargeRule().ChargeSearch(customerID); // 欠费记录 var arrearRecord = new YearEndArrearRule().GetArrearRecordByCustomerID(customerID); //chargeHistory, return(Json(new { customer, chargeItem, agreements, childCustomer, arrearRecord, chargeHistory }, JsonRequestBehavior.AllowGet)); } else { return(Json(new Ajax.Model.Customer())); } }
public int AddChargeRule(ChargeRule _ChargeRule) { try { var _max = _IUoW.Repository <ChargeRule>().GetMaxValue(x => x.ChargeRuleId) + 1; _ChargeRule.ChargeRuleId = _max.ToString().PadLeft(4, '0'); _ChargeRule.PointTimeBalFlag = "0"; _ChargeRule.InsuffBalRefId = "1"; _ChargeRule.DeductPrdId = "Y"; _ChargeRule.DeductCondtionFlag = "0"; //_ChargeRule.CustomerFilterAppFlag = "0"; _ChargeRule.StaffAccExcFlag = "0"; _ChargeRule.ChargeAppConFlag = "0"; _ChargeRule.TaxPenaltyRate = 0; _ChargeRule.AuthStatusId = "U"; _ChargeRule.LastAction = "ADD"; _ChargeRule.MakeDT = System.DateTime.Now; var result = _IUoW.Repository <ChargeRule>().Add(_ChargeRule); List <ChargeDeductCust> ListChargeDeductCust = new List <ChargeDeductCust>(); var _maxCus = _IUoW.Repository <ChargeDeductCust>().GetMaxValue(x => x.SL) + 1; for (int i = 0; i < _ChargeRule.ListChargeDeductCust.Length; i++) { ChargeDeductCust _ObjChargeDeductCust = new ChargeDeductCust(); _ObjChargeDeductCust.SL = _maxCus.ToString().PadLeft(6, '0'); _ObjChargeDeductCust.ChargeRuleId = _ChargeRule.ChargeRuleId; _ObjChargeDeductCust.CusCatId = _ChargeRule.ListChargeDeductCust[i].CusCatId; _ObjChargeDeductCust.AuthStatusId = "U"; _ObjChargeDeductCust.LastAction = "ADD"; _ObjChargeDeductCust.MakeBy = "mTaka"; _ObjChargeDeductCust.MakeDT = System.DateTime.Now; ListChargeDeductCust.Add(_ObjChargeDeductCust); _maxCus += 1; } result = _IUoW.Repository <ChargeDeductCust>().AddRange(ListChargeDeductCust); List <ChargeApplyDateTime> ListChargeApplyDateTime = new List <ChargeApplyDateTime>(); var _maxDT = _IUoW.Repository <ChargeApplyDateTime>().GetMaxValue(x => x.SL) + 1; for (int i = 0; i < _ChargeRule.ListChargeApplyDT.Length; i++) { ChargeApplyDateTime _ObjChargeApplyDateTime = new ChargeApplyDateTime(); _ObjChargeApplyDateTime.SL = _maxDT.ToString().PadLeft(6, '0'); _ObjChargeApplyDateTime.ChargeRuleId = _ChargeRule.ChargeRuleId; _ObjChargeApplyDateTime.Saturday = _ChargeRule.ListChargeApplyDT[i].Saturday == "True" ? "1" : "0"; _ObjChargeApplyDateTime.Sunday = _ChargeRule.ListChargeApplyDT[i].Sunday == "True" ? "1" : "0"; _ObjChargeApplyDateTime.Monday = _ChargeRule.ListChargeApplyDT[i].Monday == "True" ? "1" : "0"; _ObjChargeApplyDateTime.Tuesday = _ChargeRule.ListChargeApplyDT[i].Tuesday == "True" ? "1" : "0"; _ObjChargeApplyDateTime.Wednesday = _ChargeRule.ListChargeApplyDT[i].Wednesday == "True" ? "1" : "0"; _ObjChargeApplyDateTime.Thursday = _ChargeRule.ListChargeApplyDT[i].Thursday == "True" ? "1" : "0"; _ObjChargeApplyDateTime.Friday = _ChargeRule.ListChargeApplyDT[i].Friday == "True" ? "1" : "0"; _ObjChargeApplyDateTime.FromHour = _ChargeRule.ListChargeApplyDT[i].FromHour.Split(':')[0].ToString(); _ObjChargeApplyDateTime.FromMinute = _ChargeRule.ListChargeApplyDT[i].FromHour.Split(':')[1].ToString(); _ObjChargeApplyDateTime.ToHour = _ChargeRule.ListChargeApplyDT[i].ToHour.Split(':')[0].ToString(); _ObjChargeApplyDateTime.ToMinute = _ChargeRule.ListChargeApplyDT[i].ToHour.Split(':')[1].ToString(); _ObjChargeApplyDateTime.AuthStatusId = "U"; _ObjChargeApplyDateTime.LastAction = "ADD"; _ObjChargeApplyDateTime.MakeBy = "mTaka"; _ObjChargeApplyDateTime.MakeDT = System.DateTime.Now; ListChargeApplyDateTime.Add(_ObjChargeApplyDateTime); _maxDT += 1; } result = _IUoW.Repository <ChargeApplyDateTime>().AddRange(ListChargeApplyDateTime); #region Auth Log if (result == 1) { _IAuthLogService = new AuthLogService(); long _outMaxSlAuthLogDtl = 0; result = _IAuthLogService.AddAuthLog(_IUoW, null, _ChargeRule, "ADD", "0001", _ChargeRule.FunctionId, 1, "ChargeRule", "MTK_CHG_RULE", "ChargeRuleId", _ChargeRule.ChargeRuleId, "mtaka", _outMaxSlAuthLogDtl, out _outMaxSlAuthLogDtl); if (result == 1 && ListChargeDeductCust != null && ListChargeDeductCust.Count() > 0) { result = _IAuthLogService.AddAuthLog(_IUoW, null, ListChargeDeductCust, "ADD", "0001", _ChargeRule.FunctionId, 0, "ChargeDeductCust", "MTK_CHG_DEDUCT_CUST", "SL", null, "mtaka", _outMaxSlAuthLogDtl, out _outMaxSlAuthLogDtl); } if (result == 1 && ListChargeApplyDateTime != null && ListChargeApplyDateTime.Count() > 0) { result = _IAuthLogService.AddAuthLog(_IUoW, null, ListChargeApplyDateTime, "ADD", "0001", _ChargeRule.FunctionId, 0, "ChargeApplyDateTime", "MTK_CHG_APPLY_DT", "SL", null, "mtaka", _outMaxSlAuthLogDtl, out _outMaxSlAuthLogDtl); } } #endregion if (result == 1) { _IUoW.Commit(); } return(result); } catch (Exception ex) { _ObjErrorLogService = new ErrorLogService(); _ObjErrorLogService.AddErrorLog(ex, string.Empty, "AddChargeRule(obj)", string.Empty); return(0); } }