public static string GetList(string page, string rows) { int pageNumber = int.Parse(page); int pageSize = int.Parse(rows); StringBuilder sbwhere = new StringBuilder(); sbwhere.Append(" and SFSC = 'N'"); XT_ZZJG_RYBM bllRybm = new XT_ZZJG_RYBM(request); var ds = bllRybm.GetListByPage(sbwhere.ToString(), "", (pageSize * pageNumber) - pageSize + 1, (pageSize * pageNumber), null); int count = ds.Tables[0].Rows.Count; List <EDRS.Model.XT_ZZJG_RYBM> modeList = bllRybm.DataTableToList(ds.Tables[0]); var resJson = JsonHelper.JsonString(modeList); string j = "{\"total\":" + count + ",\"rows\":" + resJson + "}"; return(j); }
public static string Delete(string ids) { ids = ids.Replace("[", "").Replace("]", "").Replace("\"", ""); var idsArry = ids.Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries); XT_ZZJG_RYBM bllRybm = new XT_ZZJG_RYBM(request); //每个更新 try { foreach (var s in idsArry) { var rybm = bllRybm.GetModel(s); if (rybm == null) { continue; } rybm.SFSC = "Y"; bllRybm.Update(rybm); } } catch (Exception) { return(ReturnString.JsonToString(Prompt.error, "删除失败!", null)); } return(ReturnString.JsonToString(Prompt.win, "删除成功", null)); }
/// <summary> /// 获取用户列表 /// </summary> /// <returns></returns> private string GetUserBybm() { string bmbm = Request.Form["bmbm"]; EDRS.BLL.XT_ZZJG_RYBM bll = new XT_ZZJG_RYBM(Request); DataSet ds = bll.GetListByBm(" and rj.dwbm=:dwbm and bmbm=:bmbm and SFTZ='N' and SFSC='N'", "GH ", 1, int.MaxValue, new object[] { UserInfo.DWBM, bmbm }); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { return(JsonHelper.JsonString(ds.Tables[0])); } return(ReturnString.JsonToString(Prompt.error, "未设置相关人员信息,请先添加", null)); }
public static string Add(string data) { var bllRybm = new XT_ZZJG_RYBM(request); var rybm = JsonHelper.ParseFormJson <EDRS.Model.XT_ZZJG_RYBM>(data); //验证工号是否已存在 bool exist = bllRybm.Exists(rybm.GZZH); if (exist) { return(ReturnString.JsonToString(Prompt.error, "工号已存在", null)); } //TODO: 单位编码读取 rybm.DWBM = "0001"; rybm.GH = rybm.GZZH; bool b = bllRybm.Add(rybm); return(b ? ReturnString.JsonToString(Prompt.win, "添加成功", null) : ReturnString.JsonToString(Prompt.error, "添加失败", null)); }