/// <summary> /// 查询年报表中有没有该人员信息 /// </summary> /// <param name="strCards">标识卡号</param> /// <param name="dtime">记工日期</param> /// <returns></returns> private DataTable Czlt_GetMonthEmpbyCards(string strCards, DateTime dtime, string strTName) { DataTable dtDirectional = null; DateTime dTimeKQTJ = new DateTime(dtime.Year, dtime.Month, 1, 0, 0, 0); try { SqlParameter[] sqlParmeters = { new SqlParameter("@tableName", SqlDbType.VarChar,50) , new SqlParameter("@codesender", SqlDbType.VarChar,10) , new SqlParameter("@cYear",SqlDbType.VarChar,10) }; sqlParmeters[0].Value = strTName; sqlParmeters[1].Value = strCards; sqlParmeters[2].Value = dTimeKQTJ.ToString("yyyy"); InterfaceHostBack interHostBack = new InterfaceHostBack(); interHostBack.ErrorMessage += _ErrorMessage; dtDirectional = interHostBack.GetDataTabel(true, "Proc_Czlt_MonthEmp_Select", sqlParmeters); } catch (Exception ex) { if (ErrorMessage != null) { ErrorMessage(6031008, ex.StackTrace, "[DataSave:GetMonthEmpbyCards]", ex.Message); } } return dtDirectional; }
/// <summary> /// 当 InMineStationInfo 表中没有下井信息时,找一个井口信息补漏 /// </summary> /// <returns></returns> private string GetStaHeadID() { string strID = string.Empty; try { DataTable dtRtInWell = null; InterfaceHostBack interHostBack = new InterfaceHostBack(); interHostBack.ErrorMessage += _ErrorMessage; dtRtInWell = interHostBack.GetDataTabel(true, "proc_CzltGetStationHead", null); if (dtRtInWell != null && dtRtInWell.Rows.Count > 0) { strID = dtRtInWell.Rows[0][0].ToString(); } } catch { } return strID; }
/// <summary> /// 按照卡号获取下个月的考勤统计信息 /// </summary> /// <param name="strCards"></param> /// <param name="dtime"></param> /// <returns></returns> private DataTable CzltGetKQTJbyCards(string strCards, DateTime dtime) { DataTable dtDirectional = null; DateTime dTimeKQTJ = new DateTime(dtime.Year, dtime.AddMonths(1).Month, 1, 0, 0, 0); if (dtime.Month.ToString().Equals("12")) { dTimeKQTJ = new DateTime(dtime.AddYears(1).Year, dtime.AddMonths(1).Month, 1, 0, 0, 0); } try { SqlParameter[] sqlParmeters = { new SqlParameter("Cards", SqlDbType.VarChar,6000) , new SqlParameter("dataAttendance",SqlDbType.DateTime) }; sqlParmeters[0].Value = strCards; sqlParmeters[1].Value = dTimeKQTJ; // dtDirectional = interHostBack.GetDataTabel(true, "proc_GetKQTJByCard", sqlParmeters); InterfaceHostBack interHostBackCzlt = new InterfaceHostBack(); interHostBackCzlt.ErrorMessage += _ErrorMessage; dtDirectional = interHostBackCzlt.GetDataTabel(true, "proc_GetKQTJByCard", sqlParmeters); } catch (Exception ex) { if (ErrorMessage != null) { ErrorMessage(6031008, ex.StackTrace, "[DataSave:proc_GetKQTJByCard]", ex.Message); } } return dtDirectional; }
/// <summary> /// Czlt-2011-12-22 查询班次信息 /// </summary> /// <param name="detecTime">下井时间</param> /// <param name="strCards">卡号</param> /// <returns></returns> private DataTable GetAttDT(DateTime detecTime, string strCards) { DataTable dtAtt = null; try { SqlParameter[] sqlParmeters = { new SqlParameter("@DetectTime", SqlDbType.DateTime), new SqlParameter("@Cards",SqlDbType.VarChar,100) }; sqlParmeters[0].Value = detecTime; sqlParmeters[1].Value = strCards; //dtAtt = GetDataTabel(true, "Czlt_GetAttClass", sqlParmeters); InterfaceHostBack interHostBackCzlt = new InterfaceHostBack(); interHostBackCzlt.ErrorMessage += _ErrorMessage; dtAtt = interHostBackCzlt.GetDataTabel(true, "Czlt_GetAttClass", sqlParmeters); } catch (Exception ex) { } return dtAtt; }
public DataTable GetTcpClientInfo() { try { SqlParameter[] sqlParmeters = { new SqlParameter("sign", SqlDbType.Int) }; //JYH-2011-11-23 优化 InterfaceHostBack interHostBack = new InterfaceHostBack(); interHostBack.ErrorMessage += _ErrorMessage; dt_TcpClient = interHostBack.GetDataTabel(true, "cjg_select_tcpIpConfig", null); //JYH-2011-11-23 注销 无法找到表0 //dt_TcpClient = interHostBack.GetDataTabel(true, "cjg_select_tcpIpConfig", null); sqlParmeters = null; } catch (Exception ex) { if (ErrorMessage != null) { ErrorMessage(6031008, ex.StackTrace, "[DataSave:GetTcpClientInfo]", ex.Message); } } return dt_TcpClient; }
public DataTable GetSqlVersion() { DataTable dtSql = null; try { InterfaceHostBack interHostBack = new InterfaceHostBack(); interHostBack.ErrorMessage += _ErrorMessage; dtSql = interHostBack.GetDataTabel(true, "czltGetVer", null); } catch (Exception ex) { if (ErrorMessage != null) { ErrorMessage(6031008, ex.StackTrace, "[DataSave:GetTcpClientInfo]", ex.Message); } } return dtSql; }
/// <summary> /// 获取实时巡检异常信息 /// </summary> /// <param name="strCards"></param> /// <returns></returns> private DataTable GetRealTimePathAlarm(string strCards) { DataTable dtRealTimePath = null; try { SqlParameter[] sqlParmeters = { new SqlParameter("Cards", SqlDbType.VarChar,6000) }; sqlParmeters[0].Value = strCards; //JYH-2011-11-23 优化 InterfaceHostBack interHostBack = new InterfaceHostBack(); interHostBack.ErrorMessage += _ErrorMessage; dtRealTimePath = interHostBack.GetDataTabel(true, "proc_GetRealTimePath", sqlParmeters); //JYH-2011-11-23 注销 无法找到表0 //dtRealTimePath = interHostBack.GetDataTabel(true, "proc_GetRealTimePath", sqlParmeters); } catch (Exception ex) { if (ErrorMessage != null) { ErrorMessage(6031008, ex.StackTrace, "[DataSave:proc_GetRealTimePath]", ex.Message); } } return dtRealTimePath; }
/// <summary> /// 提取数据库基站信息 /// </summary> /// <param name="iSelectType">1为串口 2为网口</param> /// <returns></returns> public DataTable GetStationInfo(int iSelectType) { try { SqlParameter[] sqlParmeters = { new SqlParameter("sign", SqlDbType.Int) }; sqlParmeters[0].Value = iSelectType; //JYH-2011-11-23 优化 InterfaceHostBack interHostBack = new InterfaceHostBack(); interHostBack.ErrorMessage += _ErrorMessage; dt_Satation = interHostBack.GetDataTabel(true, "zjw_Select_Station", sqlParmeters); //JYH-2011-11-23 注销 无法找到表0 //dt_Satation = interHostBack.GetDataTabel(true, "zjw_Select_Station", sqlParmeters); sqlParmeters = null; } catch (Exception ex) { if (ErrorMessage != null) { ErrorMessage(6031008, ex.StackTrace, "[DataSave:GetStationInfo]", ex.Message); } } return dt_Satation; }
/// <summary> /// 按照卡号获取考勤统计信息 /// </summary> /// <param name="strCards"></param> /// <param name="dtime"></param> /// <returns></returns> private DataTable GetKQTJbyCards(string strCards, DateTime dtime) { DataTable dtDirectional = null; DateTime dTimeKQTJ = new DateTime(dtime.Year, dtime.Month, 1, 0, 0, 0); try { SqlParameter[] sqlParmeters = { new SqlParameter("Cards", SqlDbType.VarChar,6000) , new SqlParameter("dataAttendance",SqlDbType.DateTime) }; sqlParmeters[0].Value = strCards; sqlParmeters[1].Value = dTimeKQTJ; //JYH-2011-11-23 优化 InterfaceHostBack interHostBack = new InterfaceHostBack(); interHostBack.ErrorMessage += _ErrorMessage; dtDirectional = interHostBack.GetDataTabel(true, "proc_GetKQTJByCard", sqlParmeters); //JYH-2011-11-23 注销 无法找到表0 //dtDirectional = interHostBack.GetDataTabel(true, "proc_GetKQTJByCard", sqlParmeters); } catch (Exception ex) { if (ErrorMessage != null) { ErrorMessage(6031008, ex.StackTrace, "[DataSave:proc_GetKQTJByCard]", ex.Message); } } return dtDirectional; }
/// <summary> /// 按照地点获取方向性配置信息 /// </summary> /// <param name="stationAddress"></param> /// <param name="stationHeadAddress"></param> /// <returns></returns> private DataTable GetCodeSenderDirectionalAntennaByAddress(int stationAddress, int stationHeadAddress) { DataTable dtDirectional = null; try { SqlParameter[] sqlParmeters = { new SqlParameter("stationAddress", SqlDbType.Int) , new SqlParameter("StationHeadAddress",SqlDbType.Int) }; sqlParmeters[0].Value = stationAddress; sqlParmeters[1].Value = stationHeadAddress; //JYH-2011-11-23 优化 InterfaceHostBack interHostBack = new InterfaceHostBack(); interHostBack.ErrorMessage += _ErrorMessage; dtDirectional = interHostBack.GetDataTabel(true, "proc_GetCodeSenderDirectionalAntennaByAddress", sqlParmeters); //JYH-2011-11-23 注销 无法找到表0 //dtDirectional = interHostBack.GetDataTabel(true, "proc_GetCodeSenderDirectionalAntennaByAddress", sqlParmeters); } catch (Exception ex) { if (ErrorMessage != null) { ErrorMessage(6031008, ex.StackTrace, "[DataSave:proc_GetCodeSenderDirectionalAntennaByAddress]", ex.Message); } } return dtDirectional; }
/// <summary> /// 获取特殊工种区域配置 /// </summary> /// <returns></returns> private DataTable GetSWorkTypeAreaSet() { DataTable dtSWorkTypeAreaInfo = null; try { //JYH-2011-11-23 优化 InterfaceHostBack interHostBack = new InterfaceHostBack(); interHostBack.ErrorMessage += _ErrorMessage; dtSWorkTypeAreaInfo = interHostBack.GetDataTabel(true, "proc_GetSWorkTypeAresSet", null); //JYH-2011-11-23 注销 无法找到表0 //dtSWorkTypeAreaInfo = interHostBack.GetDataTabel(true, "proc_GetSWorkTypeAresSet", null); } catch (Exception ex) { if (ErrorMessage != null) { ErrorMessage(6031008, ex.StackTrace, "[DataSave:proc_GetSWorkTypeAresSet]", ex.Message); } } return dtSWorkTypeAreaInfo; }
/// <summary> /// 获取临时表中的数据 /// </summary> /// <param name="stationAddress"></param> /// <returns></returns> private DataTable GetRTInStationHeadInfoTemp(int stationAddress) { DataTable dtStationHeadTemp = null; try { SqlParameter[] sqlParmeters = { new SqlParameter("stationAddress", SqlDbType.Int) }; sqlParmeters[0].Value = stationAddress; //JYH-2011-11-23 优化 InterfaceHostBack interHostBack = new InterfaceHostBack(); interHostBack.ErrorMessage += _ErrorMessage; dtStationHeadTemp = interHostBack.GetDataTabel(true, "proc_GetRTInStationHeadTempInfoByCards", sqlParmeters); //JYH-2011-11-23 注销 无法找到表0 //dtStationHeadTemp = interHostBack.GetDataTabel(true, "proc_GetRTInStationHeadTempInfoByCards", sqlParmeters); } catch (Exception ex) { if (ErrorMessage != null) { ErrorMessage(6031008, ex.StackTrace, "[DataSave:proc_GetRTInStationHeadTempInfoByCards]", ex.Message); } } return dtStationHeadTemp; }
/// <summary> /// 获取是否离开井口分站 /// qyz 增加判断卡是否离开井口分站,防止重复区域 出井时仍存入下井信息 /// </summary> /// <returns></returns> private DataTable shine_GetRTInstationHeadTmep(string strCards) { DataTable dtStationHeadTemp = null; try { SqlParameter[] sqlParmeters = { new SqlParameter("@Cards",SqlDbType.VarChar,6000) }; sqlParmeters[0].Value = strCards; InterfaceHostBack interHostBack = new InterfaceHostBack(); interHostBack.ErrorMessage += _ErrorMessage; dtStationHeadTemp = interHostBack.GetDataTabel(true, "shine_GetRTInstationHeadTmep", sqlParmeters); } catch (Exception ex) { if (ErrorMessage != null) { ErrorMessage(6031008, ex.StackTrace, "[DataSave:shine_GetRTInstationHeadTmep]", ex.Message); } } return dtStationHeadTemp; }