public static void ExcuteNoneQuery(string sqlString) { using (DataAccessBroker broker = DataAccessFactory.Instance()) { broker.ExecuteNonQuery(sqlString, null, CommandType.Text); } }
public static void ExcuteNoneQuery(string sqlString, DataAccessParameterCollection para, CommandType type) { using (DataAccessBroker broker = DataAccessFactory.Instance()) { broker.ExecuteNonQuery(sqlString, para, type); } }
/// <summary> /// 根据状态保存-独立事务 /// </summary> /// <param name="entity"></param> public static void Save(EntityBase entity) { using (DataAccessBroker broker = DataAccessFactory.Instance()) { Save(entity, broker); } }
public static Dictionary <string, object> ExecuteStoreProcedure(string spName, DataAccessParameterCollection parameters) { using (DataAccessBroker broker = DataAccessFactory.Instance()) { return(broker.ExecuteProcReturnOutput(spName, parameters)); } }
public static PerformanceEntityCollection <T> PerformanceSelect <T>(string queryString, DataAccessParameterCollection parameters, CommandType cmdType) where T : EntityBase, new() { PerformanceEntityCollection <T> result = null; using (DataAccessBroker broker = DataAccessFactory.Instance()) { IDataReader reader = broker.ExecuteReader(queryString, parameters, cmdType); int fieldCount = reader.FieldCount; List <string> columns = new List <string>(); object[] values = new object[fieldCount]; for (int i = 0; i < fieldCount; i++) { columns.Add(reader.GetName(i)); } result = new PerformanceEntityCollection <T>(columns); while (reader.Read()) { reader.GetValues(values); result.Add(values); } reader.Dispose(); } return(result); }
/// <summary> /// 批量新增-独立事务 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="list"></param> public static bool Insert <T>(List <T> list) where T : EntityBase { DataAccessBroker broker = DataAccessFactory.Instance(); bool result = true; try { broker.BeginTransaction(); Insert(list, broker); broker.Commit(); } catch (Exception ex) { result = false; broker.RollBack(); throw ex; } finally { broker.Close(); } return(result); }
/// <summary> /// 获取数据通过Command /// </summary> /// <typeparam name="T"></typeparam> /// <param name="command">SQL</param> /// <returns></returns> public static EntityCollection <T> Select <T>(string queryString, DataAccessParameterCollection parameters, CommandType cmdType) where T : EntityBase, new() { EntityCollection <T> result = new EntityCollection <T>(); using (DataAccessBroker broker = DataAccessFactory.Instance()) { IDataReader reader = broker.ExecuteReader(queryString, parameters, cmdType); int fieldCount = reader.FieldCount; List <string> columns = new List <string>(); object[] values = new object[fieldCount]; for (int i = 0; i < fieldCount; i++) { columns.Add(reader.GetName(i)); } while (reader.Read()) { T t = new T(); reader.GetValues(values); for (int i = 0; i < fieldCount; i++) { if (!(values[i] == DBNull.Value)) { t.SetData(columns[i], values[i]); t.GetData(columns[i]); } } result.Add(t); } } return(result); }
public static object SelectScalar(string sqlString, DataAccessParameterCollection paraCollection) { using (DataAccessBroker broker = DataAccessFactory.Instance()) { return(broker.ExecuteScalar(sqlString, paraCollection, CommandType.Text)); } }
/// <summary> /// 批量新增-独立事务 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="list"></param> /// Jerry 2009年3月23日 老刘修改了此方法 只Creat一次Command 减少内存的损耗 修改后方法见下方395行开始 //public static bool Insert<T>(List<T> list) // where T : EntityBase //{ // DataAccessBroker broker = DataAccessFactory.Instance(); // bool result = true; // try // { // broker.BeginTransaction(); // Insert(list, broker); // broker.Commit(); // } // catch // { // result = false; // broker.RollBack(); // } // finally // { // broker.Close(); // } // return result; //} public static bool Insert <T>(List <T> list) where T : EntityBase { DataAccessBroker broker = DataAccessFactory.Instance(); bool result = true; try { if (list != null && list.Count > 0) { broker.BeginTransaction(); T t = list[0]; //string sqlString = "INSERT INTO " + t.OringTableSchema.TableName + " ( " + ParseInsertSQL(t.OringTableSchema.AllColumnInfo, "") + " ) VALUES( " + ParseInsertSQL(t.OringTableSchema.AllColumnInfo, broker.ParameterPrefix) + ")"; //broker.CreateCommandE(sqlString); foreach (T entity in list) { Insert(entity, broker); } broker.Commit(); } } catch (Exception ex) { result = false; broker.RollBack(); throw ex; } finally { broker.Close(); broker.Dispose(); } return(result); }
public static int ExecuteStoreProcedureHasReturn(string spName, DataAccessParameterCollection parameters) { using (DataAccessBroker broker = DataAccessFactory.Instance()) { var rowsaffected = broker.ExecuteCommand(spName, parameters); return(1); } }
public static void DeleteAll <T>() where T : EntityBase, new () { using (DataAccessBroker broker = DataAccessFactory.Instance(InstanceName)) { T t = new T(); broker.ExecuteSQL("delete from " + t.OringTableSchema.TableName); } }
public static string SelectScalar(string sqlString) { object value = null; using (DataAccessBroker broker = DataAccessFactory.Instance()) { value = broker.ExecuteSQLScalar(sqlString); } return(value == null ? null : value.ToString()); }
public static DataSet Select(string queryString, string instanceName, DataAccessParameterCollection parameters) { DataSet ds = null; using (DataAccessBroker broker = DataAccessFactory.Instance(instanceName)) { ds = broker.FillSQLDataSet(queryString, parameters); } return(ds); }
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 int ExecuteNoneQuery(string sqlString) { int value = 0; using (DataAccessBroker broker = DataAccessFactory.Instance()) { value = broker.ExecuteNonQuery(sqlString, null, CommandType.Text); } return(value); }
/// <summary> /// ExecuteScalar 并返还回唯一值 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="wb"></param> /// <param name="defaultValue"></param> /// <returns></returns> public static T ExecuteScalar <T>(WhereBuilder wb, T defaultValue) { using (DataAccessBroker broker = DataAccessFactory.Instance()) { object result = broker.ExecuteScalar(wb); if (result != null && result != DBNull.Value) { defaultValue = (T)result; } } return(defaultValue); }
public static Dictionary <string, object> ExecuteProcReturnOutput(string commandString, DataAccessParameter[] dps) { using (DataAccessBroker broker = DataAccessFactory.Instance()) { DataAccessParameterCollection dpc = new DataAccessParameterCollection(); if (dps != null && dps.Length > 0) { foreach (DataAccessParameter dp in dps) { dpc.Add(dp.ParameterName, dp); } } return(broker.ExecuteProcReturnOutput(commandString, dpc)); } }
/// <summary> /// 新增-独立事务 /// </summary> /// <param name="entity"></param> public static bool Insert(EntityBase entity) { bool result = true; //try //{ using (DataAccessBroker broker = DataAccessFactory.Instance()) { Insert(entity, broker); } //} //catch //{ // result = false; //} return(result); }
public static List <T> SelectSingleValue <T>(string queryString) { List <T> result = new List <T>(); using (DataAccessBroker broker = DataAccessFactory.Instance(InstanceName)) { IDataReader reader = broker.ExecuteReader(queryString, new DataAccessParameterCollection(), CommandType.Text); while (reader.Read()) { T tmp = (T)reader.GetValue(0); result.Add(tmp); } } return(result); }
/// <summary> /// 更新-独立事务 /// </summary> /// <param name="entity"></param> /// <returns></returns> public static bool Update(EntityBase entity) { bool result = true; try { using (DataAccessBroker broker = DataAccessFactory.Instance()) { Update(entity, broker); } } catch (Exception ex) { result = false; } return(result); }
/// <summary> /// 删除-独立事务-根据所有非空字段AND条件删除 /// </summary> /// <param name="entity"></param> public static bool DeleteEntity(EntityBase entity) { bool result = true; try { using (DataAccessBroker broker = DataAccessFactory.Instance()) { DeleteEntity(entity, broker); } } catch { result = false; } return(result); }
/// <summary> /// 批量保存-独立事务 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="list"></param> public static bool Save <T>(List <T> list) where T : EntityBase { DataAccessBroker broker = DataAccessFactory.Instance(InstanceName); bool result = true; try { broker.BeginTransaction(); Save <T>(list, broker); broker.Commit(); } catch { result = false; broker.RollBack(); } finally { broker.Close(); } return(result); }
public static bool UpdateAndSave <T>(IEnumerable <T> list) where T : EntityBase, new() { DataAccessBroker broker = DataAccessFactory.Instance(); bool result = true; try { broker.BeginTransaction(); UpdateAndSave <T>(list, broker); broker.Commit(); } catch (Exception ex) { result = false; broker.RollBack(); throw ex; } finally { broker.Close(); } return(result); }
/// <summary> /// 获取数据通过Command /// </summary> /// <typeparam name="T"></typeparam> /// <param name="command">SQL</param> /// <returns></returns> public static EntityCollection <T> Select <T>(string queryString, DataAccessParameterCollection parameters, CommandType cmdType) where T : EntityBase, new() { EntityCollection <T> result = new EntityCollection <T>(); using (DataAccessBroker broker = DataAccessFactory.Instance()) { IDataReader reader = broker.ExecuteReader(queryString, parameters, cmdType); int fieldCount = reader.FieldCount; List <string> columns = new List <string>(); Dictionary <string, Type> columnType = new Dictionary <string, Type>(); Dictionary <string, string> nameChange = new Dictionary <string, string>(); T col = new T(); object[] values = new object[fieldCount]; for (int i = 0; i < fieldCount; i++) { columns.Add(reader.GetName(i)); for (int m = 0; m < col.OringTableSchema.AllColumnInfo.Count; m++) { if (col.OringTableSchema.AllColumnInfo[m].ColumnName.ToUpper() == reader.GetName(i).ToUpper()) { columnType.Add(reader.GetName(i), col.OringTableSchema.AllColumnInfo[m].DataType); nameChange.Add(reader.GetName(i), col.OringTableSchema.AllColumnInfo[m].ColumnName); } } } while (reader.Read()) { T t = new T(); reader.GetValues(values); for (int i = 0; i < fieldCount; i++) { if (!(values[i] == DBNull.Value)) { if (!columnType.ContainsKey(columns[i])) { continue; } if (values[i].GetType() == columnType[columns[i]]) { t.SetData(nameChange[columns[i]], values[i]); } else { if (columnType[columns[i]] == Type.GetType("System.Int32")) { t.SetData(nameChange[columns[i]], int.Parse(values[i].ToString())); } else if (columnType[columns[i]] == Type.GetType("System.Boolean")) { if (values[i].ToString() == "0") { t.SetData(nameChange[columns[i]], false); } else { t.SetData(nameChange[columns[i]], true); } } else if (columnType[columns[i]] == Type.GetType("System.DateTime")) { t.SetData(nameChange[columns[i]], values[i].ToString()); } else if (columnType[columns[i]] == Type.GetType("System.Decimal")) { t.SetData(nameChange[columns[i]], values[i].ToString()); } else { t.SetData(nameChange[columns[i]], values[i]); } } } } result.Add(t); } reader.Dispose(); } return(result); }