public string GetMapScriptList(int iStart, int iLimit, string strMapName, int iType) { int iTotalCount = 0; DataSet ds = dal.GetMapScriptList(iStart, iLimit, strMapName, iType, ref iTotalCount); return(JSonClass.DataTableToJsonEx(ds.Tables[0], iTotalCount)); }
/// <summary> /// /// </summary> /// <returns></returns> public string GetManagerList(int iStart, int iLimit, int iType, string strUserID) { int iTotalCount = 0; DataSet ds = dal.GetList(iStart, iLimit, iType, strUserID, ref iTotalCount); return(JSonClass.DataTableToJsonEx(ds.Tables[0], iTotalCount)); }
public string GetHistoryList(int iStart, int iLimit) { int iTotalCount = 0; DataSet ds = dal.GetHistoryList(iStart, iLimit, ref iTotalCount); return(JSonClass.DataTableToJsonEx(ds.Tables[0], iTotalCount)); }
public string GetLogList(int iStart, int iLimit, int iType, string strOptID, string strDate) { int iTotalCount = 0; DataSet ds = dal.GetLogList(iStart, iLimit, iType, strOptID, strDate, ref iTotalCount); return(JSonClass.DataTableToJsonEx(ds.Tables[0], iTotalCount)); }
/// <summary> /// 获取用户列表 /// </summary> /// <param name="iStart"></param> /// <param name="iLimit"></param> /// <param name="strUserID"></param> /// <param name="strParentID"></param> /// <param name="iStatus"></param> /// <returns></returns> public string GetUserList(int iStart, int iLimit, string strUserID, string strParentID, int iStatus) { int iTotalCount = 0; DataSet ds = dal.GetUserList(iStart, iLimit, strUserID, strParentID, iStatus, ref iTotalCount); return(JSonClass.DataTableToJsonEx(ds.Tables[0], iTotalCount)); }
/// <summary> /// /// </summary> /// <param name="strUserID"></param> /// <returns></returns> public string GetSpgate(string strUserID) { DataSet ds = dal.GetSpgate(strUserID); foreach (DataRow row in ds.Tables[0].Rows) { row["name"] = row["name"].ToString() + row["value"] + "[" + ReturnPortString(row["gatetype"].ToString()) + "]"; } return(JSonClass.DataTableToJsonEx(ds.Tables[0], ds.Tables[0].Rows.Count)); }
/// <summary> /// /// </summary> /// <param name="iStart"></param> /// <param name="iLimit"></param> /// <param name="iType"></param> /// <param name="iBusiness"></param> /// <param name="strSpgate"></param> /// <returns></returns> public string GetSpgateList(int iStart, int iLimit, int iType, int iBusiness, string strSpgate) { int iTotalCount = 0; DataSet ds = dal.GetList(iStart, iLimit, iType, iBusiness, strSpgate, ref iTotalCount); //移除多余字段 int iCount = ds.Tables[0].Columns.Count; for (int i = 16; i < iCount; i++) { ds.Tables[0].Columns.RemoveAt(16); } return(JSonClass.DataTableToJsonEx(ds.Tables[0], iTotalCount)); }
public string GetMapScriptList() { DataSet ds = dal.GetAllMapScriptList(); if (ds.Tables[0].Rows.Count > 0) { string strRet = JSonClass.DataTableToJsonEx(ds.Tables[0], ds.Tables[0].Rows.Count); return(strRet); } else { return("{success:false,errorInfo:'无数据'}"); } }
/// <summary> /// 得到最大ID /// </summary> public static string GetBusinessList() { DataSet ds = SmsServer.DAL.SmsBusiness.GetBusinessList(); return(JSonClass.DataTableToJsonEx(ds.Tables[0], ds.Tables[0].Rows.Count)); }