/// <summary>
/// 保存读卡分站状态
/// </summary>
/// <param name="stationAddress"></param>
/// <param name="stationHeadAddress"></param>
/// <param name="stationState"></param>
/// <param name="breakTime"></param>
/// <returns></returns>
private bool SaveStationHeadState(int stationAddress, int stationHeadAddress, int stationState, DateTime breakTime)
{
SqlParameter[] sqlParmeters = {
new SqlParameter("StationAddress", SqlDbType.Int),
new SqlParameter("StationHeadAddress", SqlDbType.Int),
new SqlParameter("StationState", SqlDbType.Int),
new SqlParameter("BreakTime", SqlDbType.DateTime)
};
sqlParmeters[0].Value = stationAddress;
sqlParmeters[1].Value = stationHeadAddress;
sqlParmeters[2].Value = stationState;
sqlParmeters[3].Value = breakTime;
//JYH-2011-11-23 优化
InterfaceHostBack interHostBack = new InterfaceHostBack();
interHostBack.ErrorMessage += _ErrorMessage;
return interHostBack.ExecuteSql(true, "StationHead_StateChange", sqlParmeters);
//JYH-2011-11-23 注销 无法找到表0
//return interHostBack.ExecuteSql(true, "StationHead_StateChange", 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="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>
/// 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>
/// 删除实时考勤数据
/// </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="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);
}
private bool AddRtTerritorial(int territorialID, string strTerritorialName, DateTime inTerritorialTime, int codeSenderAddress, int csSetID, int csTypeID, int userID, string strTerritorialTypeName, bool isAlarm)
{
SqlParameter[] sqlParmeters = {
new SqlParameter("TerritorialID",SqlDbType.Int),
new SqlParameter("TerritorialName",SqlDbType.NVarChar,20),
new SqlParameter("InTerritorialTime",SqlDbType.DateTime),
new SqlParameter("CodeSenderAddress",SqlDbType.Int),
new SqlParameter("CsSetID",SqlDbType.Int),
new SqlParameter("CsTypeID",SqlDbType.Int),
new SqlParameter("UserID",SqlDbType.Int),
new SqlParameter("TerritorialTypeName",SqlDbType.NVarChar,20),
new SqlParameter("IsAlarm",SqlDbType.Bit),
};
sqlParmeters[0].Value = territorialID;
sqlParmeters[1].Value = strTerritorialName;
sqlParmeters[2].Value = inTerritorialTime;
sqlParmeters[3].Value = codeSenderAddress;
sqlParmeters[4].Value = csSetID;
sqlParmeters[5].Value = csTypeID;
sqlParmeters[6].Value = userID;
sqlParmeters[7].Value = strTerritorialTypeName;
sqlParmeters[8].Value = isAlarm;
//JYH-2011-11-23 优化
InterfaceHostBack interHostBack = new InterfaceHostBack();
interHostBack.ErrorMessage += _ErrorMessage;
return interHostBack.ExecuteSql(true, "proc_AddRTAreaInfo", sqlParmeters);
//JYH-2011-11-23 注销 无法找到表0
//return interHostBack.ExecuteSql(true, "proc_AddRTAreaInfo", 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="dr"></param>
/// <param name="strTableName"></param>
/// <returns></returns>
private bool AddHisTerritorial(DataRow dr, string strTableName)
{
SqlParameter[] sqlParmeters = {
new SqlParameter("HisTerritorialID",SqlDbType.BigInt),
new SqlParameter("TerritorialID",SqlDbType.Int),
new SqlParameter("TerritorialName",SqlDbType.NVarChar,20),
new SqlParameter("TerritorialTypeName",SqlDbType.NVarChar,20),
new SqlParameter("InTerritorialTime",SqlDbType.DateTime),
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("OutTerritorialTime",SqlDbType.DateTime),
new SqlParameter("ContinueTime",SqlDbType.BigInt),
new SqlParameter("IsAlarm",SqlDbType.Bit),
new SqlParameter("TableName",SqlDbType.VarChar,20)
};
sqlParmeters[0].Value = dr["HisTerritorialID"];
sqlParmeters[1].Value = dr["TerritorialID"];
sqlParmeters[2].Value = dr["TerritorialName"];
sqlParmeters[3].Value = dr["TerritorialTypeName"];
sqlParmeters[4].Value = dr["InTerritorialTime"];
sqlParmeters[5].Value = dr["CodeSenderAddress"];
sqlParmeters[6].Value = dr["UserID"];
sqlParmeters[7].Value = dr["UserNo"];
sqlParmeters[8].Value = dr["UserName"];
sqlParmeters[9].Value = dr["DeptID"];
sqlParmeters[10].Value = dr["DeptName"];
sqlParmeters[11].Value = dr["DutyID"];
sqlParmeters[12].Value = dr["DutyName"];
sqlParmeters[13].Value = dr["WorkTypeID"];
sqlParmeters[14].Value = dr["WorkTypeName"];
sqlParmeters[15].Value = dr["OutTerritorialTime"];
sqlParmeters[16].Value = dr["ContinueTime"];
sqlParmeters[17].Value = dr["IsAlarm"];
sqlParmeters[18].Value = strTableName;
//JYH-2011-11-23 优化
InterfaceHostBack interHostBack = new InterfaceHostBack();
interHostBack.ErrorMessage += _ErrorMessage;
return interHostBack.ExecuteSql(true, "proc_AddHistoryTerritorial", sqlParmeters);
//JYH-2011-11-23 注销 无法找到表0
//return interHostBack.ExecuteSql(true, "proc_AddHistoryTerritorial", sqlParmeters);
}
/// <summary>
/// 添加历史人员区域超时信息
/// </summary>
/// <param name="drvTerOverTime"></param>
/// <param name="drvEmp"></param>
/// <returns></returns>
private bool AddHisTerrOverTime(DataRowView drvTerOverTime, DataRowView drvEmp, DateTime detecTime)
{
SqlParameter[] sqlParmeters = {
new SqlParameter("HisTerEmpOverTimeID",SqlDbType.BigInt),
new SqlParameter("TerritorialID",SqlDbType.Int),
new SqlParameter("TerritorialName",SqlDbType.NVarChar,20),
new SqlParameter("TerritorialTypeName",SqlDbType.NVarChar,20),
new SqlParameter("InTerritorialTime",SqlDbType.DateTime),
new SqlParameter("StartOverTime",SqlDbType.DateTime),
new SqlParameter("TerWorkTime",SqlDbType.Int),
new SqlParameter("OutTerritorialTime",SqlDbType.DateTime),
new SqlParameter("CodeSenderAddress",SqlDbType.NVarChar,20),
new SqlParameter("EmpID",SqlDbType.Int),
new SqlParameter("EmpName",SqlDbType.NVarChar,50),
new SqlParameter("DeptID",SqlDbType.Int),
new SqlParameter("DeptName",SqlDbType.NVarChar,20),
new SqlParameter("WtName",SqlDbType.NVarChar,50)
};
sqlParmeters[0].Value = Convert.ToInt64(DateTime.Now.ToString("yyyyMMddHHmmss") + Convert.ToInt32(drvEmp["CodeSenderAddress"].ToString()).ToString("0000")); ;
sqlParmeters[1].Value = drvTerOverTime["TerritorialID"];
sqlParmeters[2].Value = drvTerOverTime["TerritorialName"];
sqlParmeters[3].Value = drvTerOverTime["TerritorialTypeName"];
sqlParmeters[4].Value = drvTerOverTime["InTerritorialTime"];
sqlParmeters[5].Value = drvTerOverTime["StartOverTime"];
sqlParmeters[6].Value = Convert.ToInt32(((TimeSpan)(detecTime - Convert.ToDateTime(drvTerOverTime["StartOverTime"].ToString()))).TotalSeconds);
sqlParmeters[7].Value = detecTime;
sqlParmeters[8].Value = drvEmp["CodeSenderAddress"];
sqlParmeters[9].Value = drvEmp["UserID"];
sqlParmeters[10].Value = drvEmp["UserName"];
sqlParmeters[11].Value = drvEmp["DeptID"];
sqlParmeters[12].Value = drvEmp["DeptName"];
sqlParmeters[13].Value = drvEmp["WorkTypeName"];
//JYH-2011-11-23 优化
InterfaceHostBack interHostBack = new InterfaceHostBack();
interHostBack.ErrorMessage += _ErrorMessage;
return interHostBack.ExecuteSql(true, "proc_InsertHisTerOverTime", sqlParmeters);
//JYH-2011-11-23 注销 无法找到表0
//return interHostBack.ExecuteSql(true, "proc_InsertHisTerOverTime", sqlParmeters);
}
/// <summary>
/// 更新求救信息
/// </summary>
/// <param name="stationAddress"></param>
/// <param name="stationHeadAddress"></param>
/// <param name="strCards"></param>
/// <param name="dtimeDecte"></param>
/// <returns></returns>
private bool UpdateRtEmpHelp(int stationAddress, int stationHeadAddress, string strCards, DateTime dtimeDecte)
{
SqlParameter[] sqlParmeters = {
new SqlParameter("DetecTime", SqlDbType.DateTime),
new SqlParameter("StationAddress", SqlDbType.Int),
new SqlParameter("StationHeadAddress", SqlDbType.Int),
new SqlParameter("Cards", SqlDbType.VarChar,6000)
};
sqlParmeters[0].Value = dtimeDecte;
sqlParmeters[1].Value = stationAddress;
sqlParmeters[2].Value = stationHeadAddress;
sqlParmeters[3].Value = strCards;
//JYH-2011-11-23 优化
InterfaceHostBack interHostBack = new InterfaceHostBack();
interHostBack.ErrorMessage += _ErrorMessage;
return interHostBack.ExecuteSql(true, "process_EmpHelpInfo", sqlParmeters);
//JYH-2011-11-23 注销 无法找到表0
//return interHostBack.ExecuteSql(true, "process_EmpHelpInfo", sqlParmeters);
}
/// <summary>
/// 更新实时进出读卡分站记录
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private bool UpdateRtInStationHead(DataRowView dr)
{
SqlParameter[] sqlParmeters = {
new SqlParameter("codeSenderAddress",SqlDbType.Int),
new SqlParameter("stationHeadID",SqlDbType.Int),
new SqlParameter("CsSetID",SqlDbType.Int),
new SqlParameter("CsTypeID",SqlDbType.Int),
new SqlParameter("UserID",SqlDbType.Int),
new SqlParameter("InAntennaPlace",SqlDbType.VarChar,50),
new SqlParameter("InStationHeadTime",SqlDbType.DateTime),
new SqlParameter("stationHeadTime",SqlDbType.DateTime),
new SqlParameter("Directional",SqlDbType.VarChar,50),
new SqlParameter("inOutFlag",SqlDbType.SmallInt),
};
sqlParmeters[0].Value = dr["codeSenderAddress"];
sqlParmeters[1].Value = dr["stationHeadID"];
sqlParmeters[2].Value = dr["CsSetID"];
sqlParmeters[3].Value = dr["CsTypeID"];
sqlParmeters[4].Value = dr["UserID"];
sqlParmeters[5].Value = dr["InAntennaPlace"];
sqlParmeters[6].Value = dr["InStationHeadTime"];
sqlParmeters[7].Value = dr["stationHeadTime"];
sqlParmeters[8].Value = dr["Directional"];
sqlParmeters[9].Value = dr["inOutFlag"];
//JYH-2011-11-23 优化
InterfaceHostBack interHostBack = new InterfaceHostBack();
interHostBack.ErrorMessage += _ErrorMessage;
return interHostBack.ExecuteSql(true, "proc_UpdateRTInStationHeadInfo", sqlParmeters);
//JYH-2011-11-23 注销 无法找到表0
//return interHostBack.ExecuteSql(true, "proc_UpdateRTInStationHeadInfo", sqlParmeters);
}
/// <summary>
/// 置标识卡状态为正常
/// </summary>
/// <param name="strCares"></param>
/// <returns></returns>
private bool SaveCodeSenderStateByOk(string strCards)
{
SqlParameter[] sqlParmeters = {
new SqlParameter("Cards", SqlDbType.VarChar,8000)
};
sqlParmeters[0].Value = strCards;
//JYH-2011-11-23 优化
InterfaceHostBack interHostBack = new InterfaceHostBack();
interHostBack.ErrorMessage += _ErrorMessage;
return interHostBack.ExecuteSql(true, "Shine_Shen_Update_CodeSender_Common", sqlParmeters);
//JYH-2011-11-23 注销 无法找到表0
//return interHostBack.ExecuteSql(true, "Shine_Shen_Update_CodeSender_Common", 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>
/// <param name="detecTime"></param>
/// <returns></returns>
private bool OperatorTerOverEmp(DateTime detecTime)
{
SqlParameter[] sqlParmeters = {
new SqlParameter("DetectTime",SqlDbType.DateTime)
};
sqlParmeters[0].Value = detecTime;
//JYH-2011-11-23 优化
InterfaceHostBack interHostBack = new InterfaceHostBack();
interHostBack.ErrorMessage += _ErrorMessage;
return interHostBack.ExecuteSql(true, "OperatorTerOverEmp", sqlParmeters);
//JYH-2011-11-23 注销 无法找到表0
//return interHostBack.ExecuteSql(true, "OperatorTerOverEmp", 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="detecTime"></param>
/// <returns></returns>
private bool AddRTOverSpeed(DateTime detecTime, int stationAddress, int stationHeadAddress, string strCards)
{
SqlParameter[] sqlParmeters = {
new SqlParameter("DetectTime",SqlDbType.DateTime),
new SqlParameter("StationAddress",SqlDbType.Int),
new SqlParameter("StationHeadAddress",SqlDbType.Int),
new SqlParameter("Cards",SqlDbType.VarChar,6000)
};
sqlParmeters[0].Value = detecTime;
sqlParmeters[1].Value = stationAddress;
sqlParmeters[2].Value = stationHeadAddress;
sqlParmeters[3].Value = strCards;
//JYH-2011-11-23 优化
InterfaceHostBack interHostBack = new InterfaceHostBack();
interHostBack.ErrorMessage += _ErrorMessage;
return interHostBack.ExecuteSql(true, "proc_InsertRTOverSpeed", sqlParmeters);
//JYH-2011-11-23 注销 无法找到表0
//return interHostBack.ExecuteSql(true, "proc_InsertRTOverSpeed", sqlParmeters);
}
/// <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="strCards"></param>
/// <returns></returns>
private bool UpdateHisOverSpeed(string strCards)
{
SqlParameter[] sqlParmeters = {
new SqlParameter("Cards",SqlDbType.VarChar,6000)
};
sqlParmeters[0].Value = strCards;
//JYH-2011-11-23 优化
InterfaceHostBack interHostBack = new InterfaceHostBack();
interHostBack.ErrorMessage += _ErrorMessage;
return interHostBack.ExecuteSql(true, "proc_UpdateHisOverSpeed", sqlParmeters);
//JYH-2011-11-23 注销 无法找到表0
//return interHostBack.ExecuteSql(true, "proc_UpdateHisOverSpeed", sqlParmeters);
}
/// <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);
}
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);
}
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="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>
/// 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>
/// <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>
/// 将探头收到的卡的信息存入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);
}
/// <summary>
/// 操作人员下井超员信息
/// </summary>
/// <returns></returns>
private bool SaveOverEmp()
{
//JYH-2011-11-23 优化
InterfaceHostBack interHostBack = new InterfaceHostBack();
interHostBack.ErrorMessage += _ErrorMessage;
return interHostBack.ExecuteSql(true, "proc_InsertUpdateRealTimeOverEmp", null);
//JYH-2011-11-23 注销 无法找到表0
//return interHostBack.ExecuteSql(true, "proc_InsertUpdateRealTimeOverEmp", null);
}
