/// <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);
}
