public static DbOutParameter ExecuteSP(xsSpParameter spPara)
{
DbInParameter dbInPara = new DbInParameter();
DbOutParameter dbOutPara = new DbOutParameter();
dbInPara.StoreProcureName = spPara.SPName; //set sp name
dbInPara.IsReturnDataSet = spPara.IsReturnDataSet; //set sp return
dbInPara.AddParameter(spPara.SpParameters); //set spparameter
DbAccess Dao = new DbAccess();
Dao.Open(spPara.SqlConnectString);
dbOutPara = Dao.ExecProcedure(dbInPara);
Dao.Close();
return(dbOutPara);
}
/// <summary>
/// execute sql
/// </summary>
/// <param name="sqlparm"></param>
/// <returns></returns>
public static void Execute(xsSqlParameter sqlparm)
{
DbInParameter dbInPara = new DbInParameter();
dbInPara.SQL = sqlparm.SQL;
//add sql parameter
dbInPara.AddParameter(sqlparm.SqlPara);
DbAccess Dao = new DbAccess();
Dao.Open(sqlparm.SqlConnectString);
Dao.BeginTrans();
Dao.ExecuteNoQuery(dbInPara);
Dao.Commit();
Dao.Close();
}
/// <summary>
/// get dataset
/// </summary>
/// <param name="strsql">sql string</param>
/// <param name="SqlPara">parameter</param>
/// <returns></returns>
public static DataSet GetDataSet(xsSqlParameter sqlparm)
{
DbInParameter dbInPara = new DbInParameter();
dbInPara.SQL = sqlparm.SQL;
//add sql parameter
dbInPara.AddParameter(sqlparm.SqlPara);
DbAccess Dao = new DbAccess();
Dao.Open(sqlparm.SqlConnectString);
DataSet dsRtn = Dao.ExecuteQuery(dbInPara).ReturnDataSet;
Dao.Close();
return(dsRtn);
}