/// <summary> /// 查询实时接收器信息 /// </summary> /// <param name="strState">分站编号</param> /// <param name="dv"></param> /// <returns></returns> public bool N_SearchStaHeadBreakInfo(string strState,DataGridViewKJ128 dv) { using (ds = new DataSet()) { dv.Columns.Clear(); ds = this.N_GetStaHeadBreakInfo(strState); if (ds == null ) { return false; } ds.Tables[0].Columns[0].ColumnName = HardwareName.Value(CorpsName.StationAddress); ds.Tables[0].Columns[1].ColumnName = HardwareName.Value(CorpsName.StationSplace); ds.Tables[0].Columns[2].ColumnName = HardwareName.Value(CorpsName.StaHeadAddress); ds.Tables[0].Columns[3].ColumnName = HardwareName.Value(CorpsName.StaHeadSplace); ds.Tables[0].Columns[4].ColumnName = HardwareName.Value(CorpsName.StaHead) + "联系电话"; ds.Tables[0].Columns[5].ColumnName = HardwareName.Value(CorpsName.StaHead) + "类型"; ds.Tables[0].Columns[6].ColumnName = HardwareName.Value(CorpsName.StaHead) + "状态"; ds.Tables[0].Columns[7].ColumnName = HardwareName.Value(CorpsName.StaHead) + "故障时间"; dv.DataSource = ds.Tables[0].DefaultView; dv.Columns[0].FillWeight = 40; dv.Columns[2].FillWeight = 55; dv.Columns[3].FillWeight = 150; dv.Columns[6].FillWeight = 70; dv.Columns[7].FillWeight = 120; dv.Columns[7].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss"; } return true; }
public bool GetHisBadStaHeadInfo(string strStartTime, string strEndTime, string strStationAddress, DataGridViewKJ128 dv) { using (ds = new DataSet()) { try { dv.Columns.Clear(); ds = hbdal.GetHisBadStaHeadInfo(strStartTime, strEndTime, strStationAddress); if (ds != null && ds.Tables.Count >= 0) { dv.DataSource = ds.Tables[0]; dv.Columns[0].HeaderText = HardwareName.Value(CorpsName.StationAddress); dv.Columns[1].HeaderText = HardwareName.Value(CorpsName.StaHeadAddress); } } catch (Exception) { dv.DataSource = null; return false; } } return true; }
/// <summary> /// 查询超员信息 /// </summary> /// <param name="intOverEmpType">超员类别,1:超员;2:欠员</param> /// <param name="dv"></param> /// <returns>True:成功;False:失败</returns> public bool SelectOverEmp(int intOverEmpType, DataGridViewKJ128 dv) { try { using (ds = new DataSet()) { dv.Columns.Clear(); ds = rtoedal.SelectOverEmp(intOverEmpType); //if (ds == null) //{ // return false; //} ds.Tables[0].TableName = "TaskTimeBLL_RtOverEmp"; dv.DataSource = ds.Tables[0].DefaultView; } } catch { return false; } return true; }
public bool N_SearchFactoryInfo(string strFacNO, string strFacID, DataGridViewKJ128 dv,out string strCounts) { using (ds = new DataSet()) { dv.Columns.Clear(); ds = cemdal.N_GetFactoryInfo(strFacNO, strFacID); dv.DataSource = ds.Tables[0].DefaultView; if (ds != null && ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { strCounts = ds.Tables[0].Rows.Count.ToString(); } else { strCounts = "0"; } } else { strCounts = "0"; } } return true; }
public bool N_SearchDirectionalManage(string txtDetection, string strWhere, DataGridViewKJ128 dv,out string strCounts) { using (ds = new DataSet()) { dv.Columns.Clear(); ds = cdmdal.N_SearchDirectionalManage(txtDetection, strWhere); dv.DataSource = ds.Tables[0].DefaultView; dv.Columns[0].FillWeight = 70; dv.Columns[1].FillWeight = 85; if (ds != null && ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { strCounts = ds.Tables[0].Rows.Count.ToString(); } else { strCounts = "0"; } } else { strCounts = "0"; } } return true; }
/// <summary> /// 获取低电量信息 /// </summary> /// <param name="CodeSenderStateID">发码器状态,4:低电量</param> /// <param name="dv"></param> /// <param name="strCounts"></param> /// <returns></returns> public bool N_SelectAlarmElectricity(int CodeSenderStateID,int intCsTypeID, DataGridViewKJ128 dv,out string strCounts) { using (ds = new DataSet()) { dv.Columns.Clear(); ds = rtaedal.N_GetAlarmElectricity(CodeSenderStateID,intCsTypeID); if (ds != null && ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { strCounts = ds.Tables[0].Rows.Count.ToString(); } else { strCounts = "0"; } ds.Tables[0].Columns[0].ColumnName = HardwareName.Value(CorpsName.CodeSenderAddress); dv.DataSource = ds.Tables[0]; } else { strCounts = "0"; } } return true; }
public bool N_SearchRTInTerritorialInfo(int intTerTypeID,string strTerName,bool blIsEmp,string strIsAlarm, DataGridViewKJ128 dv,out string strCounts) { using (ds = new DataSet()) //加载信息 { dv.Columns.Clear(); ds = rtitdal.N_GetRTInTerritorialInfo(intTerTypeID, strTerName, blIsEmp, strIsAlarm); dv.DataSource = ds.Tables[0].DefaultView; //将进入区域时间精确到秒 dv.Columns[6].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss"; dv.Columns[6].FillWeight = 120; dv.Columns[5].Visible = false; if (ds != null && ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { strCounts = ds.Tables[0].Rows.Count.ToString(); } else { strCounts = "0"; } } else { strCounts = "0"; } } return true; }
public bool N_SearchOverTimeInfo(string strName,string strCard,string strDeptID,string strWorkTypeId,string strDutyId,DataGridViewKJ128 dv,out string strCounts) { using (ds = new DataSet()) { dv.Columns.Clear(); //ds = dbacc.GetDataSet(strSql); ds=rtotdal.N_GetOverTimeInfo(strName,strCard,strDeptID,strWorkTypeId,strDutyId); if (ds != null && ds.Tables.Count > 0) { dv.DataSource = ds.Tables[0].DefaultView; //将开始超时时间精确到秒 dv.Columns[5].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss"; if (ds.Tables[0].Rows.Count > 0) { strCounts = ds.Tables[0].Rows.Count.ToString(); } else { strCounts = "0"; } } else { strCounts = "0"; } } return true; }
public void N_SelectRTDirectional(string strDept, string strName, string strCardAddress, string strStation, string strStaHead, bool blIsEmp,string strDirectional, DataGridViewKJ128 dv,out string strCounts) { using (ds = new DataSet()) { dv.Columns.Clear(); ds = rtddal.N_GetRTDirectional(strDept, strName, strCardAddress, strStation, strStaHead, blIsEmp, strDirectional); ds.Tables[0].Columns[0].ColumnName = HardwareName.Value(CorpsName.CodeSenderAddress); ds.Tables[0].Columns[3].ColumnName = HardwareName.Value(CorpsName.StationAddress); ds.Tables[0].Columns[4].ColumnName = HardwareName.Value(CorpsName.StaHeadAddress); ds.Tables[0].Columns[6].ColumnName = HardwareName.Value(CorpsName.Inspect); if (ds != null && ds.Tables.Count > 0) { //ds.Tables[0].Columns[0].ColumnName = HardwareName.Value(CorpsName.CodeSenderAddress); //ds.Tables[0].Columns[3].ColumnName = HardwareName.Value(CorpsName.StationAddress); //ds.Tables[0].Columns[4].ColumnName = HardwareName.Value(CorpsName.StaHeadAddress); //ds.Tables[0].Columns[6].ColumnName = HardwareName.Value(CorpsName.Inspect); dv.DataSource = ds.Tables[0].DefaultView; dv.Columns[7].Visible = false; dv.Columns[0].FillWeight = 50; dv.Columns[1].FillWeight = 60; dv.Columns[2].FillWeight = 60; dv.Columns[3].FillWeight = 45; dv.Columns[4].FillWeight = 45; dv.Columns[5].FillWeight = 120; dv.Columns[6].FillWeight = 85; //将监测时间精确到秒 dv.Columns[6].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss"; if (ds != null && ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { strCounts = ds.Tables[0].Rows.Count.ToString(); } else { strCounts = "0"; } } else { strCounts = "0"; } } else { dv.DataSource = null; strCounts = "0"; } } }
/// <summary> /// 查询实时超时信息 /// </summary> /// <param name="dv">要显示的DataGridView</param> /// <returns></returns> public bool SearchRtInOutMine(DataGridViewKJ128 dv) { using (ds = new DataSet()) { dv.Columns.Clear(); ds = GetRtInOutMine(); dv.DataSource = ds.Tables[0].DefaultView; } return true; }
public bool N_SearchRTInOutAntennaInfo( string strStartTime, string strEndTime, string strCard, string strStationAddress, string strStationHeadAddress, int intUserType, DataGridViewKJ128 dv, out string strCounts) { if (DateTime.Compare(DateTime.Parse(strStartTime), DateTime.Parse(strEndTime)) > 0) { MessageBox.Show("对不起, 开始时间不能大于结束时间!"); strCounts = "-1"; return false; } using (ds = new DataSet()) { dv.Columns.Clear(); ds = lrtodal.N_SearchRTInOutAntennaInfo(strStartTime, strEndTime, strCard, strStationAddress, strStationHeadAddress,intUserType); dv.DataSource = ds.Tables[0]; if (ds != null && ds.Tables.Count > 0) { dv.Columns[3].FillWeight = 150; dv.Columns[0].HeaderText = HardwareName.Value(CorpsName.CodeSenderAddress); dv.Columns[1].HeaderText = HardwareName.Value(CorpsName.StationAddress); dv.Columns[2].HeaderText = HardwareName.Value(CorpsName.StaHeadAddress); dv.Columns[3].HeaderText = HardwareName.Value(CorpsName.StaHead) + "监测时间"; //将监测时间精确到秒 dv.Columns[3].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss"; if (ds.Tables[0].Rows.Count > 0) { strCounts = ds.Tables[0].Rows.Count.ToString(); } else { strCounts = "0"; } } else { strCounts = "0"; } } return true; }
public static void Print(DataGridViewKJ128 dgv, string title,string strSum) { if (dgv.DataSource == null) { MessageBox.Show("没有数据,无法打印", "提示"); return; } DataGridView dgvs = dgv; model = GetModel.getMode(dgvs, title, strSum);//获得打印参数 FormPrint print = new FormPrint(model); print.CallPrintForm(dgv, title, strSum); }
public static void PrintSet128(DataGridViewKJ128 dgv, string title, string strSum) { if (dgv.DataSource == null) { MessageBox.Show("没有数据,无法选择输出格式", "提示"); return; } DataGridView dgvs = dgv; model = GetModel.getMode(dgvs, title, strSum);//获得打印参数 Frm_Print_Set cs = new Frm_Print_Set(model, title); cs.ShowDialog(); }
public bool GetRTEmpHelpInfo(string strBeginTime, string strEndTime, string strCodeSenderAddress, string strSatationAddress, string strStaHeadAddress, string strEmpName, string strDeptName, string strDutyName, string strWtName, string strMeasure, DataGridViewKJ128 dgv) { try { using (ds = new DataSet()) { ds = dal.SelectRealTimeEmpHelpInfo(strBeginTime, strEndTime, strCodeSenderAddress, strSatationAddress, strStaHeadAddress, strEmpName, strDeptName, strDutyName, strWtName, strMeasure); if (ds != null && ds.Tables.Count > 0) { dgv.Columns.Clear(); dgv.DataSource = ds.Tables[0]; AddColumns(dgv); dgv.Columns[0].HeaderText = HardwareName.Value(CorpsName.StationAddress); dgv.Columns[1].HeaderText = HardwareName.Value(CorpsName.StationSplace); dgv.Columns[2].HeaderText = HardwareName.Value(CorpsName.StaHeadAddress); dgv.Columns[3].HeaderText = HardwareName.Value(CorpsName.StaHeadSplace); dgv.Columns[4].HeaderText = HardwareName.Value(CorpsName.CodeSenderAddress); dgv.Columns[0].Width = 50; dgv.Columns[2].Width = 50; dgv.Columns[4].Width = 50; dgv.Columns[5].Width = 70; dgv.Columns[6].Width = 70; dgv.Columns[7].Width = 70; dgv.Columns[8].Width = 70; dgv.Columns[9].Width = 80; dgv.Columns[10].Width = 140; dgv.Columns[10].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss"; dgv.Columns[11].Visible = false; if (New_DBAcess.blIsClient) { dgv.Columns["Measure"].Visible=false; dgv.Columns["EndHelp"].Visible = false; } } } return true; } catch { return false; } }
/// <summary> /// 查询历史超时记录 /// </summary> /// <param name="strStartTime">开始时间</param> /// <param name="strEndTime">结束时间</param> /// <param name="strCard">发码器</param> /// <param name="dv">所要绑定的 DataGridView</param> /// <returns></returns> public bool SearchHisTimeOut( string strStartTime, string strEndTime, string strCard, DataGridViewKJ128 dv) { if (DateTime.Compare(DateTime.Parse(strStartTime), DateTime.Parse(strEndTime)) > 0) { MessageBox.Show("对不起, 开始时间不能大于结束时间!"); return false; } strSql = " Select " + " Hi.CodeSenderAddress As "+HardwareName.Value(CorpsName.CodeSender)+", " + " Ei.EmpName As 名称, " + " Di.DeptName As 部门, " + " Hi.InMineTime As 下井时间, " + " Hi.DelayedStartTime As 超时开始时间, " + " Hi.DelayedEndTime As 超时结束时间, " + " Hi.DelayedTime As 超时持续时间 " + " From His_OverTimeAlarm As Hi " + " Left Join Emp_Info As Ei On Ei.EmpID = Hi.UserID " + " Left Join Emp_NowCompany As En On En.EmpID = Ei.EmpID " + " Left Join Dept_Info As Di On Di.DeptID = En.DeptID " + " Where Hi.CsTypeID = 1 And Hi.InMineTime >= '" + strStartTime + "' And Hi.InMineTime <= '" + strEndTime + "' "; if (!(strCard.Equals("") | strCard.Equals(null))) { strSql += " And Hi.CodeSenderAddress = " + strCard; } strSql += " Union " + " Select " + " Hi.CodeSenderAddress As " + HardwareName.Value(CorpsName.CodeSender) + ", " + " Eb.EquName As 名称, " + " Di.DeptName As 部门, " + " Hi.InMineTime As 下井时间, " + " Hi.DelayedStartTime As 超时开始时间, " + " Hi.DelayedEndTime As 超时结束时间, " + " Hi.DelayedTime As 超时持续时间 " + " From His_OverTimeAlarm As Hi " + " Left Join Equ_BaseInfo As Eb On Eb.EquID = Hi.UserID " + " Left Join Dept_Info As Di On Di.DeptID = Eb.DeptID " + " Where Hi.CsTypeID = 2 And Hi.InMineTime >= '" + strStartTime + "' And Hi.InMineTime <= '" + strEndTime + "' "; if (!(strCard.Equals("") | strCard.Equals(null))) { strSql += " And Hi.CodeSenderAddress = " + strCard; } return true; }
/* * 外部调用 */ #region [ 方法: 查询分站信息 ] /// <summary> /// 查询分站信息 /// </summary> /// <param name="dv"></param> /// <returns></returns> public int N_SearchStationInfo(DataGridViewKJ128 dv) { int iSum = 0; using (ds = new DataSet()) { dv.Columns.Clear(); ds = this.N_GetStationInfo(); dv.DataSource = ds.Tables[0].DefaultView; iSum = ds.Tables[0].Rows.Count; if (dv.Rows.Count > 0) { dv.Rows[0].Selected = true; } dv.Columns[0].FillWeight = 60; dv.Columns[2].FillWeight = 80; dv.Columns[3].FillWeight = 60; } return iSum; }
/// <summary> /// 查询实时分站信息 /// </summary> /// <param name="strState">分站状态</param> /// <param name="dv"></param> /// <returns></returns> public bool N_SearchStaBreakInfo(string strState, DataGridViewKJ128 dv) { using (ds = new DataSet()) { dv.Columns.Clear(); ds = rtsbdal.N_StaBreakInfo(strState); if (ds == null) { return false; } ds.Tables[0].Columns[0].ColumnName = HardwareName.Value(CorpsName.StationAddress); ds.Tables[0].Columns[1].ColumnName = HardwareName.Value(CorpsName.StationSplace); //ds.Tables[0].Columns[2].ColumnName = HardwareName.Value(CorpsName.Station) + "联系电话"; //ds.Tables[0].Columns[3].ColumnName = HardwareName.Value(CorpsName.Station) + "状态"; //ds.Tables[0].Columns[4].ColumnName = HardwareName.Value(CorpsName.Station) + "故障时间"; dv.DataSource = ds.Tables[0].DefaultView; dv.Columns[5].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss"; dv.Columns[3].Visible = false; } return true; }
private void cpToExcel_Click(object sender, EventArgs e) { DataGridViewKJ128 dgv = new DataGridViewKJ128(); if (rbEmp.Checked) { dgv = dvEmp; } else { dgv = dvEqu; } PrintBLL.Print(dgv, Text, lb_Counts.Text); }
public bool SearchOverTimeInfo(string strName, string strCard, string strDeptID, string strWorkTypeId, string strDutyId, DataGridViewKJ128 dv, out string strCounts) { using (ds = new DataSet()) { dv.Columns.Clear(); //ds = dbacc.GetDataSet(strSql); ds = rtotdal.N_GetOverTimeInfo(strName, strCard, strDeptID, strWorkTypeId, strDutyId); ds.Tables[0].TableName = "TaskTimeBLL_RtOverTime"; dv.DataSource = ds.Tables[0].DefaultView; if (ds != null && ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { strCounts = ds.Tables[0].Rows.Count.ToString(); } else { strCounts = "0"; } } else { strCounts = "0"; } } return true; }
//#region 获取 发码器状态 基本信息 ///// <summary> ///// 获取 发码器状态 基本信息 ///// </summary> ///// <returns></returns> //private DataSet N_GetCsTypeName() //{ // strSql = " Select EnumID,Title From EnumTable Where FunID=2 "; // return dbacc.GetDataSet(strSql); //} //#endregion #endregion #region [ 方法: 发码器查询 ] /// <summary> /// 发码器查询 /// </summary> /// <param name="strCodeSender">发码器编号</param> /// <param name="strCodeSenderStateID">发码器状态ID</param> /// <param name="dv">要绑定的DataGridView</param> /// <returns>true 成功,false 不成功</returns> public bool N_SearchCodeInfo(string strCodeSender, string strCodeSenderStateID, DataGridViewKJ128 dv,out string strCounts) { using (ds = new DataSet()) { dv.Columns.Clear(); ds = ccsdal.N_SearchCodeInfo(strCodeSender, strCodeSenderStateID); dv.DataSource = ds.Tables[0].DefaultView; dv.Columns[0].FillWeight = 40; dv.Columns[1].FillWeight = 40; dv.Columns[2].FillWeight = 40; if (ds != null && ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { strCounts = ds.Tables[0].Rows.Count.ToString(); } else { strCounts = "0"; } } else { strCounts = "0"; } dv.Columns[1].HeaderText = HardwareName.Value(CorpsName.CodeSender) + "状态"; } return true; }
public void SearchStaHeadInfo(string strSta, string strStaHead, int headDisplayType, DataGridViewKJ128 dv,out string strCounts) { /*string strSql; strSql = " Select " + " Rcs.CodeSenderAddress as 发码器, " + " 名称=case when CsTypeID=0 then Ei.EmpName when CsTypeID=1 then Ebi.EquName end, " + " 配置类型= case when CsTypeID=0 then '人员' when CsTypeID=1 then '设备' end, " + " 部门=case when CsTypeID=0 then Di1.DeptName when CsTypeID=1 then Di2.DeptName end, " + " Cd.Directional as 方向性, " + " StationHeadDetectTime as 监测时间 " + " From " + " RealTimeCodeSender as Rcs left join CodeSender_Set as Cs on Cs.CsSetID=Rcs.CsSetID " + " left join Emp_Info as Ei on Ei.EmpID=Cs.UserID and CsTypeID=0 " + " left join Emp_NowCompany as Enc on Enc.EmpID=Ei.EmpID " + " left join Dept_Info as Di1 on Di1.DeptID=Enc.DeptID " + " left join CodeSender_Directional as Cd on Cd.DetectionInfo =Rcs.CodeSenderDirectional " + " left join Equ_BaseInfo as Ebi on Ebi.EquID =Cs.UserID and CsTypeID=1 " + " left join Dept_Info as Di2 on Di2.DeptID=Ebi.DeptID " + " Where " + " Rcs.StationAddress = " + strSta; if (strStaHead != "") { strSql += " And Rcs.StationHeadAddress = " + strStaHead; } if (headDisplayType != 2) { strSql += " And CsTypeID=" + headDisplayType.ToString(); } using (ds = new DataSet()) { dv.Columns.Clear(); ds = dbacc.GetDataSet(strSql); dv.DataSource = ds.Tables[0].DefaultView; }*/ string procName = "PROC_GetRTStaHeadCodeInfo"; SqlParameter[] sqlParmeters ={ new SqlParameter("StationAddress",SqlDbType.Int), new SqlParameter("StationHeadAddress",SqlDbType.Int), new SqlParameter("sumType",SqlDbType.Int) }; sqlParmeters[0].Value = strSta; sqlParmeters[1].Value = strStaHead; sqlParmeters[2].Value = headDisplayType; using (ds = new DataSet()) { dv.Columns.Clear(); ds = dbacc.GetDataSet(procName, sqlParmeters); if (ds == null) { dv.DataSource = null; strCounts = "0"; return; } ds.Tables[0].Columns[0].ColumnName = HardwareName.Value(CorpsName.CodeSenderAddress); //发码器编号 ds.Tables[0].Columns[5].ColumnName = HardwareName.Value(CorpsName.Inspect); //监测时间 dv.DataSource = ds.Tables[0].DefaultView; dv.Columns[5].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss"; if (ds != null && ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { strCounts = ds.Tables[0].Rows.Count.ToString(); } else { strCounts = "0"; } } else { strCounts = "0"; } } }
/// <summary> /// 查询部门信息 /// </summary> /// <param name="dv">要绑定的DataGridView</param> /// <param name="strDeptID">部门ID</param> /// <returns>true 成功,false 不成功</returns> public int N_SearchDeptInfo(DataGridViewKJ128 dv, string strDeptID) { using (ds = new DataSet()) { dv.Columns.Clear(); ds = this.N_GetSearchDeptInfo(strDeptID); dv.DataSource = ds.Tables[0].DefaultView; //dv.Columns[0].FillWeight = 76; //dv.Columns[1].FillWeight = 76; //dv.Columns[2].FillWeight = 53; //dv.Columns[3].FillWeight = 70; //dv.Columns[4].FillWeight = 70; //dv.Columns[5].FillWeight = 70; //dv.Columns[6].FillWeight = 90; //dv.Columns[7].FillWeight = 100; //dv.Columns[8].FillWeight = 100; } return ds.Tables[0].Rows.Count; }
/// <summary> /// 查询(工种、证书、职务) 信息 /// </summary> /// <param name="dv">要绑定的DataGridView</param> /// <param name="strFlagFun">信息标志, 工种为"WorkType", 证书为"Certificate", 职务为"Duty"</param> /// <returns>true 成功,false 不成功</returns> public int N_SearchInfo(DataGridViewKJ128 dv, string strFlagFun) { int iSum = 0; using (ds = new DataSet()) { dv.Columns.Clear(); switch (strFlagFun) { case "WorkType": ds = this.N_GetWorkTypeInfo(); dv.DataSource = ds.Tables[0].DefaultView; dv.Columns[0].FillWeight = 45; dv.Columns[1].FillWeight = 45; dv.Columns[2].FillWeight = 50; dv.Columns[3].FillWeight = 50; break; case "Certificate": ds = this.N_GetCertificateInfo(); dv.DataSource = ds.Tables[0].DefaultView; dv.Columns[0].FillWeight = 45; dv.Columns[1].FillWeight = 65; dv.Columns[2].FillWeight = 45; break; case "Duty": ds = this.N_GetDutyInfo(); dv.DataSource = ds.Tables[0].DefaultView; dv.Columns[0].FillWeight = 45; dv.Columns[1].FillWeight = 45; break; default: return 0; } iSum = ds.Tables[0].Rows.Count; } return iSum; }
/// <summary> /// 查询实时进出接收器信息_人员 /// </summary> /// <param name="strStartTime">开始时间</param> /// <param name="strEndTime">结束时间</param> /// <param name="strStationAddress">分站编号</param> /// <param name="strStationHeadAddress">接收器号</param> /// <param name="strName">姓名</param> /// <param name="strCard">发码器</param> /// <param name="strWorkTypeId">工种</param> /// <param name="strDeptName">部门</param> /// <param name="intUserType">用户类型 1人 2设备</param> /// <param name="dv">要显示的DataGridView</param> /// <returns></returns> public bool N_SearchRTInOutStationHeadInfo( string strStartTime, string strEndTime, string strStationAddress, string strStationHeadAddress, string strName, string strCard, string strWorkTypeId, string strDeptName, int intUserType, DataGridViewKJ128 dv, out string strCounts) { if (DateTime.Compare(DateTime.Parse(strStartTime), DateTime.Parse(strEndTime)) > 0) { MessageBox.Show("对不起, 开始时间不能大于结束时间!"); strCounts="-1"; return false; } using (ds = new DataSet()) { dv.Columns.Clear(); //ds = dbacc.GetDataSet(strSql); ds = lrtdal.N_GetRTInOutStationHeadInfo(strStartTime, strEndTime, strStationAddress, strStationHeadAddress, strName, strCard, strWorkTypeId, strDeptName, intUserType); dv.DataSource = ds.Tables[0].DefaultView; if (ds != null && ds.Tables.Count > 0) { dv.Columns[4].FillWeight = 60; dv.Columns[5].FillWeight = 60; dv.Columns[6].FillWeight = 160; dv.Columns[8].FillWeight = 130; //将监测时间精确到秒 dv.Columns[8].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss"; if (ds.Tables[0].Rows.Count > 0) { strCounts = ds.Tables[0].Rows.Count.ToString(); } else { strCounts = "0"; } } else { strCounts = "0"; } } return true; }
/// <summary> /// 查询人员配置信息 /// </summary> /// <param name="strName">员工姓名</param> /// <param name="strNo">员工编号</param> /// <param name="strIdCard">身份证编号</param> /// <param name="strDeptID">部门ID</param> /// <param name="strWorkTypeId">工种ID</param> /// <param name="strDutyId">职务ID</param> /// <param name="dv">要绑定的DataGridView</param> /// <returns>true 成功,false 不成功</returns> public bool N_SearchConEmployeeInfo(string strName, string strNo, string strIdCard, string strDeptID, string strWorkTypeId, string strDutyId, DataGridViewKJ128 dv, out string strCounts) { using (ds = new DataSet()) { dv.Columns.Clear(); ds = ceidal.N_GetConEmployeeInfo(strName, strNo, strIdCard, strDeptID, strWorkTypeId, strDutyId); dv.DataSource = ds.Tables[0].DefaultView; dv.Columns[0].FillWeight = 76; dv.Columns[1].FillWeight = 76; dv.Columns[2].FillWeight = 53; dv.Columns[3].FillWeight = 70; dv.Columns[4].FillWeight = 70; dv.Columns[5].FillWeight = 70; dv.Columns[6].FillWeight = 90; dv.Columns[7].FillWeight = 100; dv.Columns[8].FillWeight = 100; if (ds != null && ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { strCounts = ds.Tables[0].Rows.Count.ToString(); } else { strCounts = "0"; } } else { strCounts = "0"; } } return true; }
//自动打印 public void AutoPrint(DataGridViewKJ128 dgv, string title, string strSum) { //FormPrint print1 = new FormPrint(); //print1.CallPrintForm(dgv, title, strSum, true); PrintBLL.Print(dgv, title, strSum); }
//FunID 16 时间 15是打印 EnumValue为0时不打印 public void TimePrint() { string date = GetTime(); DataTable dt = GetPrint(); string s = ""; if (date != "0") { string nowDate = DateTime.Now.ToString("HH")+":" + DateTime.Now.ToString("mm"); if (nowDate == date) { if (dt.Select("EnumID=1")[0]["EnumValue"].ToString() == "1") { s += "1,"; // 实时下井人员总数及人员 RealTimeBLL rtbll = new RealTimeBLL(); DataSet ds = rtbll.getRTInWellEmpInfo(0, 9999, "1=1"); if (ds != null && ds.Tables.Count > 0) { DataGridViewKJ128 dgvRTInfo = new DataGridViewKJ128(); dgvRTInfo.DataSource = ds.Tables[0]; ds.Tables[0].TableName = "TaskTimeBLL_RtInOutMine"; Bind(dgvRTInfo,ds.Tables[0]); dgvRTInfo.Columns[5].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss"; dgvRTInfo.Columns[5].FillWeight = 130; dgvRTInfo.Columns[5].HeaderText = HardwareName.Value(CorpsName.InWellTime); dgvRTInfo.Columns[6].HeaderText = HardwareName.Value(CorpsName.StandingWellTime); PrintBLL.Print(dgvRTInfo, "实时下井人员总数及人员", ds.Tables[1].Rows[0][0].ToString()); AutoPrint(dgvRTInfo, "实时下井人员总数及人员", "实时下井人员总数:" + ds.Tables[1].Rows[0][0].ToString()); } } if (dt.Select("EnumID=2")[0]["EnumValue"].ToString() == "1") { s += "2,"; // 重点区域人员总数及人员 RealTimeInTerritorialDAL dal = new RealTimeInTerritorialDAL(); DataGridViewKJ128 dgvzd = new DataGridViewKJ128(); ds = dal.GetAreaTable("重点"); if (ds != null && ds.Tables.Count > 0) { dgvzd.DataSource = ds.Tables[0]; ds.Tables[0].TableName = "TaskTimeBLL_ImpArea"; Bind(dgvzd, ds.Tables[0]); // print AutoPrint(dgvzd, "重点区域人员总数及人员", "重点区域人员总数:" + ds.Tables[0].Rows.Count.ToString()); } } if (dt.Select("EnumID=3")[0]["EnumValue"].ToString() == "1") { s += "3,"; // 超时报警人员总数及人员 RealtimeOverTimeInfoBLL rtotbll = new RealtimeOverTimeInfoBLL(); DataGridViewKJ128 dgValue = new DataGridViewKJ128(); string strCounts = string.Empty; rtotbll.SearchOverTimeInfo("", "", "", "0", "0", dgValue, out strCounts); Bind(dgValue, ((DataView)dgValue.DataSource).Table); //print AutoPrint(dgValue, "超时报警人员总数及人员", "超时报警人员总数:" + ((DataView)dgValue.DataSource).Table.Rows.Count.ToString()); } if (dt.Select("EnumID=4")[0]["EnumValue"].ToString() == "1") { s += "4,"; // 超员报警人员总数及人员 RealTimeOverEmpBLL rtoebll = new RealTimeOverEmpBLL(); DataGridViewKJ128 dgvOverEmp = new DataGridViewKJ128(); rtoebll.SelectOverEmp(1, dgvOverEmp); Bind(dgvOverEmp, ((DataView)dgvOverEmp.DataSource).Table); AutoPrint(dgvOverEmp, "超员报警人员总数及人员", "超员报警人员总数:" + ((DataView)dgvOverEmp.DataSource).Table.Rows.Count.ToString()); } if (dt.Select("EnumID=5")[0]["EnumValue"].ToString() == "1") { s += "5,"; // 限制区域报警人员总数及人员 RealTimeInTerritorialDAL rtdal = new RealTimeInTerritorialDAL(); DataGridViewKJ128 dgvxz = new DataGridViewKJ128(); ds = rtdal.GetAreaTable("限制"); if (ds != null && ds.Tables.Count > 0) { ds.Tables[0].TableName = "TaskTimeBLL_LimitArea"; dgvxz.DataSource = ds.Tables[0]; Bind(dgvxz, ds.Tables[0]); AutoPrint(dgvxz, "限制区域报警人员总数及人员", "限制区域报警人员总数:" + ds.Tables[0].Rows.Count.ToString()); // print } } if (dt.Select("EnumID=6")[0]["EnumValue"].ToString() == "1") { s += "6,"; // 特种作业人员工作异常报警总数及人员 SpecialWorkTypeTerrialSetBLL swt = new SpecialWorkTypeTerrialSetBLL(); DataGridViewKJ128 dgvWork = new DataGridViewKJ128(); string strErr = string.Empty; DataSet dswork = swt.Query_RealTimeSpecialWorkTypeAlarm(1, 9999, "", out strErr); if (dswork != null && dswork.Tables.Count > 0) { dswork.Tables[0].TableName = "TaskTimeBLL_Special"; dgvWork.DataSource = dswork.Tables[0]; if (dgvWork.Columns.Count > 0) { dgvWork.Columns[0].Visible = false; Bind(dgvWork, dswork.Tables[0]); AutoPrint(dgvWork, "特种作业人员工作异常报警总数及人员", "特种作业人员工作异常报警总数:" + dgvWork.RowCount.ToString()); } } } string value = dt.Select("EnumID=7")[0]["EnumValue"].ToString(); if (value != "0") { string now = DateTime.Now.ToString("dd")+":" + DateTime.Now.ToString("HH")+":"+DateTime.Now.ToString("mm"); if (value == now) { s += "7,"; // 领导干部每月下井总数及时间统计 AttendanceBLL aBLL = new AttendanceBLL(); DataGridViewKJ128 dgv = new DataGridViewKJ128(); string strErr7 = string.Empty; string where = "and DataAttendance >" + Convert.ToString(int.Parse(DateTime.Now.ToString("MM")) - 1) + "-1" + " and DataAttendance<" + DateTime.Now.ToString("MM").ToString() + "-1"; ds = aBLL.GetAttendanceStatisticByDuty(where, " and en.DutyID in (select EnumID from EnumTable where FunID = 4 and EnumValue = '1'" , out strErr7); if (ds != null && ds.Tables.Count > 0) { ds.Tables[0].TableName = "TaskTimeBLL_LeaderMonth"; dgv.DataSource = ds.Tables[0]; Bind(dgv, ds.Tables[0]); AutoPrint(dgv, "领导干部每月下井总数及时间统计", "共 " + ds.Tables[0].Rows.Count.ToString() + "人"); } } } //MessageBox.Show(s); } } }
private void Bind(DataGridViewKJ128 dgv,DataTable dt) { foreach (DataColumn col in dt.Columns) { DataGridViewColumn c = new DataGridViewColumn(); c.DataPropertyName = col.ColumnName; //c.Name = col.ColumnName; c.HeaderText = col.ColumnName; dgv.Columns.Add(c); } }
public int N_SearchTerType(DataGridViewKJ128 dv) { int iSum = 0; using (ds = new DataSet()) { dv.Columns.Clear(); ds=camdal.N_SearchTerType(); dv.DataSource = ds.Tables[0].DefaultView; iSum = ds.Tables[0].Rows.Count; } return iSum; }
/// <summary> /// 绑定工种(返回DataGridView) /// </summary> /// <returns>返回DataGridView</returns> public DataGridViewKJ128 GetWorkTypeDgv(DataGridViewKJ128 dgv) { string strSql = "select * from KJ128N_WorkType_Info_Table"; DataTable dt = GetDataTableWorkType(strSql); //DataGridViewColumn dgvc1=new DataGridViewColumn(); //DataGridViewColumn dgvc2=new DataGridViewColumn(); dgv.DataSource = dt; dgv.ReadOnly = true; dgv.Columns[0].DisplayIndex = 11; dgv.Columns[1].DisplayIndex = 11; dgv.Columns[4].Visible = false; dgv.Columns[9].Visible = false; dgv.Columns[10].Visible = false; dgv.Columns[11].Visible = false; dgv.Columns[2].Visible = false; dgv.Columns[8].Visible = false; return dgv; }