public bool Action_ExecuteDeleteSPS(Data_SqlSPEntry activeEntry, SqlConnection ActiveConnection, Dictionary <string, object> ValueMaping, Dictionary <string, int> SizeMaping)
{
if (activeEntry != null && ActiveConnection != null)
{
Data_SqlSPEntry.ModifySPParameter(ref activeEntry, "@operation", SqlDbType.NVarChar, ParameterDirection.Input, "delete");
foreach (string activeParameter in ValueMaping.Keys)
{
int activeParametersIndex = Data_SqlSPEntry.GetSPParameterIndex(ref activeEntry, activeParameter);
if (activeParametersIndex != -1)
{
SqlParameter activeExistedParamter = activeEntry.ActiveParameters[activeParametersIndex];
if (!SizeMaping.ContainsKey(activeParameter))
{
Data_SqlSPEntry.ModifySPParameter(ref activeEntry, activeParameter, activeExistedParamter.SqlDbType, activeExistedParamter.Direction, ValueMaping[activeParameter]);
}
else
{
Data_SqlSPEntry.ModifySPParameter(ref activeEntry, activeParameter, activeExistedParamter.SqlDbType, activeExistedParamter.Direction, ValueMaping[activeParameter], SizeMaping[activeParameter]);
}
}
}
Data_SqlDataHelper activeSqlSPHelper = new Data_SqlDataHelper();
activeSqlSPHelper.ActiveConnection = ActiveConnection;
activeSqlSPHelper.Action_ExecuteForNonQuery(activeEntry);
return(true);
}
else
{
return(false);
}
}
public DataSet Action_ExecuteGetSPSForDS(Data_SqlSPEntry activeEntry, SqlConnection ActiveConnection)
{
DataSet ds = new DataSet();
if (activeEntry != null && ActiveConnection != null)
{
Data_SqlSPEntry.ModifySPParameter(ref activeEntry, "@operation", SqlDbType.NVarChar, ParameterDirection.Input, "get");
Data_SqlDataHelper activeSqlSPHelper = new Data_SqlDataHelper();
activeSqlSPHelper.ActiveConnection = ActiveConnection;
activeSqlSPHelper.Action_ExecuteForDS(activeEntry, out ds);
return(ds);
}
else
{
return(null);
}
}
public SqlDataReader Action_ExecuteGetSPSForDR(Data_SqlSPEntry activeEntry, SqlConnection ActiveConnection)
{
if (activeEntry != null && ActiveConnection != null)
{
Data_SqlSPEntry.ModifySPParameter(ref activeEntry, "@operation", SqlDbType.NVarChar, ParameterDirection.Input, "get");
Data_SqlDataHelper activeSqlSPHelper = new Data_SqlDataHelper();
activeSqlSPHelper.ActiveConnection = ActiveConnection;
SqlDataReader dr;
if (activeSqlSPHelper.Action_ExecuteForDataReader(activeEntry, out dr))
{
return(dr);
}
else
{
return(null);
}
}
else
{
return(null);
}
}
