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