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