private OperationReturn GetAlarmInfomationList(SessionInfo session, List <string> listParams)
{
OperationReturn optReturn = new OperationReturn();
optReturn.Result = true;
optReturn.Code = 0;
try
{
//ListParam
//0 用户编号
if (listParams == null || listParams.Count < 1)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_PARAM_INVALID;
optReturn.Message = string.Format("Request param is null or count invalid");
return(optReturn);
}
string strUserID = listParams[0];
string strSql;
DataSet objDataSet;
switch (session.DBType)
{
case 2:
strSql = string.Format("SELECT * FROM T_25_007 ORDER BY C001");
optReturn = MssqlOperation.GetDataSet(session.DBConnectionString, strSql);
if (!optReturn.Result)
{
return(optReturn);
}
objDataSet = optReturn.Data as DataSet;
break;
case 3:
strSql = string.Format("SELECT * FROM T_25_007 ORDER BY C001");
optReturn = OracleOperation.GetDataSet(session.DBConnectionString, strSql);
if (!optReturn.Result)
{
return(optReturn);
}
objDataSet = optReturn.Data as DataSet;
break;
default:
optReturn.Result = false;
optReturn.Code = Defines.RET_PARAM_INVALID;
optReturn.Message = string.Format("Database type not surpport.\t{0}", session.DBType);
return(optReturn);
}
if (objDataSet == null)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_OBJECT_NULL;
optReturn.Message = string.Format("DataSet is null");
return(optReturn);
}
List <string> listReturn = new List <string>();
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
DataRow dr = objDataSet.Tables[0].Rows[i];
AlarmInfomationInfo item = new AlarmInfomationInfo();
item.SerialID = Convert.ToInt64(dr["C001"]);
item.MessageID = Convert.ToInt64(dr["C002"]);
item.Level = Convert.ToInt32(dr["C003"]);
item.IsEnabled = dr["C004"].ToString() == "1";
item.Name = dr["C005"].ToString();
item.Description = dr["C006"].ToString();
item.CreateTime = string.IsNullOrEmpty(dr["C007"].ToString())
? DateTime.MinValue
: Convert.ToDateTime(dr["C007"]);
item.Creator = string.IsNullOrEmpty(dr["C008"].ToString())
? 0
: Convert.ToInt64(dr["C008"]);
item.LastModifyTime = string.IsNullOrEmpty(dr["C009"].ToString())
? DateTime.MinValue
: Convert.ToDateTime(dr["C009"]);
item.LastModifyUser = string.IsNullOrEmpty(dr["C010"].ToString())
? 0
: Convert.ToInt64(dr["C010"]);
optReturn = XMLHelper.SeriallizeObject(item);
if (!optReturn.Result)
{
return(optReturn);
}
listReturn.Add(optReturn.Data.ToString());
}
optReturn.Data = listReturn;
}
catch (Exception ex)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_FAIL;
optReturn.Message = ex.Message;
return(optReturn);
}
return(optReturn);
}
private OperationReturn GetAlarmReveiverList(SessionInfo session, List <string> listParams)
{
OperationReturn optReturn = new OperationReturn();
optReturn.Result = true;
optReturn.Code = 0;
try
{
//ListParam
//0 用户编号
//1 AlarmInfo SerialID（如果为0表示获取所有接收人信息）
if (listParams == null || listParams.Count < 2)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_PARAM_INVALID;
optReturn.Message = string.Format("Request param is null or count invalid");
return(optReturn);
}
string strUserID = listParams[0];
string strAlarmInfoID = listParams[1];
long alarmInfoID;
if (!long.TryParse(strAlarmInfoID, out alarmInfoID))
{
optReturn.Result = false;
optReturn.Code = Defines.RET_PARAM_INVALID;
optReturn.Message = string.Format("AlarmInfoID invalid");
return(optReturn);
}
string strSql;
DataSet objDataSet;
switch (session.DBType)
{
case 2:
if (alarmInfoID == 0)
{
strSql = string.Format("SELECT * FROM T_25_008 ORDER BY C001,C002");
}
else
{
strSql = string.Format("SELECT * FROM T_25_008 WHERE C002 = {0} ORDER BY C001,C002",
alarmInfoID);
}
optReturn = MssqlOperation.GetDataSet(session.DBConnectionString, strSql);
if (!optReturn.Result)
{
return(optReturn);
}
objDataSet = optReturn.Data as DataSet;
break;
case 3:
if (alarmInfoID == 0)
{
strSql = string.Format("SELECT * FROM T_25_008 ORDER BY C001,C002");
}
else
{
strSql = string.Format("SELECT * FROM T_25_008 WHERE C002 = {0} ORDER BY C001,C002",
alarmInfoID);
}
optReturn = OracleOperation.GetDataSet(session.DBConnectionString, strSql);
if (!optReturn.Result)
{
return(optReturn);
}
objDataSet = optReturn.Data as DataSet;
break;
default:
optReturn.Result = false;
optReturn.Code = Defines.RET_PARAM_INVALID;
optReturn.Message = string.Format("Database type not surpport.\t{0}", session.DBType);
return(optReturn);
}
if (objDataSet == null)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_OBJECT_NULL;
optReturn.Message = string.Format("DataSet is null");
return(optReturn);
}
List <string> listReturn = new List <string>();
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
DataRow dr = objDataSet.Tables[0].Rows[i];
AlarmReceiverInfo item = new AlarmReceiverInfo();
item.UserID = Convert.ToInt64(dr["C001"]);
item.AlarmInfoID = Convert.ToInt64(dr["C002"]);
item.TenantID = Convert.ToInt64(dr["C003"]);
item.TenantToken = dr["C004"].ToString();
item.Method = string.IsNullOrEmpty(dr["C005"].ToString()) ? 0 : Convert.ToInt32(dr["C005"]);
item.ReplyMode = string.IsNullOrEmpty(dr["C006"].ToString()) ? 0 : Convert.ToInt32(dr["C006"]);
optReturn = XMLHelper.SeriallizeObject(item);
if (!optReturn.Result)
{
return(optReturn);
}
listReturn.Add(optReturn.Data.ToString());
}
optReturn.Data = listReturn;
}
catch (Exception ex)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_FAIL;
optReturn.Message = ex.Message;
return(optReturn);
}
return(optReturn);
}