/// <summary> /// 更新进入井口分站信息 /// </summary> /// <param name="stationHeadID"></param> /// <param name="stationAddress"></param> /// <param name="stationHeadAddress"></param> /// <param name="codeSenderAddress"></param> /// <param name="dectime"></param> /// <returns></returns> private bool UpdateInMineStation(int stationHeadID, int stationAddress, int stationHeadAddress, int codeSenderAddress, DateTime dectime) { SqlParameter[] sqlParmeters = { new SqlParameter("StationHeadID",SqlDbType.Int), new SqlParameter("@stationAddress",SqlDbType.Int), new SqlParameter("@stationHeadAddress",SqlDbType.Int), new SqlParameter("@CodeSenderAddress",SqlDbType.Int), new SqlParameter("@InMineStationTime",SqlDbType.DateTime) }; sqlParmeters[0].Value = stationHeadID; sqlParmeters[1].Value = stationAddress; sqlParmeters[2].Value = stationHeadAddress; sqlParmeters[3].Value = codeSenderAddress; sqlParmeters[4].Value = dectime; //JYH-2011-11-23 优化 InterfaceHostBack interHostBack = new InterfaceHostBack(); interHostBack.ErrorMessage += _ErrorMessage; return interHostBack.ExecuteSql(true, "proc_UpdateInMineStationInfo", sqlParmeters); //JYH-2011-11-23 注销 无法找到表0 //return interHostBack.ExecuteSql(true, "proc_UpdateInMineStationInfo", sqlParmeters); }
/// <summary> /// Czlt2012-3-20 向年统计表中添加信息 /// </summary> /// <param name="dataAttendance">记工日期</param> /// <param name="codeSenderAddress">标识卡号</param> /// <param name="empID">人员ID</param> /// <param name="strEmpName">人员姓名</param> /// <param name="deptID">部门ID</param> /// <param name="strDeptName">部门名称</param> /// <param name="strTName">表明</param> /// <returns>是否成功</returns> private bool Czlt_AddMonthEmp(DateTime dataAttendance, int codeSenderAddress, int empID, string strEmpName, int deptID, string strDeptName, string strTName) { SqlParameter[] sqlParmeters = { new SqlParameter("@tableName",SqlDbType.VarChar,50), new SqlParameter("@codesender",SqlDbType.VarChar,10), new SqlParameter("@empID",SqlDbType.VarChar,50), new SqlParameter("@empName",SqlDbType.VarChar,10), new SqlParameter("@deptID",SqlDbType.VarChar,50), new SqlParameter("@deptName",SqlDbType.VarChar,50), new SqlParameter("@cYear",SqlDbType.VarChar,20) }; sqlParmeters[0].Value = strTName; sqlParmeters[1].Value = Convert.ToString(codeSenderAddress); sqlParmeters[2].Value = Convert.ToString(empID); sqlParmeters[3].Value = strEmpName; sqlParmeters[4].Value = Convert.ToString(deptID); sqlParmeters[5].Value = strDeptName; sqlParmeters[6].Value = dataAttendance.ToString("yyyy"); InterfaceHostBack interHostBack = new InterfaceHostBack(); interHostBack.ErrorMessage += _ErrorMessage; return interHostBack.ExecuteSql(true, "Proc_Czlt_MonthEmp_Insert", sqlParmeters); }
/// <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; }
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> /// 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; }
/// <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; }
public void IsConnect() { //JYH-2011-11-23 优化 InterfaceHostBack interHostBack = new InterfaceHostBack(); interHostBack.ErrorMessage += _ErrorMessage; interHostBack.IsConnect(true); //return interHostBack.ExecuteSql(true, "KJ128N_Update_CodeSenderLow", sqlParmeters); //JYH-2011-11-23 注销 无法找到表0 // interHostBack.IsConnect(true); }
/// <summary> /// 添加到实时考勤数据 /// </summary> /// <param name="detecTime"></param> /// <param name="strCards"></param> /// <returns></returns> private bool AddRTEmployeeAttendance(DateTime detecTime, string strCards) { SqlParameter[] sqlParmeters = { new SqlParameter("DetectTime",SqlDbType.DateTime), new SqlParameter("Cards",SqlDbType.VarChar,6000) }; sqlParmeters[0].Value = detecTime; sqlParmeters[1].Value = strCards; //JYH-2011-11-23 优化 InterfaceHostBack interHostBack = new InterfaceHostBack(); interHostBack.ErrorMessage += _ErrorMessage; return interHostBack.ExecuteSql(true, "proc_InsertRTEmployeeAttendance", sqlParmeters); //JYH-2011-11-23 注销 无法找到表0 //return interHostBack.ExecuteSql(true, "proc_InsertRTEmployeeAttendance", sqlParmeters); }
/// <summary> /// 删除实时考勤数据 /// </summary> /// <param name="codeSenderAddress"></param> /// <returns></returns> private bool DelteteRealTimeAttendance(int codeSenderAddress) { SqlParameter[] sqlParmeters = { new SqlParameter("CodeSenderAddress",SqlDbType.Int) }; sqlParmeters[0].Value = codeSenderAddress; //JYH-2011-11-23 优化 InterfaceHostBack interHostBack = new InterfaceHostBack(); interHostBack.ErrorMessage += _ErrorMessage; return interHostBack.ExecuteSql(true, "proc_DeleteRealTimeAttendanceByCodeSenderAddress", sqlParmeters); //JYH-2011-11-23 注销 无法找到表0 //return interHostBack.ExecuteSql(true, "proc_DeleteRealTimeAttendanceByCodeSenderAddress", sqlParmeters); }
/// <summary> /// 修改临时实时标识卡信息 /// </summary> /// <param name="drEmp"></param> /// <param name="drStationHead"></param> /// <param name="detecTime"></param> /// <returns></returns> private bool UpdateRtInStationHeadTemp(DataRow drEmp, DataRow drStationHead, DateTime detecTime) { SqlParameter[] sqlParmeters = { new SqlParameter("codeSenderAddress",SqlDbType.Int), new SqlParameter("stationAddress",SqlDbType.Int), new SqlParameter("StationHeadAddress",SqlDbType.Int), new SqlParameter("csSetID",SqlDbType.Int), new SqlParameter("csTypeID",SqlDbType.Int), new SqlParameter("UserID",SqlDbType.Int), new SqlParameter("InStationHeadTime",SqlDbType.DateTime), }; sqlParmeters[0].Value = drEmp["codeSenderAddress"]; sqlParmeters[1].Value = drStationHead["stationAddress"]; sqlParmeters[2].Value = drStationHead["StationHeadAddress"]; sqlParmeters[3].Value = drEmp["csSetID"]; sqlParmeters[4].Value = drEmp["csTypeID"]; sqlParmeters[5].Value = drEmp["UserID"]; sqlParmeters[6].Value = detecTime; //JYH-2011-11-23 优化 InterfaceHostBack interHostBack = new InterfaceHostBack(); interHostBack.ErrorMessage += _ErrorMessage; return interHostBack.ExecuteSql(true, "proc_UpdateRtInStationHeadTemp", sqlParmeters); //JYH-2011-11-23 注销 无法找到表0 //return interHostBack.ExecuteSql(true, "proc_UpdateRtInStationHeadTemp", sqlParmeters); }
/// <summary> /// 删除临时实时标识卡中的数据 /// </summary> /// <param name="stationAddress"></param> /// <param name="stationHeadAddress"></param> /// <returns></returns> private bool DeleteRtStationHeadTemp(int stationAddress, int stationHeadAddress, int codeSenderAddress) { SqlParameter[] sqlParmeters = { new SqlParameter("stationAddress", SqlDbType.Int) , new SqlParameter("StationHeadAddress",SqlDbType.Int), new SqlParameter("codeSenderAddress",SqlDbType.Int) }; sqlParmeters[0].Value = stationAddress; sqlParmeters[1].Value = stationHeadAddress; sqlParmeters[2].Value = codeSenderAddress; //JYH-2011-11-23 优化 InterfaceHostBack interHostBack = new InterfaceHostBack(); interHostBack.ErrorMessage += _ErrorMessage; return interHostBack.ExecuteSql(true, "proc_DeleteRtInStationHeadTempByID", sqlParmeters); //JYH-2011-11-23 注销 无法找到表0 //return interHostBack.ExecuteSql(true, "proc_DeleteRtInStationHeadTempByID", sqlParmeters); }
/// <summary> /// 按照区域编号和标识卡删除实时区域信息 /// </summary> /// <param name="territorialID"></param> /// <param name="codeSenderAddress"></param> /// <returns></returns> private bool DeleteRtTerritorial(int territorialID, int codeSenderAddress) { SqlParameter[] sqlParmeters = { new SqlParameter("TerritorialID",SqlDbType.Int), new SqlParameter("CodeSenderAddress",SqlDbType.Int) }; sqlParmeters[0].Value = territorialID; sqlParmeters[1].Value = codeSenderAddress; //JYH-2011-11-23 优化 InterfaceHostBack interHostBack = new InterfaceHostBack(); interHostBack.ErrorMessage += _ErrorMessage; return interHostBack.ExecuteSql(true, "proc_DeleteRtTerritorialByValue", sqlParmeters); //JYH-2011-11-23 注销 无法找到表0 //return interHostBack.ExecuteSql(true, "proc_DeleteRtTerritorialByValue", sqlParmeters); }
/// <summary> /// 删除所有的实时区域信息 /// </summary> /// <returns></returns> private bool DeleteRtTerritorial() { //JYH-2011-11-23 优化 InterfaceHostBack interHostBack = new InterfaceHostBack(); interHostBack.ErrorMessage += _ErrorMessage; return interHostBack.ExecuteSql(true, "proc_DeleteRtTerritorialAll", null); //JYH-2011-11-23 注销 无法找到表0 //return interHostBack.ExecuteSql(true, "proc_DeleteRtTerritorialAll", null); }
/// <summary> /// 更新实时下井人员信息 /// </summary> /// <param name="codeSenderAddress"></param> /// <param name="stationHeadID"></param> /// <param name="csSetID"></param> /// <param name="inTime"></param> /// <returns></returns> private bool UpdateRtInMine(int codeSenderAddress, int stationHeadID, int csSetID, DateTime inTime) { SqlParameter[] sqlParmeters = { new SqlParameter("CodeSenderAddress",SqlDbType.Int), new SqlParameter("StationHeadID",SqlDbType.Int), new SqlParameter("CsSetID",SqlDbType.Int), new SqlParameter("InTime",SqlDbType.DateTime), }; sqlParmeters[0].Value = codeSenderAddress; sqlParmeters[1].Value = stationHeadID; sqlParmeters[2].Value = csSetID; sqlParmeters[3].Value = inTime; //JYH-2011-11-23 优化 InterfaceHostBack interHostBack = new InterfaceHostBack(); interHostBack.ErrorMessage += _ErrorMessage; return interHostBack.ExecuteSql(true, "proc_UpdateRTInMine", sqlParmeters); //JYH-2011-11-23 注销 无法找到表0 //return interHostBack.ExecuteSql(true, "proc_UpdateRTInMine", sqlParmeters); }
/// <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="drHis"></param> /// <param name="strTableName"></param> /// <returns></returns> private bool AddHisAttendance(DataRow drHis, string strTableName) { SqlParameter[] sqlParmeters = { new SqlParameter("ID",SqlDbType.BigInt), new SqlParameter("BlockID",SqlDbType.Int), new SqlParameter("EmployeeID",SqlDbType.Int), new SqlParameter("EmployeeName",SqlDbType.NVarChar,50), new SqlParameter("DeptID",SqlDbType.Int), new SqlParameter("ClassID",SqlDbType.VarChar,20), new SqlParameter("ClassShortName",SqlDbType.VarChar,10), new SqlParameter("BeginWorkTime",SqlDbType.VarChar,50), new SqlParameter("EndWorkTime",SqlDbType.VarChar,50), new SqlParameter("WorkTime",SqlDbType.Int), new SqlParameter("TimerIntervalID",SqlDbType.Int), new SqlParameter("DataAttendance",SqlDbType.VarChar,50), new SqlParameter("IsMend",SqlDbType.Bit), new SqlParameter("TableName",SqlDbType.VarChar,20) }; sqlParmeters[0].Value = drHis["ID"]; sqlParmeters[1].Value = drHis["BlockID"]; sqlParmeters[2].Value = drHis["EmployeeID"]; sqlParmeters[3].Value = drHis["EmployeeName"]; sqlParmeters[4].Value = drHis["DeptID"]; sqlParmeters[5].Value = drHis["ClassID"]; sqlParmeters[6].Value = drHis["ClassShortName"]; sqlParmeters[7].Value = drHis["BeginWorkTime"]; sqlParmeters[8].Value = drHis["EndWorkTime"]; sqlParmeters[9].Value = drHis["WorkTime"]; sqlParmeters[10].Value = drHis["TimerIntervalID"]; sqlParmeters[11].Value = drHis["DataAttendance"]; sqlParmeters[12].Value = drHis["IsMend"]; sqlParmeters[13].Value = strTableName; //JYH-2011-11-23 优化 InterfaceHostBack interHostBack = new InterfaceHostBack(); interHostBack.ErrorMessage += _ErrorMessage; return interHostBack.ExecuteSql(true, "proc_AddHisAttendance", sqlParmeters); //JYH-2011-11-23 注销 无法找到表0 //return interHostBack.ExecuteSql(true, "proc_AddHisAttendance", sqlParmeters); }
/// <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="dataAttendance"></param> /// <param name="codeSenderAddress"></param> /// <param name="strClassShortName"></param> /// <returns></returns> private bool UpdateKQTJ(DateTime dataAttendance, int codeSenderAddress, string strClassShortName, int deptID, string strDeptName) { SqlParameter[] sqlParmeters = { new SqlParameter("dataAttendance",SqlDbType.DateTime), new SqlParameter("CodeSenderAddress",SqlDbType.Int), new SqlParameter("ClassShortName",SqlDbType.VarChar,20), new SqlParameter("deptID",SqlDbType.Int), new SqlParameter("deptName",SqlDbType.VarChar,50) }; sqlParmeters[0].Value = dataAttendance; sqlParmeters[1].Value = codeSenderAddress; sqlParmeters[2].Value = strClassShortName; sqlParmeters[3].Value = deptID; sqlParmeters[4].Value = strDeptName; //JYH-2011-11-23 优化 InterfaceHostBack interHostBack = new InterfaceHostBack(); interHostBack.ErrorMessage += _ErrorMessage; return interHostBack.ExecuteSql(true, "proc_UpdateKQTJ", sqlParmeters); //JYH-2011-11-23 注销 无法找到表0 //return interHostBack.ExecuteSql(true, "proc_UpdateKQTJ", sqlParmeters); }
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; }
private bool AddHisPathAlarm(DataRowView drvRtPath, DataRowView drvEmp, DateTime detecTime) { SqlParameter[] sqlParmeters = { new SqlParameter("Id",SqlDbType.BigInt), new SqlParameter("EmpID",SqlDbType.Int), new SqlParameter("EmpName",SqlDbType.VarChar,20), new SqlParameter("StationAddress",SqlDbType.Int), new SqlParameter("StationHeadAddress",SqlDbType.Int), new SqlParameter("AlertBeginTime",SqlDbType.DateTime), new SqlParameter("AlertEndTime",SqlDbType.DateTime), new SqlParameter("AlertTimeValue",SqlDbType.Int) }; sqlParmeters[0].Value = Convert.ToInt64(DateTime.Now.ToString("yyyyMMddHHmmss") + Convert.ToInt32(drvEmp["CodeSenderAddress"].ToString()).ToString("0000")); sqlParmeters[1].Value = drvRtPath["empid"]; sqlParmeters[2].Value = drvEmp["UserName"]; sqlParmeters[3].Value = drvRtPath["stationAddress"]; sqlParmeters[4].Value = drvRtPath["stationHeadAddress"]; sqlParmeters[5].Value = drvRtPath["alarmDateTime"]; sqlParmeters[6].Value = detecTime; sqlParmeters[7].Value = Convert.ToInt32(((TimeSpan)(detecTime - Convert.ToDateTime(drvRtPath["alarmDateTime"].ToString()))).TotalSeconds); //JYH-2011-11-23 优化 InterfaceHostBack interHostBack = new InterfaceHostBack(); interHostBack.ErrorMessage += _ErrorMessage; return interHostBack.ExecuteSql(true, "insert_His_PathAlert", sqlParmeters); //JYH-2011-11-23 注销 无法找到表0 //return interHostBack.ExecuteSql(true, "insert_His_PathAlert", sqlParmeters); }
/// <summary> /// 保存电源的供电信息 /// </summary> /// <param name="stationAddress">传输分站编号</param> /// <param name="stationHeadAddress">读卡分站编号</param> /// <param name="stationState">传输分站供电状态</param> /// <param name="serialState">串口服务器供电状态</param> /// <param name="breakTime">时间</param> /// <returns></returns> private bool CzltSaveDYstate(int stationAddress, int stationHeadAddress, int stationState, int serialState, DateTime breakTime) { bool isReturn = false; try { SqlParameter[] sqlParmeters = { new SqlParameter("StationAddress", SqlDbType.Int), new SqlParameter("StationHeadAddress", SqlDbType.Int), new SqlParameter("StationState", SqlDbType.Int), new SqlParameter("SerialState",SqlDbType.Int), new SqlParameter("BreakTime", SqlDbType.DateTime) }; sqlParmeters[0].Value = stationAddress; sqlParmeters[1].Value = stationHeadAddress; sqlParmeters[2].Value = stationState; sqlParmeters[3].Value = serialState; sqlParmeters[4].Value = breakTime.ToString("yyyy-MM-dd HH:mm:ss"); //Czlt-2011-06-09 - 重新获取对象,装载数据 InterfaceHostBack interHostBack = new InterfaceHostBack(); interHostBack.ErrorMessage += _ErrorMessage; isReturn = interHostBack.ExecuteSql(true, "Czlt_Proc_DYShowMode", sqlParmeters); } catch (Exception ex) { if (ErrorMessage != null) { ErrorMessage(6031008, ex.StackTrace, "[DataSave:Czlt_Proc_DYShowMode]", ex.Message); } } return isReturn; }
/// <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; }
/// <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> /// 获取临时表中的数据 /// </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> /// Czlt-2012-03-20 修改年报表信息 /// </summary> /// <param name="dataAttendance">记工日期</param> /// <param name="codeSenderAddress">标识卡号</param> /// <param name="cMNum">修改信息</param> /// <param name="empName">人员姓名</param> /// <param name="strTName">表名称</param> /// <returns></returns> private bool Czlt_UpdateMonthEmp(DateTime dataAttendance, int codeSenderAddress, int cMNum, string empName, string strTName) { SqlParameter[] sqlParmeters = { new SqlParameter("@tableName",SqlDbType.VarChar,50), new SqlParameter("@Cname",SqlDbType.VarChar,20), new SqlParameter("@cNum",SqlDbType.VarChar,20), new SqlParameter("@codesender",SqlDbType.VarChar,20), new SqlParameter("@cYear",SqlDbType.VarChar,20), new SqlParameter("@empName",SqlDbType.VarChar,20) }; sqlParmeters[0].Value = strTName; sqlParmeters[1].Value = "cM" + dataAttendance.Month; sqlParmeters[2].Value = cMNum.ToString(); sqlParmeters[3].Value = codeSenderAddress.ToString(); sqlParmeters[4].Value = dataAttendance.ToString("yyyy"); sqlParmeters[5].Value = empName; InterfaceHostBack interHostBack = new InterfaceHostBack(); interHostBack.ErrorMessage += _ErrorMessage; return interHostBack.ExecuteSql(true, "Proc_Czlt_MonthEmp_Update", sqlParmeters); }
/// <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="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> /// 按照地点获取方向性配置信息 /// </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> /// 将探头收到的卡的信息存入SQL Server数据库 /// </summary> /// <param name="strCmdInfo">探头收到的信息</param> /// <returns>True:成功;False:失败</returns> private bool Save_DataBase(string strCmdInfo) { //判断当前是否在切换数据库,如果在切换则跳出 if (isSyncHost) { return true; } SqlParameter[] sqlParmeters = { new SqlParameter("Commands", SqlDbType.VarChar, 7000) }; sqlParmeters[0].Value = strCmdInfo; InterfaceHostBack interHostBack = new InterfaceHostBack(); interHostBack.ErrorMessage += _ErrorMessage; return interHostBack.ExecuteSql(true, "Yl_Station_ExecProc", sqlParmeters); //JYH-2011-11-23 注销 -无法找到表0 //return interHostBack.ExecuteSql(true, "Yl_Station_ExecProc", sqlParmeters); }
private bool AddHisInOutMine(DataRow drHisInOutMine, string strTableName) { SqlParameter[] sqlParmeters = { new SqlParameter("HisInOutMineID",SqlDbType.BigInt), new SqlParameter("InStationAddress",SqlDbType.Int), new SqlParameter("InStationHeadAddress",SqlDbType.Int), new SqlParameter("InWellPlace",SqlDbType.NVarChar,50), new SqlParameter("CodeSenderAddress",SqlDbType.Int), new SqlParameter("UserID",SqlDbType.Int), new SqlParameter("UserNo",SqlDbType.NVarChar,50), new SqlParameter("UserName",SqlDbType.NVarChar,20), new SqlParameter("DeptID",SqlDbType.Int), new SqlParameter("DeptName",SqlDbType.NVarChar,50), new SqlParameter("DutyID",SqlDbType.Int), new SqlParameter("DutyName",SqlDbType.NVarChar,50), new SqlParameter("WorkTypeID",SqlDbType.Int), new SqlParameter("WorkTypeName",SqlDbType.NVarChar,50), new SqlParameter("InTime",SqlDbType.DateTime), new SqlParameter("OutStationAddress",SqlDbType.Int), new SqlParameter("OutStationHeadAddress",SqlDbType.Int), new SqlParameter("OutWellPlace",SqlDbType.NVarChar,50), new SqlParameter("OutTime",SqlDbType.DateTime), new SqlParameter("ContinueTime",SqlDbType.BigInt), new SqlParameter("IsMend",SqlDbType.Bit), new SqlParameter("TableName",SqlDbType.VarChar,20) }; sqlParmeters[0].Value = drHisInOutMine["HisInOutMineID"]; sqlParmeters[1].Value = drHisInOutMine["InStationAddress"]; sqlParmeters[2].Value = drHisInOutMine["InStationHeadAddress"]; sqlParmeters[3].Value = drHisInOutMine["InWellPlace"]; sqlParmeters[4].Value = drHisInOutMine["CodeSenderAddress"]; sqlParmeters[5].Value = drHisInOutMine["UserID"]; sqlParmeters[6].Value = drHisInOutMine["UserNo"]; sqlParmeters[7].Value = drHisInOutMine["UserName"]; sqlParmeters[8].Value = drHisInOutMine["DeptID"]; sqlParmeters[9].Value = drHisInOutMine["DeptName"]; sqlParmeters[10].Value = drHisInOutMine["DutyID"]; sqlParmeters[11].Value = drHisInOutMine["DutyName"]; sqlParmeters[12].Value = drHisInOutMine["WorkTypeID"]; sqlParmeters[13].Value = drHisInOutMine["WorkTypeName"]; sqlParmeters[14].Value = drHisInOutMine["InTime"]; sqlParmeters[15].Value = drHisInOutMine["OutStationAddress"]; sqlParmeters[16].Value = drHisInOutMine["OutStationHeadAddress"]; sqlParmeters[17].Value = drHisInOutMine["OutWellPlace"]; sqlParmeters[18].Value = drHisInOutMine["OutTime"]; sqlParmeters[19].Value = drHisInOutMine["ContinueTime"]; sqlParmeters[20].Value = drHisInOutMine["IsMend"]; sqlParmeters[21].Value = strTableName; //JYH-2011-11-23 优化 InterfaceHostBack interHostBack = new InterfaceHostBack(); interHostBack.ErrorMessage += _ErrorMessage; return interHostBack.ExecuteSql(true, "proc_AddHisInOutMine", sqlParmeters); //JYH-2011-11-23 注销 无法找到表0 //return interHostBack.ExecuteSql(true, "proc_AddHisInOutMine", sqlParmeters); }