private OperationReturn UpdateUserPermission(SessionInfo session, List <string> listParams)
{
OperationReturn optReturn = new OperationReturn();
optReturn.Result = true;
optReturn.Code = 0;
int errNum = 0;
string errMsg = string.Empty;
try
{
if (listParams.Count < 2)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_PARAM_INVALID;
optReturn.Message = string.Format("Param count invalid");
return(optReturn);
}
string strUserID = listParams[0];
string strOperatorID = listParams[1];
switch (session.DBType)
{
//MSSQL
case 2:
DbParameter[] mssqlParameters =
{
MssqlOperation.GetDbParameter("@ainparam01", MssqlDataType.Varchar, 5),
MssqlOperation.GetDbParameter("@ainparam02", MssqlDataType.Varchar, 20),
MssqlOperation.GetDbParameter("@ainparam03", MssqlDataType.Varchar, 20),
MssqlOperation.GetDbParameter("@aouterrornumber", MssqlDataType.Bigint, 0),
MssqlOperation.GetDbParameter("@aouterrorstring", MssqlDataType.Varchar, 200)
};
mssqlParameters[0].Value = session.RentInfo.Token;
mssqlParameters[1].Value = strUserID;
mssqlParameters[2].Value = strOperatorID;
mssqlParameters[3].Value = errNum;
mssqlParameters[4].Value = errMsg;
mssqlParameters[3].Direction = ParameterDirection.Output;
mssqlParameters[4].Direction = ParameterDirection.Output;
optReturn = MssqlOperation.ExecuteStoredProcedure(session.DBConnectionString, "P_11_016",
mssqlParameters);
if (!optReturn.Result)
{
return(optReturn);
}
if (mssqlParameters[3].Value.ToString() != "0")
{
optReturn.Result = false;
optReturn.Code = Defines.RET_DBACCESS_FAIL;
optReturn.Message = string.Format("{0}\t{1}", mssqlParameters[3].Value, mssqlParameters[4].Value);
}
break;
//ORCL
case 3:
DbParameter[] orclParameters =
{
OracleOperation.GetDbParameter("ainparam01", OracleDataType.Varchar2, 5),
OracleOperation.GetDbParameter("ainparam02", OracleDataType.Varchar2, 20),
OracleOperation.GetDbParameter("ainparam03", OracleDataType.Varchar2, 20),
OracleOperation.GetDbParameter("errornumber", OracleDataType.Int32, 0),
OracleOperation.GetDbParameter("errorstring", OracleDataType.Varchar2, 200)
};
orclParameters[0].Value = session.RentInfo.Token;
orclParameters[1].Value = strUserID;
orclParameters[2].Value = strOperatorID;
orclParameters[3].Value = errNum;
orclParameters[4].Value = errMsg;
orclParameters[3].Direction = ParameterDirection.Output;
orclParameters[4].Direction = ParameterDirection.Output;
optReturn = OracleOperation.ExecuteStoredProcedure(session.DBConnectionString, "P_11_016",
orclParameters);
if (!optReturn.Result)
{
return(optReturn);
}
if (orclParameters[3].Value.ToString() != "0")
{
optReturn.Result = false;
optReturn.Code = Defines.RET_DBACCESS_FAIL;
optReturn.Message = string.Format("{0}\t{1}", orclParameters[3].Value, orclParameters[4].Value);
}
break;
default:
optReturn.Result = false;
optReturn.Code = Defines.RET_PARAM_INVALID;
optReturn.Message = string.Format("DBType invalid");
return(optReturn);
}
}
catch (Exception ex)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_FAIL;
optReturn.Message = ex.Message;
}
return(optReturn);
}
