public Int32 Execute_SqlParameter2(int commandType, string Sqlstr, DataSet DsDbParameter, string dataAccessName)
{
DataAccessCollections dac = new DataAccessCollections();
MyNet.Common.Data.DataAccess dAccess = dac.GetDataAccess(dataAccessName);
DataTable dt = DsDbParameter.Tables[0];
DbParameter[] DbParameter = new DbParameter[dt.Rows.Count];
for (int i = 0; i < DsDbParameter.Tables[0].Rows.Count; i++)
{
DbParameter[i] = new MySql.Data.MySqlClient.MySqlParameter(dt.Rows[i]["name"].ToString(), dt.Rows[i]["value"]);
try
{
if (dt.Rows[i]["type"] != null)
{
DbParameter[i].DbType = (DbType)int.Parse(dt.Rows[i]["type"].ToString());
}
}
catch
{
}
}
System.Data.CommandType ComType = (System.Data.CommandType)commandType;
return(dAccess.Execute_Procedure(ComType, Sqlstr, DbParameter));
}
public Int32 Execute_Procedure(string ProcedureName, DataSet DsDbParameter)
{
DataTable dt = DsDbParameter.Tables[0];
DbParameter[] DbParameter = new DbParameter[dt.Rows.Count];
for (int i = 0; i < DsDbParameter.Tables[0].Rows.Count; i++)
{
DbParameter[i] = new MySql.Data.MySqlClient.MySqlParameter(dt.Rows[i]["name"].ToString(), dt.Rows[i]["value"]);
try
{
if (dt.Rows[i]["type"] != null)
{
DbParameter[i].DbType = (DbType)int.Parse(dt.Rows[i]["type"].ToString());
}
}
catch
{
}
}
return(dataAccess.Execute_Procedure(ProcedureName, DbParameter));
}
