/// <summary> /// 增加一条数据 /// </summary> public void Add(Unit model) { using (DBHelper db = DBHelper.Create()) { db.Insert<Unit>(model); } }
/// <summary> /// 获取付费单位列表json /// </summary> /// <param name="param"></param> /// <param name="u"></param> /// <param name="itemCount"></param> /// <returns></returns> public List<object> GetSearchJson(EasyUIGridParamModel param, Unit u, out int itemCount) { return dal.GetSerachJson(param, u, out itemCount); }
/// <summary> /// 查询付费单位列表json /// </summary> /// <param name="param"></param> /// <param name="unit"></param> /// <param name="itemCount"></param> /// <returns></returns> public List<object> GetSerachJson(EasyUIGridParamModel param, Unit unit, out int itemCount) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,NAME,CASE tu.LEVEL WHEN 1 THEN '计量' else '计时' end as level,timevalue "); strSql.Append("FROM T_Unit tu where 1=1 "); Dictionary<string, object> paramList = new Dictionary<string, object>(); if (!string.IsNullOrEmpty(unit.Name)) { strSql.Append("and (Name like @Name or PY like @PY)"); paramList.Add("Name", string.Format("%{0}%", unit.Name)); paramList.Add("PY", string.Format("%{0}%", Pinyin.GetPinyin(unit.Name))); } if (unit.Status != null) { strSql.Append("and Status=@Status "); paramList.Add("Status", unit.Status); } int pageIndex = Convert.ToInt32(param.page) - 1; int pageSize = Convert.ToInt32(param.rows); using (DBHelper db = DBHelper.Create()) { string sql = strSql.ToString(); itemCount = db.GetCount(sql, paramList); return db.GetDynaminObjectList(sql, pageIndex, pageSize, "ID", paramList); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Unit model) { using (DBHelper db = DBHelper.Create()) { db.Update<Unit>(model); return true; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Ajax.Model.Unit model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(Ajax.Model.Unit model) { dal.Add(model); }
public ActionResult ModifyUnit(Unit unit) { unit.PY = Pinyin.GetPinyin(unit.Name); unit.Status = 1; try { bool result = new UnitRule().Update(unit); if (result) { return GetSingelUnitValue(unit.ID); } else { throw new Exception("更新失败"); } } catch (Exception ex) { unit.State = "1"; unit.Errormsg = ex.Message; return Json(unit, JsonRequestBehavior.AllowGet); } }
public ActionResult AddUnit(Unit unit) { AjaxResult result = new AjaxResult(); unit.PY = Pinyin.GetPinyin(unit.Name); unit.Status = 1; unit.ID = Guid.NewGuid().ToString().Replace("-", ""); try { new UnitRule().Add(unit); result.Success = true; result.Message = "单位添加成功"; } catch { result.Success = false; result.Message = "单位新增失败。"; } return Json(result, JsonRequestBehavior.AllowGet); }
public ActionResult UnitSearch(EasyUIGridParamModel param, Unit unit) { int itemCount = 0; List<dynamic> uList = new UnitRule().GetSearchJson(param, unit, out itemCount); var listResult = from u in uList.ToList() select new { ID = u.ID, Name = u.NAME, Level = u.LEVEL, TimeValue = u.TIMEVALUE }; return Json(new { total = itemCount, rows = listResult.ToList() }, JsonRequestBehavior.AllowGet); }