public static void ExcuteNoneQuery(string sqlString, DataAccessParameterCollection para, CommandType type)
{
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
broker.ExecuteNonQuery(sqlString, para, type);
}
}
public static void ExcuteNoneQuery(string sqlString)
{
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
broker.ExecuteNonQuery(sqlString, null, CommandType.Text);
}
}
public static int ExecuteStoreProcedure(string spName, DataAccessBroker broker)
{
int value = 0;
value = broker.ExecuteNonQuery(spName, null, CommandType.StoredProcedure);
return(value);
}
public static int ExecuteNoneQuery(string sqlString)
{
int value = 0;
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
value = broker.ExecuteNonQuery(sqlString, null, CommandType.Text);
}
return(value);
}
public static int ExecuteStoreProcedure(string spName)
{
int value = 0;
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
value = broker.ExecuteNonQuery(spName, null, CommandType.StoredProcedure);
}
return(value);
}
public static void DeleteAllImportStore(DataAccessBroker broker)
{
string sql = "update store set IS_DELETED='Y' where STORE_TYPE='Import' and IS_DELETED='N'";
broker.ExecuteNonQuery(sql, null, CommandType.Text);
}
public static void ExcuteNoneQuery(string sqlString, DataAccessBroker broker)
{
broker.ExecuteNonQuery(sqlString, null, CommandType.Text);
}
