public static bool ModifySPParameter(ref Data_SqlSPEntry activeSPEntry, string Paramername, SqlDbType SPType, ParameterDirection SPDirection, object SPValue, int size = -1)
{
if (activeSPEntry == null)
{
return(false);
}
else
{
SqlParameter activeParameter = null;
foreach (SqlParameter tmpParameter in activeSPEntry.ActiveParameters)
{
if (tmpParameter.ParameterName == Paramername)
{
activeParameter = tmpParameter;
break;
}
}
if (activeParameter != null)
{
activeParameter.Direction = SPDirection;
activeParameter.SqlDbType = SPType;
activeParameter.Value = SPValue;
if (size != -1)
{
activeParameter.Size = size;
}
return(true);
}
else
{
return(false);
}
}
}
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 static void CopyParams(ref Data_SqlSPEntry sourceEntry, ref Data_SqlSPEntry objectEntry)
{
foreach (SqlParameter activeParameter in sourceEntry.ActiveParameters)
{
SqlParameter cloneObj = new SqlParameter();
cloneObj.ParameterName = activeParameter.ParameterName;
cloneObj.Direction = activeParameter.Direction;
cloneObj.DbType = activeParameter.DbType;
objectEntry.ActiveParameters.Add(cloneObj);
}
}
public static bool AddSPEntryToList(string SPName, SqlDbType SPType, string EntryType, ref List<Data_SqlSPEntry> activeList)
{
if (activeList == null)
return false;
Data_SqlSPEntry activeEntry = new Data_SqlSPEntry();
activeEntry.SPName = SPName;
activeEntry.SPType = SPType;
activeEntry.EntryType = EntryType;
activeList.Add(activeEntry);
return true;
}
public object Clone()
{
Data_SqlSPEntry newEntry = new Data_SqlSPEntry();
newEntry.ActiveParameters = this.ActiveParameters;
newEntry.EntryType = this.EntryType;
newEntry.KeyName = this.KeyName;
newEntry.SPName = this.SPName;
newEntry.SPType = this.SPType;
return(newEntry);
}
public static void CopyParams(ref Data_SqlSPEntry sourceEntry, ref Data_SqlSPEntry objectEntry)
{
foreach (SqlParameter activeParameter in sourceEntry.ActiveParameters)
{
SqlParameter cloneObj = new SqlParameter();
cloneObj.ParameterName = activeParameter.ParameterName;
cloneObj.Direction = activeParameter.Direction;
cloneObj.DbType = activeParameter.DbType;
objectEntry.ActiveParameters.Add(cloneObj);
}
}
public static bool AddSPEntryToQueue(string SPName, SqlDbType SPType, string EntryType, ref Queue<Data_SqlSPEntry> activeQueue)
{
if (activeQueue == null)
return false;
Data_SqlSPEntry activeEntry = new Data_SqlSPEntry();
activeEntry.SPName = SPName;
activeEntry.SPType = SPType;
activeEntry.EntryType = EntryType;
activeQueue.Enqueue(activeEntry);
return true;
}
public static bool AddSPParameter(ref Data_SqlSPEntry activeSPEntry, string Paramername, SqlDbType SPType, ParameterDirection SPDirection, int size, object SPValue)
{
if (activeSPEntry == null)
return false;
SqlParameter activeParameter = new SqlParameter();
activeParameter.ParameterName = Paramername;
activeParameter.Direction = SPDirection;
activeParameter.SqlDbType = SPType;
activeParameter.Value = SPValue;
activeParameter.Size = size;
activeSPEntry.ActiveParameters.Add(activeParameter);
return true;
}
public static bool AddSPEntryToList(string SPName, SqlDbType SPType, string EntryType, ref List <Data_SqlSPEntry> activeList)
{
if (activeList == null)
{
return(false);
}
Data_SqlSPEntry activeEntry = new Data_SqlSPEntry();
activeEntry.SPName = SPName;
activeEntry.SPType = SPType;
activeEntry.EntryType = EntryType;
activeList.Add(activeEntry);
return(true);
}
public static bool AddSPEntryToQueue(string SPName, SqlDbType SPType, string EntryType, ref Queue <Data_SqlSPEntry> activeQueue)
{
if (activeQueue == null)
{
return(false);
}
Data_SqlSPEntry activeEntry = new Data_SqlSPEntry();
activeEntry.SPName = SPName;
activeEntry.SPType = SPType;
activeEntry.EntryType = EntryType;
activeQueue.Enqueue(activeEntry);
return(true);
}
public static bool AddSPParameter(ref Data_SqlSPEntry activeSPEntry, string Paramername, SqlDbType SPType, ParameterDirection SPDirection, int size, object SPValue)
{
if (activeSPEntry == null)
{
return(false);
}
SqlParameter activeParameter = new SqlParameter();
activeParameter.ParameterName = Paramername;
activeParameter.Direction = SPDirection;
activeParameter.SqlDbType = SPType;
activeParameter.Value = SPValue;
activeParameter.Size = size;
activeSPEntry.ActiveParameters.Add(activeParameter);
return(true);
}
public bool Action_ExecuteForNonQuery(Data_SqlSPEntry activeSPEntry)
{
try
{
if (activeSPEntry == null)
{
return(false);
}
else
{
if (activeconnection != null)
{
if (activeconnection != null)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = activeSPEntry.SPName;
cmd.CommandType = CommandType.StoredProcedure;
foreach (SqlParameter activeParameter in activeSPEntry.ActiveParameters)
{
SqlParameter newParameter = new SqlParameter();
newParameter.ParameterName = activeParameter.ParameterName;
newParameter.SqlDbType = activeParameter.SqlDbType;
newParameter.DbType = activeParameter.DbType;
newParameter.Direction = activeParameter.Direction;
newParameter.Value = activeParameter.Value;
cmd.Parameters.Add(newParameter);
}
cmd.Connection = activeconnection;
cmd.ExecuteNonQuery();
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
}
catch
{
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 bool Action_ExecuteForDT(Data_SqlSPEntry activeSPEntry, out DataTable resultDT)
{
resultDT = null;
try
{
if (activeSPEntry == null)
{
return(false);
}
else
{
if (activeconnection != null)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = activeSPEntry.SPName;
cmd.CommandType = CommandType.StoredProcedure;
foreach (SqlParameter activeParameter in activeSPEntry.ActiveParameters)
{
SqlParameter newParameter = cmd.CreateParameter();
newParameter.ParameterName = activeParameter.ParameterName;
newParameter.DbType = activeParameter.DbType;
newParameter.Direction = activeParameter.Direction;
newParameter.Value = activeParameter.Value;
cmd.Parameters.Add(newParameter);
}
cmd.Connection = activeconnection;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
resultDT = new DataTable();
sda.Fill(resultDT);
return(true);
}
else
{
return(false);
}
}
}
catch
{
return(false);
}
}
public static int GetSPParameterIndex(ref Data_SqlSPEntry activeSPEntry, string Paramername)
{
int index = 0;
if (activeSPEntry != null)
{
foreach (SqlParameter activeParameter in activeSPEntry.ActiveParameters)
{
if (activeParameter.ParameterName == Paramername)
{
return(index);
}
index++;
}
return(-1);
}
else
{
return(-1);
}
}
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);
}
}
public bool Action_ExecuteForDS(Data_SqlSPEntry activeSPEntry, out DataSet resultDS)
{
resultDS = null;
try
{
if (activeSPEntry == null)
{
return(false);
}
else
{
if (activeconnection != null)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = activeSPEntry.SPName;
cmd.CommandType = CommandType.StoredProcedure;
foreach (SqlParameter activeParameter in activeSPEntry.ActiveParameters)
{
cmd.Parameters.Add(activeParameter);
}
cmd.Connection = activeconnection;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
resultDS = new DataSet();
sda.Fill(resultDS);
return(true);
}
else
{
return(false);
}
}
}
catch
{
return(false);
}
}
public bool Action_ExecuteForDataReader(Data_SqlSPEntry activeSPEntry, out SqlDataReader sqlDataReader)
{
sqlDataReader = null;
try
{
if (activeSPEntry == null)
return false;
else
{
if (activeconnection != null)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = activeSPEntry.SPName;
cmd.CommandType = CommandType.StoredProcedure;
foreach (SqlParameter activeParameter in activeSPEntry.ActiveParameters)
{
SqlParameter newParameter = cmd.CreateParameter();
newParameter.ParameterName = activeParameter.ParameterName;
newParameter.DbType = activeParameter.DbType;
newParameter.Direction = activeParameter.Direction;
newParameter.Value = activeParameter.Value;
cmd.Parameters.Add(newParameter);
}
cmd.Connection = activeconnection;
sqlDataReader = cmd.ExecuteReader();
return true;
}
else
return false;
}
}
catch
{
return false;
}
}
public static void ModifyExcludeSPParameter(ref Data_SqlSPEntry activeSPEntry, Dictionary <string, object> parameterMaping, List <string> filterParameter)
{
List <SqlParameter> excluded = new List <SqlParameter>();
foreach (SqlParameter tmpParameter in activeSPEntry.ActiveParameters)
{
if (filterParameter.Contains(tmpParameter.ParameterName))
{
continue;
}
if (parameterMaping.ContainsKey(tmpParameter.ParameterName))
{
continue;
}
else
{
excluded.Add(tmpParameter);
}
}
foreach (SqlParameter tmpExcludeParameter in excluded)
{
activeSPEntry.ActiveParameters.Remove(tmpExcludeParameter);
}
}
public bool Action_ExecuteForDT(Data_SqlSPEntry activeSPEntry, out DataTable resultDT)
{
resultDT = null;
try
{
if (activeSPEntry == null)
return false;
else
{
if (activeconnection != null)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = activeSPEntry.SPName;
cmd.CommandType = CommandType.StoredProcedure;
foreach (SqlParameter activeParameter in activeSPEntry.ActiveParameters)
{
SqlParameter newParameter = cmd.CreateParameter();
newParameter.ParameterName = activeParameter.ParameterName;
newParameter.DbType = activeParameter.DbType;
newParameter.Direction = activeParameter.Direction;
newParameter.Value = activeParameter.Value;
cmd.Parameters.Add(newParameter);
}
cmd.Connection = activeconnection;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
resultDT = new DataTable();
sda.Fill(resultDT);
return true;
}
else
return false;
}
}
catch
{
return false;
}
}
public static Dictionary <string, Data_SqlSPEntry> Action_AutoLoadingAllSPS(SqlConnection ActiveConnection, string SPType)
{
if (ActiveConnection != null)
{
Data_SqlDataHelper obj = new Data_SqlDataHelper();
obj.ActiveConnection = ActiveConnection;
string sql_getallsps = "select * from sys.all_objects where (type = 'P') AND (is_ms_shipped = 0)";
DataTable activeSPSDT = new DataTable();
Dictionary <string, Data_SqlSPEntry> result = new Dictionary <string, Data_SqlSPEntry>();
if (obj.Action_ExecuteForDT(sql_getallsps, out activeSPSDT))
{
foreach (DataRow activeRow in activeSPSDT.Rows)
{
Data_SqlSPEntry newSPEntry = new Data_SqlSPEntry();
string spName = "";
obj.Static_GetColumnData(activeRow, "name", out spName);
if (SPType != "")
{
if (SPType == Data_SqlSPEntryType.SelectAction)
{
if (!spName.StartsWith(Data_SqlSPEntryNameFiler.StartNamed_SelectAction))
{
continue;
}
}
else if (SPType == Data_SqlSPEntryType.UpdateAction)
{
if (!spName.StartsWith(Data_SqlSPEntryNameFiler.StartNamed_Update))
{
continue;
}
}
}
newSPEntry.SPName = spName;
newSPEntry.KeyName = spName;
string spObjectID = "";
obj.Static_GetColumnData(activeRow, "object_id", out spObjectID);
string sql_paramters = "select * from sys.all_parameters where object_id = " + spObjectID;
DataTable activeSPParametersDT = new DataTable();
string sql_paramstype = "select * from sys.types";
DataTable paramstypeDT = new DataTable();
if (!obj.Action_ExecuteForDT(sql_paramstype, out paramstypeDT))
{
return(null);
}
if (obj.Action_ExecuteForDT(sql_paramters, out activeSPParametersDT))
{
foreach (DataRow activeParamterRow in activeSPParametersDT.Rows)
{
string activeSystemType_ID = "";
obj.Static_GetColumnData(activeParamterRow, "system_type_id", out activeSystemType_ID);
string activeUserType_ID = "";
obj.Static_GetColumnData(activeParamterRow, "user_type_id", out activeUserType_ID);
string activeParamsMaxLength = "";
obj.Static_GetColumnData(activeParamterRow, "max_length", out activeParamsMaxLength);
string activeParamsName = "";
obj.Static_GetColumnData(activeParamterRow, "name", out activeParamsName);
string activeIsOutPut = "";
obj.Static_GetColumnData(activeParamterRow, "is_output", out activeIsOutPut);
string max_length = "";
obj.Static_GetColumnData(activeParamterRow, "max_length", out max_length);
string activeDBType = "";
DataRow[] dbtyps = paramstypeDT.Select("system_type_id=" + activeSystemType_ID + " and user_type_id=" + activeUserType_ID);
if (dbtyps.Length > 0)
{
obj.Static_GetColumnData(dbtyps[0], "name", out activeDBType);
Data_SqlSPEntry.AddSPParameter(ref newSPEntry, activeParamsName, Data_SqlSPHelper.Static_GetDbTypeFromConfigStr(activeDBType), ParameterDirection.Input, int.Parse(max_length), null);
}
else
{
continue;
}
}
}
else
{
continue;
}
result.Add(newSPEntry.KeyName, newSPEntry);
}
}
return(result);
}
else
{
return(null);
}
}
public static int GetSPParameterIndex(ref Data_SqlSPEntry activeSPEntry, string Paramername)
{
int index = 0;
if (activeSPEntry != null)
{
foreach (SqlParameter activeParameter in activeSPEntry.ActiveParameters)
{
if (activeParameter.ParameterName == Paramername)
{
return index;
}
index++;
}
return -1;
}
else
return -1;
}
public bool Action_ExecuteForDS(Data_SqlSPEntry activeSPEntry, out DataSet resultDS)
{
resultDS = null;
try
{
if (activeSPEntry == null)
return false;
else
{
if (activeconnection != null)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = activeSPEntry.SPName;
cmd.CommandType = CommandType.StoredProcedure;
foreach (SqlParameter activeParameter in activeSPEntry.ActiveParameters)
cmd.Parameters.Add(activeParameter);
cmd.Connection = activeconnection;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
resultDS = new DataSet();
sda.Fill(resultDS);
return true;
}
else
return false;
}
}
catch
{
return false;
}
}
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;
}
public static Dictionary<string, Data_SqlSPEntry> Action_AutoLoadingAllSPS(SqlConnection ActiveConnection, string SPType)
{
if (ActiveConnection != null)
{
Data_SqlDataHelper obj = new Data_SqlDataHelper();
obj.ActiveConnection = ActiveConnection;
string sql_getallsps = "select * from sys.all_objects where (type = 'P') AND (is_ms_shipped = 0)";
DataTable activeSPSDT = new DataTable();
Dictionary<string, Data_SqlSPEntry> result = new Dictionary<string, Data_SqlSPEntry>();
if (obj.Action_ExecuteForDT(sql_getallsps, out activeSPSDT))
{
foreach (DataRow activeRow in activeSPSDT.Rows)
{
Data_SqlSPEntry newSPEntry = new Data_SqlSPEntry();
string spName = "";
obj.Static_GetColumnData(activeRow, "name", out spName);
if (SPType != "")
{
if (SPType == Data_SqlSPEntryType.SelectAction)
{
if (!spName.StartsWith(Data_SqlSPEntryNameFiler.StartNamed_SelectAction))
continue;
}
else if (SPType == Data_SqlSPEntryType.UpdateAction)
{
if (!spName.StartsWith(Data_SqlSPEntryNameFiler.StartNamed_Update))
continue;
}
}
newSPEntry.SPName = spName;
newSPEntry.KeyName = spName;
string spObjectID = "";
obj.Static_GetColumnData(activeRow, "object_id", out spObjectID);
string sql_paramters = "select * from sys.all_parameters where object_id = " + spObjectID;
DataTable activeSPParametersDT = new DataTable();
string sql_paramstype = "select * from sys.types";
DataTable paramstypeDT = new DataTable();
if (!obj.Action_ExecuteForDT(sql_paramstype, out paramstypeDT))
{
return null;
}
if (obj.Action_ExecuteForDT(sql_paramters, out activeSPParametersDT))
{
foreach (DataRow activeParamterRow in activeSPParametersDT.Rows)
{
string activeSystemType_ID = "";
obj.Static_GetColumnData(activeParamterRow, "system_type_id", out activeSystemType_ID);
string activeUserType_ID = "";
obj.Static_GetColumnData(activeParamterRow, "user_type_id", out activeUserType_ID);
string activeParamsMaxLength = "";
obj.Static_GetColumnData(activeParamterRow, "max_length", out activeParamsMaxLength);
string activeParamsName = "";
obj.Static_GetColumnData(activeParamterRow, "name", out activeParamsName);
string activeIsOutPut = "";
obj.Static_GetColumnData(activeParamterRow, "is_output", out activeIsOutPut);
string max_length = "";
obj.Static_GetColumnData(activeParamterRow, "max_length", out max_length);
string activeDBType = "";
DataRow[] dbtyps = paramstypeDT.Select("system_type_id=" + activeSystemType_ID + " and user_type_id=" + activeUserType_ID);
if (dbtyps.Length > 0)
{
obj.Static_GetColumnData(dbtyps[0], "name", out activeDBType);
Data_SqlSPEntry.AddSPParameter(ref newSPEntry, activeParamsName, Data_SqlSPHelper.Static_GetDbTypeFromConfigStr(activeDBType), ParameterDirection.Input, int.Parse(max_length), null);
}
else
continue;
}
}
else
{
continue;
}
result.Add(newSPEntry.KeyName, newSPEntry);
}
}
return result;
}
else
return null;
}
public bool Action_ExecuteUpdateSPS(Data_SqlSPEntry activeEntry, SqlConnection ActiveConnection, Dictionary<string, object> ValueMaping)
{
Dictionary<string, int> SizeMaping=new Dictionary<string,int>();
return Action_ExecuteUpdateSPS(activeEntry, ActiveConnection, ValueMaping, SizeMaping);
}
public DataTable Action_ExecuteGetSPSForDT(Data_SqlSPEntry activeEntry, SqlConnection ActiveConnection)
{
DataTable dt = new DataTable();
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_ExecuteForDT(activeEntry, out dt);
return dt;
}
else
return null;
}
public object Clone()
{
Data_SqlSPEntry newEntry = new Data_SqlSPEntry();
newEntry.ActiveParameters = this.ActiveParameters;
newEntry.EntryType = this.EntryType;
newEntry.KeyName = this.KeyName;
newEntry.SPName = this.SPName;
newEntry.SPType = this.SPType;
return newEntry;
}
public static bool ModifySPParameter(ref Data_SqlSPEntry activeSPEntry, string Paramername, SqlDbType SPType, ParameterDirection SPDirection, object SPValue, int size = -1)
{
if (activeSPEntry == null)
return false;
else
{
SqlParameter activeParameter = null;
foreach (SqlParameter tmpParameter in activeSPEntry.ActiveParameters)
{
if (tmpParameter.ParameterName == Paramername)
{
activeParameter = tmpParameter;
break;
}
}
if (activeParameter != null)
{
activeParameter.Direction = SPDirection;
activeParameter.SqlDbType = SPType;
activeParameter.Value = SPValue;
if (size != -1)
activeParameter.Size = size;
return true;
}
else
return false;
}
}
public static void ModifyExcludeSPParameter(ref Data_SqlSPEntry activeSPEntry, Dictionary<string, object> parameterMaping, List<string> filterParameter)
{
List<SqlParameter> excluded = new List<SqlParameter>();
foreach (SqlParameter tmpParameter in activeSPEntry.ActiveParameters)
{
if (filterParameter.Contains(tmpParameter.ParameterName))
continue;
if (parameterMaping.ContainsKey(tmpParameter.ParameterName))
continue;
else
{
excluded.Add(tmpParameter);
}
}
foreach (SqlParameter tmpExcludeParameter in excluded)
{
activeSPEntry.ActiveParameters.Remove(tmpExcludeParameter);
}
}
public bool Action_ExecuteUpdateSPS(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, "update");
List<string> filterExclude = new List<string>();
filterExclude.Add("@operation");
Data_SqlSPEntry.ModifyExcludeSPParameter(ref activeEntry, ValueMaping, filterExclude);
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 bool Action_ExecuteDeleteSPS(Data_SqlSPEntry activeEntry, SqlConnection ActiveConnection, Dictionary <string, object> ValueMaping)
{
Dictionary <string, int> SizeMaping = new Dictionary <string, int>();
return(Action_ExecuteDeleteSPS(activeEntry, ActiveConnection, ValueMaping, SizeMaping));
}
