/// <summary> /// 执行存储过程 返回ID号 主要用于新增 /// </summary> /// <param name="iOperateFlag"></param> /// <returns></returns> public long ExecNonQuery(int iOperateFlag) { SqlParameterCollection sqlpc = InitCmd(iOperateFlag); int rowsAffected; return(DbHelperSQLYYS.RunProcedure(proceName, sqlpc, out rowsAffected)); }
/// <summary> /// 返回Table /// </summary> /// <returns>获取查询表</returns> public DataTable ExecDT(int iOperateFlag) { SqlParameterCollection sqlpc = InitCmd(iOperateFlag); DataTable dt = new DataTable(); dt = DbHelperSQLYYS.RunProcedure(this.proceName, sqlpc, this.proceName).Tables[0]; return(dt); }
/// <summary> /// 获取分页数据 /// </summary> /// <param name="PageIndex">页码</param> /// <param name="strWhere">查询条件</param> /// <param name="orderBy">排序字段</param> /// <param name="order">排序顺序</param> /// <param name="orderType">升序、降序,默认降序</param> /// <returns></returns> public DataSet XCXGetDataList(int PageSize, int PageIndex, string orderBy, string order, string strWhere, int isAllData) { SqlParameter[] parameters = { new SqlParameter("@pageSize", PageSize), new SqlParameter("@currPage", PageIndex), new SqlParameter("@orderBy", orderBy), new SqlParameter("@order", order), new SqlParameter("@filter", strWhere), new SqlParameter("@isAllData", isAllData), }; return(DbHelperSQLYYS.RunProcedure("sp_S_EmbodyContactPage", parameters, "data")); }
/// <summary> /// 得到一个实体 /// </summary> public void ExecuteEL(int iOperateFlag) { SqlParameterCollection sqlpc = InitCmd(iOperateFlag); DataTable dt = new DataTable(); dt = DbHelperSQLYYS.RunProcedure(this.proceName, sqlpc, this.proceName).Tables[0]; if (dt.Rows.Count > 0) { InitByRow(dt.Rows[0]); } else { m_ID = 0; } }
/// <summary> /// 获取分页数据 /// </summary> /// <param name="PageIndex">页码</param> /// <param name="strWhere">查询条件</param> /// <param name="strOrder">排序字段</param> /// <param name="orderType">升序、降序,默认降序</param> /// <returns></returns> public DataSet GetPageList(string strTableName, int PageIndex, string strWhere, string strOrder, OrderType orderType = OrderType.desc) { SqlParameter[] parameters = { new SqlParameter("@tblName", SqlDbType.VarChar, 255), new SqlParameter("@fldName", SqlDbType.VarChar, 255), new SqlParameter("@OrderfldName", SqlDbType.VarChar, 255), new SqlParameter("@PageSize", SqlDbType.Int), new SqlParameter("@PageIndex", SqlDbType.Int), new SqlParameter("@IsReCount", SqlDbType.Bit), new SqlParameter("@OrderType", SqlDbType.Bit), new SqlParameter("@strWhere", SqlDbType.VarChar, 1000) }; parameters[0].Value = strTableName; parameters[1].Value = "*";//根据实际情况进行修正 parameters[2].Value = strOrder; parameters[3].Value = PagerInfo.PageSize; parameters[4].Value = PageIndex; parameters[5].Value = 1; parameters[6].Value = (int)orderType; parameters[7].Value = strWhere; return(DbHelperSQLYYS.RunProcedure("UP_GetRecordByPageOrder", parameters, "dspage")); }
/// <summary> /// ExecuteSqlString /// </summary> /// <returns>根据查询语言获取数据集</returns> public DataTable ExecuteSqlString(string SqlString) { return(DbHelperSQLYYS.Query(SqlString).Tables[0]); }