/// <summary>
/// 检查表是否存在
/// </summary>
/// <param name="session"></param>
/// <param name="lstParams"></param>
/// lstParams[0] : TableName
/// <returns></returns>
public static OperationReturn CheckTableExists(SessionInfo session, string strTableName)
{
OperationReturn optReturn = new OperationReturn();
try
{
string rentToken = session.RentInfo.Token;
string strSql = string.Empty;
switch (session.DBType)
{
case 2:
strSql = string.Format("use {0}; SELECT * FROM dbo.SysObjects WHERE ID = object_id(N'[{1}]') AND OBJECTPROPERTY(ID, 'IsTable') = 1", session.DatabaseInfo.DBName, strTableName);
optReturn = MssqlOperation.GetDataSet(session.DBConnectionString, strSql);
if (!optReturn.Result)
{
return(optReturn);
}
break;
case 3:
strSql = string.Format("select * from user_tables where table_name ='{0}' ", strTableName);
optReturn = OracleOperation.GetDataSet(session.DBConnectionString, strSql);
if (!optReturn.Result)
{
return(optReturn);
}
break;
}
optReturn.Message = strSql;
if (optReturn.Data == null)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_FAIL;
return(optReturn);
}
DataSet ds = optReturn.Data as DataSet;
if (ds.Tables.Count <= 0 || ds.Tables[0].Rows.Count <= 0)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_FAIL;
return(optReturn);
}
optReturn.Result = true;
optReturn.Code = Defines.RET_SUCCESS;
}
catch (Exception ex)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_FAIL;
optReturn.Message = ex.Message;
optReturn.Exception = ex;
}
return(optReturn);
}
public static OperationReturn DeleteTempDataByID(SessionInfo session, string strKey)
{
OperationReturn optReturn = new OperationReturn();
try
{
string rentToken = session.RentInfo.Token;
string strSql = string.Empty;
switch (session.DBType)
{
case 2:
strSql = string.Format("delete from T_00_901 where C001 = {0}", strKey);
optReturn = MssqlOperation.ExecuteSql(session.DBConnectionString, strSql);
if (!optReturn.Result)
{
return(optReturn);
}
break;
case 3:
strSql = string.Format("delete from T_00_901 where C001 = {0}", strKey);
optReturn = OracleOperation.ExecuteSql(session.DBConnectionString, strSql);
if (!optReturn.Result)
{
return(optReturn);
}
break;
}
optReturn.Message = strSql;
if (optReturn.Data == null)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_FAIL;
return(optReturn);
}
optReturn.Result = true;
optReturn.Code = Defines.RET_SUCCESS;
}
catch (Exception ex)
{
optReturn.Result = false;
optReturn.Code = Defines.RET_FAIL;
optReturn.Message = ex.Message;
optReturn.Exception = ex;
}
return(optReturn);
}
