public Int32 Execute_NonQuery2(string Sqlstr, string dataAccessName)
{
DataAccessCollections dac = new DataAccessCollections();
MyNet.Common.Data.DataAccess dAccess = dac.GetDataAccess(dataAccessName);
return(dAccess.Execute_NonQuery(Sqlstr));
}
public string GetStr_ByIdx2(string Sqlstr, int Index, string dataAccessName)
{
DataAccessCollections dac = new DataAccessCollections();
MyNet.Common.Data.DataAccess dAccess = dac.GetDataAccess(dataAccessName);
return(dataAccess.Get_DataString(Sqlstr, Index));
}
public string GetStr_ByField2(string Sqlstr, string Field, string dataAccessName)
{
DataAccessCollections dac = new DataAccessCollections();
MyNet.Common.Data.DataAccess dAccess = dac.GetDataAccess(dataAccessName);
return(dAccess.Get_DataString(Sqlstr, Field));
}
public System.Data.DataSet Get_DataSet2(string Sqlstr, string dataAccessName)
{
DataAccessCollections dac = new DataAccessCollections();
MyNet.Common.Data.DataAccess dAccess = dac.GetDataAccess(dataAccessName);
return(dAccess.Get_DataSet(Sqlstr));
}
public DataService()
{
DataAccessCollections dac = new DataAccessCollections();
//dataAccess = dac.GetDataAccess(Config.DataAccessName);
dataAccess = GetDataAccess.Init();
}
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));
}
