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