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, "删除失败");
}