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); }