/// <summary>
/// get datatable
/// </summary>
/// <param name="sqlparm"></param>
/// <returns></returns>
public static DataTable GetDataTable(xsSqlParameter sqlparm)
{
DataSet ds = GetDataSet(sqlparm);
if (ds.Tables.Count > 0)
{
return(ds.Tables[0]);
}
else
{
return(new DataTable());
}
}
/// <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);
}
/// <summary>
/// exist data
/// </summary>
/// <param name="sqlparm">exist:true,else:false</param>
/// <returns></returns>
public static bool Exist(xsSqlParameter sqlparm)
{
return(GetDataTable(sqlparm).Rows.Count > 0);
}
