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