private OperationReturn GetInspectorList(SessionInfo session, List <string> listParams)
{
OperationReturn optReturn = new OperationReturn();
optReturn.Result = true;
optReturn.Code = 0;
try
{
string rentToken = session.RentInfo.Token;
string strSql;
DataSet objDataSet;
string strUserID = listParams[0];
switch (session.DBType)
{
case 2:
strSql = string.Format("SELECT * FROM T_11_005_{0} WHERE C001 IN (SELECT C004 FROM T_31_041_{0}) AND C001 IN (SELECT C004 FROM T_11_201_{0} WHERE C003 = {1})", rentToken, strUserID);
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_11_005_{0} WHERE C001 IN (SELECT C004 FROM T_31_041_{0}) AND C001 IN (SELECT C004 FROM T_11_201_{0} WHERE C003 = {1})", rentToken, strUserID);
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];
string strInspectorID = dr["C001"].ToString();
string strInspectorName = dr["C002"].ToString();
string strInspectorFullName = dr["C003"].ToString();
strInspectorName = DecryptString(strInspectorName);
strInspectorFullName = DecryptString(strInspectorFullName);
string strInfo = string.Format("{0}{1}{2}{1}{3}", strInspectorID, ConstValue.SPLITER_CHAR, strInspectorName, strInspectorFullName);
listReturn.Add(strInfo);
}
optReturn.Data = listReturn;
}
catch (Exception ex)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_FAIL;
optReturn.Message = ex.Message;
return(optReturn);
}
return(optReturn);
}
private OperationReturn GetVoiceIP_Name201(SessionInfo session)
{
OperationReturn optReturn = new OperationReturn();
optReturn.Result = true;
optReturn.Code = 0;
try
{
string rentToken = session.RentInfo.Token;
string strSql;
DataSet objDataSet;
switch (session.DBType)
{
case 2:
strSql = string.Format("SELECT DISTINCT C019,C020 FROM T_21_001", rentToken);
optReturn = MssqlOperation.GetDataSet(session.DBConnectionString, strSql);
if (!optReturn.Result)
{
return(optReturn);
}
objDataSet = optReturn.Data as DataSet;
break;
case 3:
strSql = string.Format("SELECT DISTINCT C019,C020 FROM T_21_001", rentToken);
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];
string strVoiceName = dr["C019"].ToString();
string strVoiceIP = dr["C020"].ToString();
string strInfo = string.Format("{0}{1}{2}", strVoiceName, ConstValue.SPLITER_CHAR, strVoiceIP);
listReturn.Add(strInfo);
}
optReturn.Data = listReturn;
}
catch (Exception ex)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_FAIL;
optReturn.Message = ex.Message;
return(optReturn);
}
return(optReturn);
}
private OperationReturn GetControlOrgInfoList(SessionInfo session, List <string> listParams)
{
OperationReturn optReturn = new OperationReturn();
optReturn.Result = true;
optReturn.Code = 0;
try
{
//ListParam
//0 用户编号
//1 上级机构编号（-1表示获取当前所属机构信息）,就是没有父节点的节点，就是根节点
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 strParentID = listParams[1];
string rentToken = session.RentInfo.Token;
string strSql;
DataSet objDataSet;
switch (session.DBType)
{
case 2:
if (strParentID == "-1")
{
strSql = string.Format("SELECT * FROM T_11_006_{0} WHERE C001 IN (SELECT C006 FROM T_11_005_{0} WHERE C001 = {1})", rentToken, strUserID);
//strSql = string.Format("SELECT * FROM T_11_006_{0} WHERE C001 IN (SELECT C006 FROM T_11_005_{0})", rentToken);
}
else
{
strSql = string.Format("SELECT * FROM T_11_006_{0} WHERE C001 IN (SELECT C004 FROM T_11_201_{0} WHERE C003 = {1}) AND C004 = {2}", rentToken, strUserID, strParentID);
//strSql = string.Format("SELECT * FROM T_11_006_{0} WHERE C004 = {1}", rentToken, strParentID);
}
optReturn = MssqlOperation.GetDataSet(session.DBConnectionString, strSql);
if (!optReturn.Result)
{
return(optReturn);
}
objDataSet = optReturn.Data as DataSet;
break;
case 3:
if (strParentID == "-1")
{
strSql = string.Format("SELECT * FROM T_11_006_{0} WHERE C001 IN (SELECT C006 FROM T_11_005_{0} WHERE C001 = {1})", rentToken, strUserID);
//strSql = string.Format("SELECT * FROM T_11_006_{0} WHERE C001 IN (SELECT C006 FROM T_11_005_{0})", rentToken);
}
else
{
strSql = string.Format("SELECT * FROM T_11_006_{0} WHERE C001 IN (SELECT C004 FROM T_11_201_{0} WHERE C003 = {1}) AND C004 = {2}", rentToken, strUserID, strParentID);
//strSql = string.Format("SELECT * FROM T_11_006_{0} WHERE C004 = {1}", rentToken, strParentID);
}
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];
string strName = dr["C001"].ToString();
string strFullName = dr["C002"].ToString();
strName = DecryptString(strName);
strFullName = DecryptString(strFullName);
string strInfo = string.Format("{0}{1}{2}", strName, ConstValue.SPLITER_CHAR, strFullName);
listReturn.Add(strInfo);
}
optReturn.Data = listReturn;
}
catch (Exception ex)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_FAIL;
optReturn.Message = ex.Message;
return(optReturn);
}
return(optReturn);
}
private OperationReturn GetOperationResultList(SessionInfo session)
{
OperationReturn optReturn = new OperationReturn();
optReturn.Result = true;
optReturn.Code = 0;
try
{
int LangID = session.LangTypeInfo.LangID;
string strSql;
DataSet objDataSet;
switch (session.DBType)
{
case 2:
strSql = string.Format("SELECT * FROM T_00_005 WHERE C002 LIKE 'OP%' AND C001={0}", LangID);
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_00_005 WHERE C002 LIKE 'OP%' AND C001={0}", LangID);
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];
string strOperationResultsCodes = dr["C002"].ToString();
string strOperationResultsContents = dr["C005"].ToString();
string strInfo = string.Format("{0}{1}{2}", strOperationResultsCodes, ConstValue.SPLITER_CHAR, strOperationResultsContents);
listReturn.Add(strInfo);
}
optReturn.Data = listReturn;
}
catch (Exception ex)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_FAIL;
optReturn.Message = ex.Message;
return(optReturn);
}
return(optReturn);
}
public WebReturn DoOperation(WebRequest RResult)
{
// bool flag = false;
WebReturn result = new WebReturn();
result.Result = true;
string SQL = RResult.Data;
SessionInfo session = RResult.Session;
string Conn = session.DBConnectionString;
int num = session.DBType;
if (RResult == null)
{
result.Message = "There is no available parameters";
result.Result = false;
return(result);
}
OperationReturn OpeReturn = new OperationReturn();
//string where = RResult.StringValue;
//int number = RResult.IntValue;
switch (RResult.Code)
{
case 701:
OpeReturn = GetDataSetFromDB(SQL, Conn, num);
if (OpeReturn.Result)
{
result.DataSetData = CryptProcess(OpeReturn.Data as DataSet, "C003");
}
else
{
result.Message = OpeReturn.Message;
result.Result = false;
}
//flag = false;
break;
case 100:
OpeReturn = GetDataSetFromDB(SQL, Conn, num);
if (OpeReturn.Result)
{
result.DataSetData = OpeReturn.Data as DataSet;
}
else
{
result.Message = OpeReturn.Message;
result.Result = false;
}
//flag = false;
break;
case 200:
OpeReturn = GetDataSetFromDB(SQL, Conn, num);
if (OpeReturn.Result)
{
result.DataSetData = CryptProcess(OpeReturn.Data as DataSet, "C002");
}
else
{
result.Message = OpeReturn.Message;
result.Result = false;
}
//flag = false;
break;
case 102:
OpeReturn = GetDataSetFromDB(SQL, Conn, num);
if (OpeReturn.Result)
{
result.DataSetData = CryptProcess(OpeReturn.Data as DataSet, "C017");
result.DataSetData = CryptProcess(OpeReturn.Data as DataSet, "C018");
}
else
{
result.Message = OpeReturn.Message;
result.Result = false;
}
//flag = false;
break;
case 103:
OpeReturn = GetDataSetFromDB(SQL, Conn, num);
if (OpeReturn.Result)
{
result.DataSetData = CryptProcess(OpeReturn.Data as DataSet, "C002");
result.DataSetData = CryptProcess(OpeReturn.Data as DataSet, "C003");
}
else
{
result.Message = OpeReturn.Message;
result.Result = false;
}
//flag = false;
break;
//case 201:
// OperationReturn ORTemp = GetDataSetFromDB(string.Format("SELECT C017 FROM T_11_101_{0} WHERE C001 IN (SELECT C004 FROM T_11_201_{0} WHERE C003={1}",session.RentInfo.Token,session.UserID), Conn, num);
// DataSet ds_temp = new DataSet();
// if (ORTemp.Result)
// ds_temp = CryptProcess(ORTemp.Data as DataSet, "C017");
// break;
default:
break;
}
#region 加载相应的报表
//if (flag)
//{
// result.DataSetData = GetReportData(RResult, OpeReturn);
//}
//else
//{
// result.StringValue = "敬请期待";
// result.BoolValue = false;
//}
return(result);
#endregion
}
