/// <summary> /// 增加一条数据 /// </summary> public void Add(Agreements model) { using (DBHelper db = DBHelper.Create()) { db.Insert<Agreements>(model); } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(Ajax.Model.Agreements model) { if (!dal.Exists(model.ID, model.CustomerID)) { dal.Add(model); } else { throw new Exception("协议编号已经存在或用户已有协议!"); } }
public ActionResult AddAgree(Agreements agree) { AjaxResult result = new AjaxResult(); try { agree.CheckTime = DateTime.MaxValue; agree.ID = WebHelper.GetNewGuidUpper(); agree.CheckOperatorID = MyTicket.CurrentTicket.UserID; agree.CreateTime = DateTime.Now; new AgreementsRule().Add(agree); result.Success = true; result.Message = "协议添加成功"; } catch (Exception ex) { result.Success = false; result.Message = "协议添加失败:" + ex.Message; } return Json(result, JsonRequestBehavior.AllowGet); }
public ActionResult SearchAgree(EasyUIGridParamModel param, Agreements agree, Ajax.Model.Customer c) { int itemCount = 0; List<dynamic> agreeList = new AgreementsRule().SearchAgree(param, agree, c, out itemCount); var showList = from a in agreeList select new { ID = a.ID, CONTRASTID = a.ID, CUSTOMERID = a.CUSTOMERID, CODE = a.CODE, NAME = a.NAME, MONEY = a.MONEY, BEGINDATE = a.BEGINDATE, AGREEMENTCODE = a.AGREEMENTCODE, ENDDATE = TimeParser.FormatDateTime(a.ENDDATE), STATUS = Convert.ToString(a.STATUS).Replace("0", "未审核").Replace("1", "已审核").Replace("2", "已删除") }; return Json(new { total = itemCount, rows = showList }, JsonRequestBehavior.AllowGet); }
public ActionResult ModifyAgree(Agreements a) { AjaxResult result = new AjaxResult(); try { result.Success = new AgreementsRule().Update(a); result.Message = "协议修改成功。"; } catch { result.Success = false; result.Message = "协议修改失败。"; } return Json(result, JsonRequestBehavior.AllowGet); }
/// <summary> /// 按协议缴费 /// </summary> /// <param name="charge">缴费主表</param> /// <param name="agreement">协议信息</param> /// <returns></returns> public string ChargeByAgreement(Charge charge, Agreements agreement) { using (DBHelper db = DBHelper.Create()) { db.BeginTransaction(); decimal agreementMoney = agreement.Money; #region 更新协议缴费状态 string sql = "select sum(money) from charge where AgreementID = @AgreementID and (status = 1 or status = 0)"; Dictionary<string, object> dic = new Dictionary<string, object>(); dic.Add("AgreementID", agreement.ID); object o = db.ExcuteScular(sql, dic); decimal chargedSumMoney = 0m; decimal.TryParse((o ?? 0).ToString(), out chargedSumMoney); // 如果协议总金额大于等于协议金额,则更新协议状态为缴讫 if (chargedSumMoney == agreement.Money) { agreement.Status = 2; db.Update<Agreements>(agreement); } else if ((chargedSumMoney + charge.Money) > agreement.Money) { db.RollBack(); return "本期缴费金额加上历史缴费金额大于本协议缴费总金额,不能缴费,请调整缴费金额"; } #endregion // 插入主表 db.Insert<Charge>(charge); db.Commit(); return "缴费成功"; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Agreements model) { using (DBHelper db = DBHelper.Create()) { db.Update<Agreements>(model); return true; } }
/// <summary> /// 获取收费协议json /// </summary> /// <param name="param"></param> /// <param name="agree"></param> /// <param name="itemCount"></param> /// <returns></returns> public List<dynamic> SearchContrast(EasyUIGridParamModel param, Agreements agree, Customer c, out int itemCount) { List<SqlParameter> paramList = new List<SqlParameter>(); StringBuilder StrSql = new StringBuilder(); StrSql.Append(@"select a.ID,c.ID as customerID,c.Code,c.Name,a.Money,a.Status, a.begindate,a.enddate,a.createtime,a.checktime,a.Code as agreementCode from T_Agreements a left join T_Customer c on c.ID=a.CustomerID where 1=1 "); Dictionary<string, object> paramDic = new Dictionary<string, object>(); if (!string.IsNullOrEmpty(agree.ID)) { StrSql.Append("and a.ID=@ID "); paramDic.Add("ID", agree.ID); } if (agree.BeginDate.ToString() != "0001/1/1 0:00:00" && agree.EndDate.ToString() != "0001/1/1 0:00:00") { StrSql.Append("and a.begindate>=@beginDate and a.enddate<=@endDate "); paramDic.Add("beginDate", agree.BeginDate); paramDic.Add("endDate", agree.EndDate); } if (agree.Status != -1) { StrSql.Append("and a.status=@status "); paramDic.Add("status", agree.Status); } if (!string.IsNullOrEmpty(agree.CustomerID)) { StrSql.Append("and c.ID=@customerID "); paramDic.Add("customerID", agree.CustomerID); } if (!string.IsNullOrEmpty(c.Name)) { StrSql.Append("and c.Name like @name "); paramDic.Add("name", string.Format("%{0}%", c.Name)); } int pageIndex = Convert.ToInt32(param.page) - 1; int pageSize = Convert.ToInt32(param.rows); using (DBHelper db = DBHelper.Create()) { itemCount = db.GetCount(string.Format(DBHelper.StrGetCountSql, StrSql), paramDic); return db.GetDynaminObjectList(StrSql.ToString(), pageIndex, pageSize, null, paramDic); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Ajax.Model.Agreements model) { return(dal.Update(model)); }