/// <summary> /// /// </summary> /// <param name="sqlExpression"></param> /// <param name="enumReturn"></param> public override void AddAction(string sqlExpression, EnumDBReturnAccess enumReturn) { #region this.AddAction(sqlExpression, enumReturn, null); #endregion }
/// <summary> /// 添加检索操作,不带过滤条件 /// </summary> /// <param name="sqlExpression"></param> /// <param name="fillDs"></param> public override void AddAction(string sqlExpression, DataSet fillDs, EnumDBReturnAccess enumReturn) { if (enumReturn == EnumDBReturnAccess.ExeNoQuery || enumReturn == EnumDBReturnAccess.SaveDS || enumReturn == EnumDBReturnAccess.Scalar) { ExtConsole.Write("该接口只提供填充数据集的功能!"); return; } Expression sql = this.createSqlAction(); sql.SqlBusiness = sqlExpression; sql.ReturnDS = fillDs; sql.EnumReturn = enumReturn; this._executor.Actions.Add(sql); }
/// <summary> /// /// </summary> /// <param name="sqlExpression"></param> /// <param name="enumReturn"></param> /// <param name="conditions"></param> public override void AddAction(string sqlExpression, EnumDBReturnAccess enumReturn, DBConditions conditions) { #region if (enumReturn == EnumDBReturnAccess.SaveDS || enumReturn == EnumDBReturnAccess.FillDsByCustom || enumReturn == EnumDBReturnAccess.FillDsByStoredProcedure) { ExtConsole.Write("该接口不提供存储数据集或检索数据集功能!"); return; } Expression sql = this.createSqlAction(); sql.SqlBusiness = sqlExpression; sql.EnumReturn = enumReturn; sql.SqlConditions = conditions; this._executor.Actions.Add(sql); #endregion }
/// <summary> /// /// </summary> /// <param name="enumReturn"></param> private void subtractCount(EnumDBReturnAccess enumReturn) { switch (enumReturn) { case EnumDBReturnAccess.ExeNoQuery: case EnumDBReturnAccess.Scalar: this.GeneralCommandCount--; break; case EnumDBReturnAccess.FillDsByCustom: case EnumDBReturnAccess.FillDsByStoredProcedure: case EnumDBReturnAccess.SaveDS: case EnumDBReturnAccess.FillDsWithoutPage: this.AdvanceCommandCount--; break; default: break; } }
/// <summary> /// 获取单表数据集(类内部复用) /// </summary> /// <param name="fillDs">传入的空数据集</param> /// <param name="conditions">查询条件</param> /// <param name="returntype">数据库访问返回类型</param> /// <param name="isCount">是否需要计算记录条数</param> /// <returns>符合where条件的记录条数(去除分页)</returns> protected int getCustomDs(DataSet fillDs, DBConditions conditions, EnumDBReturnAccess returntype, bool isCount) { #region IDBAccess dbaccess = new DBAccess(); int rowscount = 0; try { string tablename = (fillDs.Tables.Count > 0) ? fillDs.Tables[0].TableName : "tablename"; string sqlformat = "select {0} from [{1}]"; //this.setConnectString(dbaccess); dbaccess.AddAction(string.Format(sqlformat, "*", tablename), conditions, fillDs, returntype); if (isCount) { dbaccess.AddAction(string.Format(sqlformat, "count(*)", tablename), EnumDBReturnAccess.Scalar, conditions); } dbaccess.StartActions(); if (isCount) { rowscount = Convert.ToInt32(dbaccess.Actions[1].ReturnValue); } dbaccess.ClearActions(); return(rowscount); } finally { dbaccess.Dispose(); } #endregion }
/// <summary> /// 添加检索操作,不带过滤条件 /// </summary> /// <param name="sqlExpression"></param> /// <param name="fillDs"></param> /// <param name="enumReturn"></param> public abstract void AddAction(string sqlExpression, DataSet fillDs, EnumDBReturnAccess enumReturn);
/// <summary> /// 添加update、insert、delete操作,带过滤条件 /// </summary> /// <param name="sqlExpression"></param> /// <param name="enumReturn"></param> /// <param name="conditions"></param> public abstract void AddAction(string sqlExpression, EnumDBReturnAccess enumReturn, DBConditions conditions);