/// <summary> /// 查询分站信息 /// </summary> /// <param name="selectModel">查询模式 0传输分站 1读卡分站 2为全部传输分站 </param> /// <param name="strWhere">查询条件</param> /// <returns>数据集</returns> public DataSet SelectStationConfigInfo(int selectModel, string strWhere) { SqlParameter[] para = { new SqlParameter("@selectModel", SqlDbType.Int), new SqlParameter("@strWhere", SqlDbType.VarChar, 1000) }; para[0].Value = selectModel; para[1].Value = strWhere; //Czlt-2011-11-22 交直流供电 DataSet ds = new DataSet(); if (selectModel.ToString().Trim().Equals("0")) { ds = dba.ExecuteSqlDataSet("proc_Czlt_TcpStationMode", para); } else { ds = dba.ExecuteSqlDataSet("selectStationConfigInfo", para); } //Czlt-2011-11-22注销 //DataSet ds = dba.ExecuteSqlDataSet("selectStationConfigInfo", para); return(ds); }
public DataSet getKJ128N_CodeSender_Info_Table(int pageIndex, int pageSize, string strWhere) { SqlParameter[] para = { new SqlParameter("@tblName", SqlDbType.VarChar, 255), new SqlParameter("@keyField", SqlDbType.VarChar, 255), new SqlParameter("@fieldList", SqlDbType.VarChar, 2000), new SqlParameter("@orderField", SqlDbType.VarChar, 255), new SqlParameter("@PageIndex", SqlDbType.Int), new SqlParameter("@PageSize", SqlDbType.Int), new SqlParameter("@strWhere", SqlDbType.VarChar, 8000), new SqlParameter("@orderType", SqlDbType.Bit) }; para[0].Value = "KJ128N_CodeSender_Info_Table"; para[1].Value = "发码器地址"; para[2].Value = "*"; para[3].Value = "发码器地址"; para[4].Value = pageIndex; para[5].Value = pageSize; if (strWhere == "") { strWhere = "1=1"; } para[6].Value = strWhere; para[7].Value = 0; return(dba.ExecuteSqlDataSet("GetPagingRecord", para)); }
public DataSet getStationHeadInfo(int pageIndex, int pageSize) { SqlParameter[] para = { new SqlParameter("@pageIndex", SqlDbType.Int), new SqlParameter("@pageSize", SqlDbType.Int) }; para[0].Value = pageIndex; para[1].Value = pageSize; return(dba.ExecuteSqlDataSet("PROC_GetStation_Info", para)); }
public DataSet GetHisInOutMineSet(string where) { SqlParameter[] para = { new SqlParameter("@strWhere", SqlDbType.VarChar, 1000) }; para[0].Value = where; return(dbacc.ExecuteSqlDataSet("zjw_HisInOutMine_Select", para)); }
public DataSet GetInfo_HisTerritorial_Emp(int pageIndex, int pageSize, string where, string TableName, string TableName2) { SqlParameter[] para = { new SqlParameter("@tblName", SqlDbType.VarChar, 255), new SqlParameter("@tblName2", SqlDbType.VarChar, 255), new SqlParameter("@fldName", 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) }; para[0].Value = "His_InOutTerritorial_" + TableName; para[1].Value = "His_InOutTerritorial_" + TableName2; para[2].Value = "HisTerritorialID"; para[3].Value = pageSize; para[4].Value = pageIndex; para[5].Value = 1; para[6].Value = 0; para[7].Value = where; //para[6].Value = "1=1"; using (ds = new DataSet()) { ds = dba.ExecuteSqlDataSet("Shine_InOutMine_ByPage", para); return(ds); } //SqlParameter[] para = { new SqlParameter("@tblName",SqlDbType.VarChar,255), // new SqlParameter("@fldName",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) //}; //para[0].Value = "His_InOutTerritorial_" + TableName; //para[1].Value = "HisTerritorialID";zai //para[2].Value = pageSize; //para[3].Value = pageIndex; //para[4].Value = 1; //para[5].Value = 0; //para[6].Value = where; //using (ds = new DataSet()) //{ // ds = dba.ExecuteSqlDataSet("Shine_GetRecordByPage", para); // ////string sql = "select count(DISTINCT 标识卡号) from A_His_Territorial_Emp Where" + where; // //string s = dba.ExecuteScalarSql(sql); // //DataTable dt = new DataTable("TabCount"); // //dt.Columns.Add("Counts"); // //DataRow dr = dt.NewRow(); // //dr["Counts"] = s; // //dt.Rows.Add(dr); // //ds.Tables.Add(dt); // return ds; //} }
public DataSet dataGrid_renyuan_bind(int depid) { SqlParameter[] sqlpara = new SqlParameter[] { new SqlParameter("@depid", SqlDbType.Int, 4) }; sqlpara[0].Value = depid; return(dba.ExecuteSqlDataSet("proc_select_emp_by_txj", sqlpara)); }
public DataSet GetInfo_HisStationHead_Emp(string where, string tablename, string tablename2) { SqlParameter[] para = { new SqlParameter("@tblName", SqlDbType.VarChar, 255), new SqlParameter("@tblName2", SqlDbType.VarChar, 255), new SqlParameter("@strWhere", SqlDbType.VarChar, 1000) }; para[0].Value = tablename; para[1].Value = tablename2; para[2].Value = where; try { //ds = dba.ExecuteSqlDataSet("Shine_GetRecordByPageNew", para); ds = dba.ExecuteSqlDataSet("Shine_GetRecordByPageNew", para); if (ds != null && ds.Tables.Count > 0) { DataTable dt = ds.Tables[0]; dt.Columns.Add("持续时长"); for (int i = 0; i < dt.Rows.Count; i++) { if (DateTime.Parse(dt.Rows[i]["进入时间"].ToString()) < DateTime.Parse(dt.Rows[i]["离开时间"].ToString())) { DateTime intime = DateTime.Parse(dt.Rows[i]["进入时间"].ToString()); DateTime outtime = DateTime.Parse(dt.Rows[i]["离开时间"].ToString()); int time = int.Parse(dt.Rows[i]["持续时间"].ToString()); if (time > 0) { int hour = time / 3600; time = time % 3600; int min = time / 60; time = time % 60; dt.Rows[i]["持续时长"] = hour.ToString() + "时" + min.ToString() + "分" + time.ToString() + "秒"; } else { dt.Rows[i]["持续时长"] = "——"; } } } dt.Columns.Remove("持续时间"); return(ds); } else { return(new DataSet()); } return(ds); } catch (Exception ex) { return(new DataSet()); } }
public DataSet GetHisInTerInfoSet(int pageIndex, int pageSize, string where, bool blIsEmp) { SqlParameter[] para = { new SqlParameter("@tblName", SqlDbType.VarChar, 255), new SqlParameter("@fldName", 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) }; if (blIsEmp) { para[0].Value = "KJ128N_HisInTer_Emp_Info"; } else { para[0].Value = "KJ128N_HisInTer_Equ_Info"; } para[1].Value = "HisTerritorialID"; para[2].Value = pageSize; para[3].Value = pageIndex; para[4].Value = 1; para[5].Value = 0; para[6].Value = where; return(dbacc.ExecuteSqlDataSet("Shine_GetRecordByPage", para)); }
public DataSet GetInfo_HisPath(int pageIndex, int pageSize, string where) { SqlParameter[] para = { new SqlParameter("@tblName", SqlDbType.VarChar, 255), new SqlParameter("@fldName", 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) }; para[0].Value = "A_His_Path"; para[1].Value = "HisPathID"; para[2].Value = pageSize; para[3].Value = pageIndex; para[4].Value = 1; para[5].Value = 0; para[6].Value = where; using (ds = new DataSet()) { ds = dba.ExecuteSqlDataSet("Shine_GetRecordByPage", para); string sql = "select count(DISTINCT 标识卡号) from A_His_Path Where" + where; string s = dba.ExecuteScalarSql(sql); DataTable dt = new DataTable("TabCount"); dt.Columns.Add("Counts"); DataRow dr = dt.NewRow(); dr["Counts"] = s; dt.Rows.Add(dr); ds.Tables.Add(dt); return(ds); } }
public DataSet GetHisOverEmpAll(int pageIndex, int pageSize, string where) { if (where == string.Empty) { where = "1=1"; } SqlParameter[] para = { new SqlParameter("@tblName", SqlDbType.VarChar, 255), new SqlParameter("@keyField", SqlDbType.VarChar, 255), new SqlParameter("@fieldList", SqlDbType.VarChar, 2000), new SqlParameter("@orderField", SqlDbType.VarChar, 255), new SqlParameter("@PageIndex", SqlDbType.Int), new SqlParameter("@PageSize", SqlDbType.Int, 20), new SqlParameter("@strWhere", SqlDbType.VarChar, 8000), new SqlParameter("@orderType", SqlDbType.Bit) }; para[0].Value = "View_His_OverEmployees"; para[1].Value = "His_OverEmployeeID"; para[2].Value = "His_RatingEmployeesCount as 额定超员人数,His_FactEmployeeCount as 超员最高人数," + "His_OverEmpCount as 超员人数,His_OverEmployeeBeginTime as 超员开始时间," + "His_OverEmployeeEndTime as 超员结束时间,OverEmpAbidanceTime as 超员时间"; para[3].Value = "His_OverEmployeeBeginTime"; para[4].Value = pageIndex; para[5].Value = pageSize; para[6].Value = where; para[7].Value = 0; return(dba.ExecuteSqlDataSet("GetPagingRecord", para)); }
public DataSet CzltGetMonth(DateTime beginTime, DateTime endTime, string strDeptWhere, string strDutyClassWhere, string strTime) { #region 【Czlt-2010-9-21-注销】 //SqlParameter[] para = { new SqlParameter("@strTable",SqlDbType.NVarChar,20) //}; //para[0].Value = beginTime.ToString("yyyyM"); //DataSet ds = dba.ExecuteSqlDataSet("leadMonthStatement", para); //return ds; #endregion //Czlt-2010-9-21 添加领导干部月下井统计排序 string strWhere = strDeptWhere + " " + strDutyClassWhere; SqlParameter[] para = { new SqlParameter("@BeginTime", SqlDbType.VarChar, 20), new SqlParameter("@EndTime", SqlDbType.VarChar, 20), new SqlParameter("@strWhere", SqlDbType.VarChar, 500), new SqlParameter("@strTime", SqlDbType.VarChar, 100) }; para[0].Value = beginTime; para[1].Value = endTime; para[2].Value = strWhere;// HisStationHeadID //进入分站的时间Czlt-2011-06-05 para[3].Value = strTime; //string sql = "select 标识卡,人员姓名,职务,工种,部门,下井次数,下井总时长,平均时长 from (select distinct CodeSenderAddress as 标识卡,hiom.UserNo as 人员编号 ,UserName as 人员姓名,ei.DutyName as 职务,ei.WorkTypeName as 工种,hiom.DeptName as 部门,(select count(hiom1.UserID) from His_InOutMine_" + time + " as hiom1 where hiom1.UserID=hiom.UserID ) as 下井次数,dbo.FunConvertTime((select sum(ContinueTime) from His_InOutMine_" + time + " as hiom2 where hiom2.UserID=hiom.UserID )) as 下井总时长,dbo.FunConvertTime(((select sum(ContinueTime) from His_InOutMine_" + time + " as hiom2 where hiom2.UserID=hiom.UserID )/(select count(hiom1.UserID) from His_InOutMine_" + time + " as hiom1 where hiom1.UserID=hiom.UserID ))) as 平均时长,DutyClassID from His_InOutMine_" + time + " as hiom join Emp_Info as ei on hiom.UserID =ei.EmpID join Duty_Info as dui on dui.DutyID = ei.DutyID where 1=1 " + strDeptWhere + " " + strDutyClassWhere + ") h order by 标识卡 "; DataSet ds = dba.ExecuteSqlDataSet("Czlt_leadMonthStatement", para); return(ds); }
public DataSet StatMonthEmp(string strYear, int index, int size, string strWhere, string isLead) { SqlParameter[] arrParm = { new SqlParameter("@year", SqlDbType.Int), new SqlParameter("@PageIndex", SqlDbType.Int), new SqlParameter("@PageSize", SqlDbType.Int), new SqlParameter("@strwhere", SqlDbType.VarChar,2000), new SqlParameter("@IsLead", SqlDbType.Int) }; arrParm[0].Value = strYear; arrParm[1].Value = index; arrParm[2].Value = size; arrParm[3].Value = strWhere; arrParm[4].Value = isLead; return(dba.ExecuteSqlDataSet("Shine_djc_StatMonthEmp", arrParm)); }
public DataSet GetInOutStationHeadSet(int pageIndex, int pageSize, string where) { SqlParameter[] para = { new SqlParameter("@tblName", SqlDbType.VarChar, 255), new SqlParameter("@fldName", 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) }; para[0].Value = "KJ128N_HisInOutStationHead_Info_View"; para[1].Value = "HisStationHeadID"; para[2].Value = pageSize; para[3].Value = pageIndex; para[4].Value = 1; para[5].Value = 0; para[6].Value = where; return(dbacc.ExecuteSqlDataSet("Shine_GetRecordByPage", para)); }
//int pageIndex,int pageSize,string where//View_GetRTDeptInfo //public DataSet GetEmpInfo(SqlParameter[] para) //{ // return dba.ExecuteSqlDataSet("Shine_GetRecordByPage", para); //} public DataSet GetEmpInfo(int pageIndex, int pageSize, string where) { SqlParameter[] para = { new SqlParameter("@tblName", SqlDbType.VarChar, 255), new SqlParameter("@fldName", 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) }; para[0].Value = "A_KJ128N_Emp_Table"; para[1].Value = "编号"; para[2].Value = pageSize; para[3].Value = pageIndex; para[4].Value = 1; para[5].Value = 0; para[6].Value = where; return(dba.ExecuteSqlDataSet("Shine_GetRecordByPage", para)); }
/// <summary> /// 显示交接班配置信息 /// </summary> /// <param name="pageIndex">页索引</param> /// <param name="pageSize">每页显示个数</param> /// <param name="strWhere">查询添加</param> /// <returns>返回记录集</returns> public DataSet getAssociateConfig(int pageIndex, int pageSize, string strWhere) { SqlParameter[] para = { new SqlParameter("@tblName", SqlDbType.VarChar, 255), new SqlParameter("@fldName", 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) }; para[0].Value = "AssociateConfigView"; para[1].Value = "id"; para[2].Value = pageSize; para[3].Value = pageIndex; para[4].Value = 1; para[5].Value = 0; para[6].Value = strWhere; return(dba.ExecuteSqlDataSet("Shine_GetRecordByPage", para)); }
public DataSet InfoClass_Query(string strWhere) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@strWhere", SqlDbType.VarChar, 1000) }; parameters[0].Value = strWhere; return(DB.ExecuteSqlDataSet("Shine_InfoClass_Query", parameters)); }
public DataSet DeleteSql() { SqlParameter[] sqlParmeters = { new SqlParameter("@datetimeValue", SqlDbType.DateTime) }; sqlParmeters[0].Value = DateTime.Now; DataSet ds = dba.ExecuteSqlDataSet("dropHisTable", sqlParmeters); return(ds); }
public DataSet HolidayType_Query(string strWhere) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@strWhere", SqlDbType.VarChar, 200), }; parameters[0].Value = strWhere; return(DB.ExecuteSqlDataSet("Shine_HolidayType_Query", parameters)); }
public DataSet TaskTime_Query(string strWhere) { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("", SqlDbType.VarChar, 200) }; parameter[0].Value = strWhere; return(DB.ExecuteSqlDataSet("Shine_TastTime_Query", parameter)); }
/// <summary> /// 特殊人员作业报警总数及时间统计信息 /// </summary> /// <param name="beginTime">开始时间</param> /// <param name="endTime">结束时间</param> /// <returns>数据集</returns> public DataSet SelectWorkExceptionStatementInfo(DateTime beginTime, DateTime endTime) { SqlParameter[] para = { new SqlParameter("@beginTime", SqlDbType.DateTime), new SqlParameter("@endTime", SqlDbType.DateTime) }; para[0].Value = beginTime; para[1].Value = endTime; DataSet ds = dba.ExecuteSqlDataSet("workExceptionStatement", para); return(ds); }
/// <summary> /// 获取日下井路线报表信息 /// </summary> /// <param name="pageIndex">页索引</param> /// <param name="pageSize">页大小</param> /// <param name="where">查询条件</param> /// <returns>数据集</returns> public DataSet SelectInMineDayReportInfo(int pageIndex, int pageSize, string where) { SqlParameter[] para = { new SqlParameter("@tblName", SqlDbType.VarChar, 255), new SqlParameter("@fldName", 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) }; para[0].Value = "A_His_Territorial_Equ"; para[1].Value = "HisTerritorialID"; para[2].Value = pageSize; para[3].Value = pageIndex; para[4].Value = 1; para[5].Value = 0; para[6].Value = where; DataSet ds = dba.ExecuteSqlDataSet("Shine_GetRecordByPage", para); return(ds); }
/// <summary> /// 查询 /// </summary> /// <param name="strEquName">设备名称</param> /// <param name="strFactoryID">生产厂家</param> /// <returns></returns> public DataSet Equ_Query(string strEquName, string strFactoryID) { string strProcName = "KJ128N_Equ_Query"; SqlParameter[] sqlPar = { new SqlParameter("strEquWhere", DbType.String), new SqlParameter("strFactroyWhere", DbType.String) }; sqlPar[0].Value = strEquName; sqlPar[1].Value = strFactoryID; return(dba.ExecuteSqlDataSet(strProcName, sqlPar)); }
public DataSet GetInfo_HisInWellCounts(int pageIndex, int pageSize, string where, string strDateTime, string TableName, string TableName2) { SqlParameter[] para = { new SqlParameter("@PageSize", SqlDbType.Int), new SqlParameter("@PageIndex", SqlDbType.Int), new SqlParameter("@strWhere", SqlDbType.VarChar,1000), new SqlParameter("@strDateTime", SqlDbType.VarChar, 600), new SqlParameter("@strTable", SqlDbType.VarChar, 30), new SqlParameter("@strTable2", SqlDbType.VarChar, 30) }; para[0].Value = pageSize; para[1].Value = pageIndex; para[2].Value = where; para[3].Value = strDateTime; para[4].Value = TableName; para[5].Value = TableName2; return(dba.ExecuteSqlDataSet("A_EmpInWellCount_Select", para)); }
/// <summary> /// 实时下井信息 /// </summary> /// <param name="pageIndex">页索引</param> /// <param name="pageSize">页总数</param> /// <param name="where">查询条件</param> /// <returns></returns> public DataSet GetRealTimeInWell(int pageIndex, int pageSize, string where) { SqlParameter[] para = { new SqlParameter("@tblName", SqlDbType.VarChar, 255), new SqlParameter("@fldName", 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) }; para[0].Value = "View_RealTimeInWell"; para[1].Value = "CodeSenderAddress"; para[2].Value = pageSize; para[3].Value = pageIndex; para[4].Value = 1; para[5].Value = 0; para[6].Value = where; return(dba.ExecuteSqlDataSet("Shine_GetRecordByPage", para)); }
public DataSet HolidayManage_Query(int intPageIndex, int intPageSize, string strWhere, string strTableName, string strTableName2) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@PageIndex", SqlDbType.Int, 4), new SqlParameter("@PageSize", SqlDbType.Int, 4), new SqlParameter("@strWhere", SqlDbType.VarChar, 300), new SqlParameter("@tableName", SqlDbType.VarChar, 20), new SqlParameter("@tableName2", SqlDbType.VarChar, 20) }; parameters[0].Value = intPageIndex; parameters[1].Value = intPageSize; parameters[2].Value = strWhere; parameters[3].Value = strTableName; parameters[4].Value = strTableName2; return(DB.ExecuteSqlDataSet("Shine_HistoryHolidays_Query", parameters)); }
/// <summary> /// 历史天线信息 /// </summary> /// <param name="pageIndex">页索引</param> /// <param name="pageSize">页总数</param> /// <param name="where">查询条件</param> /// <returns></returns> public DataSet GetHisantennaInfoByCodeSenderAddress(int pageIndex, int pageSize, string where) { SqlParameter[] para = { new SqlParameter("@tblName", SqlDbType.VarChar, 255), new SqlParameter("@fldName", 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) }; para[0].Value = "A_His_InOutStationView1"; para[1].Value = "HisInStationID"; para[2].Value = pageSize; para[3].Value = pageIndex; para[4].Value = 1; para[5].Value = 0; para[6].Value = where; return(dba.ExecuteSqlDataSet("Shine_GetRecordByPage", para)); }
/// <summary> /// 实时进出人员信息 /// </summary> /// <param name="pageIndex">页索引</param> /// <param name="pageSize">页总数</param> /// <param name="where">查询条件</param> /// <returns></returns> public DataSet RT_InOutEmp(int pageIndex, int pageSize, string where) { SqlParameter[] para = { new SqlParameter("@tblName", SqlDbType.VarChar, 255), new SqlParameter("@fldName", 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) }; para[0].Value = "view_RT_InOutMineEmpNameList_FW"; para[1].Value = "员工ID"; para[2].Value = pageSize; para[3].Value = pageIndex; para[4].Value = 1; para[5].Value = 0; para[6].Value = where; return(dbacc.ExecuteSqlDataSet("Pro_GetRTInMineEmp_ByPage", para)); }
/// <summary> /// 查询进出井所有信息 /// </summary> ///<param name="pageIndex">分页索引</param> ///<param name="pageSize">每页记录条数</param> ///<param name="where">查询条件</param> /// <returns>数据集</returns> public DataSet SelectInOutMineAllInfo(int pageIndex, int pageSize, string where) { SqlParameter[] para = { new SqlParameter("@tblName", SqlDbType.VarChar, 255), new SqlParameter("@fldName", 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) }; para[0].Value = "zjw_RtAndHisInOutMine"; para[1].Value = "ID"; para[2].Value = pageSize; para[3].Value = pageIndex; para[4].Value = 1; para[5].Value = 0; para[6].Value = where; return(dbacc.ExecuteSqlDataSet("Shine_GetRecordByPage", para)); }
/// <summary> /// 根据条件查询历史岗位异常信息 /// </summary>、 /// <param name="condition">查询条件</param> /// <returns>返回查询结果</returns> public DataSet SelectHistoryPostInfoByCondition(int pIndex, int pSize, string where) { SqlParameter[] para = { new SqlParameter("@tblName", SqlDbType.VarChar, 255), new SqlParameter("@fldName", 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) }; para[0].Value = "View_SelectHistoryPostInfo"; para[1].Value = "HisPostID"; para[2].Value = pSize; para[3].Value = pIndex; para[4].Value = 1; para[5].Value = 0; para[6].Value = where; return(dbacc.ExecuteSqlDataSet("Shine_GetRecordByPage", para)); }
/// <summary> /// 历史下井信息 /// </summary> /// <param name="pageIndex">页索引</param> /// <param name="pageSize">页总数</param> /// <param name="where">查询条件</param> /// <returns></returns> public DataSet GetHisInWell(string TableName, string TableName2, int pageIndex, int pageSize, string where) { SqlParameter[] para = { new SqlParameter("@tblName", SqlDbType.VarChar, 255), new SqlParameter("@tblName2", SqlDbType.VarChar, 255), new SqlParameter("@fldName", 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) }; para[0].Value = TableName; para[1].Value = TableName2; para[2].Value = "CodeSenderAddress"; para[3].Value = pageSize; para[4].Value = pageIndex; para[5].Value = 1; para[6].Value = 0; para[7].Value = where; //para[6].Value = "1=1"; DataSet ds = dba.ExecuteSqlDataSet("Shine_InOutMine_ByPage", para); return(ds); }