public string GetData(string content) { try { var data = new GetDataModel();// 获取数据 FX_RYLXInfo sourceList = new FX_RYLXInfo(); StringBuilder strSql = new StringBuilder(); strSql.Append(@"SELECT A.ryid,A.UserID,A.UserType,A.UserNumber,B.CnName AS UserName,C.FullName AS DepartmentName, (CASE A.UserType WHEN 1 THEN '调查人员' WHEN 2 THEN '询问人员' ELSE '执法人员' END) AS UserTypeText FROM FX_RYLXInfo A LEFT JOIN FX_UserInfo B ON A.UserID = B.UserID LEFT JOIN FX_Department C ON C.DPID = B.DPID ORDER BY A.ryid"); string jsonData = JsonConvert.SerializeObject(Utility.Database.ExcuteDataSet(strSql.ToString()).Tables[0]); data.sourceList = (List<FX_RYLXInfo>)JsonConvert.DeserializeObject(jsonData, typeof(List<FX_RYLXInfo>)); // 初始化一空行 data.sourceListEdit = new FX_RYLXInfo(); return Utility.JsonResult(true, null, data); } catch (Exception ex) { ComBase.Logger(ex); return Utility.JsonResult(false, ex.Message); } }
public string DeleteData(string content) { var delEnt = new FX_RYLXInfo(); delEnt.Condition.Add("ryid=" + content); if (Utility.Database.Delete(delEnt) > 0) return GetData(""); else return Utility.JsonResult(false, "删除失败"); }