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