/// <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_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); }
/// <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 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); }
/// <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="strEquNO">设备编号</param> /// <param name="strDeptName">部门</param> /// <param name="dv">要显示的DataGridView</param> /// <returns></returns> public bool N_SearchRTInOutStationHeadInfo_Equ( string strStartTime, string strEndTime, string strStationAddress, string strStationHeadAddress, string strName, string strCard, string strEquNO, string strDeptName, 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_Equ(strStartTime, strEndTime, strStationAddress, strStationHeadAddress, strName, strCard, strEquNO, strDeptName); dv.DataSource = ds.Tables[0]; if (ds != null && ds.Tables.Count > 0) { dv.Columns[0].FillWeight = 60; dv.Columns[2].FillWeight = 60; dv.Columns[4].FillWeight = 60; dv.Columns[5].FillWeight = 60; dv.Columns[6].FillWeight = 150; dv.Columns[7].FillWeight = 150; dv.Columns[8].FillWeight = 140; dv.Columns[9].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); }
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); } }
/// <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); }
/// <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); }
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(); }
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 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); }
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); }
/// <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); }
/// <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); }
/* * 外部调用 */ #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="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="strStationAddress">分站编号</param> /// <param name="dv"></param> /// <returns></returns> public int N_SearchStaHeadInfo(string strStationAddress, DataGridViewKJ128 dv) { int iSum = 0; using (ds = new DataSet()) { dv.Columns.Clear(); ds = this.N_GetStaHeadInfo(strStationAddress); dv.DataSource = ds.Tables[0].DefaultView; if (dv.Rows.Count > 0) { iSum = ds.Tables[0].Rows.Count; dv.Rows[0].Selected = true; dv.Columns[0].FillWeight = 50; dv.Columns[2].FillWeight = 55; dv.Columns[3].FillWeight = 50; dv.Columns[4].FillWeight = 65; dv.Columns[5].FillWeight = 65; } } 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; //if (dgv.Columns.Count > 8) //{ // dgv.Columns.Remove(dgv.Columns[8]); // dgv.Columns.Remove(dgv.Columns[8]); //} } else { dgv = dvEqu; //if (dgv.Columns.Count > 8) //{ // dgv.Columns.Remove(dgv.Columns[8]); // dgv.Columns.Remove(dgv.Columns[8]); //} } PrintBLL.Print(dgv, Text); }
//自动打印 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); } } }
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> private void InitializeComponent() { System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle(); System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 = new System.Windows.Forms.DataGridViewCellStyle(); System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle3 = new System.Windows.Forms.DataGridViewCellStyle(); System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle4 = new System.Windows.Forms.DataGridViewCellStyle(); System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle5 = new System.Windows.Forms.DataGridViewCellStyle(); this.groupBox1 = new System.Windows.Forms.GroupBox(); this.lbIssame = new System.Windows.Forms.Label(); this.buttonCaptionPanel2 = new KJ128WindowsLibrary.ButtonCaptionPanel(); this.buttonCaptionPanel1 = new KJ128WindowsLibrary.ButtonCaptionPanel(); this.dateTimePicker1 = new System.Windows.Forms.DateTimePicker(); this.cbxUserPower = new System.Windows.Forms.ComboBox(); this.cbxisEndDATE = new System.Windows.Forms.CheckBox(); this.cbxisUse = new System.Windows.Forms.CheckBox(); this.txtRemark = new Shine.ShineTextBox(); this.label6 = new System.Windows.Forms.Label(); this.label5 = new System.Windows.Forms.Label(); this.label2 = new System.Windows.Forms.Label(); this.txtUser = new Shine.ShineTextBox(); this.label1 = new System.Windows.Forms.Label(); this.panel1 = new System.Windows.Forms.Panel(); this.buttonCaptionPanel4 = new KJ128WindowsLibrary.ButtonCaptionPanel(); this.buttonCaptionPanel3 = new KJ128WindowsLibrary.ButtonCaptionPanel(); this.label9 = new System.Windows.Forms.Label(); this.dateTimePicker2 = new System.Windows.Forms.DateTimePicker(); this.cbxUserPower1 = new System.Windows.Forms.ComboBox(); this.cbxisEndDATE1 = new System.Windows.Forms.CheckBox(); this.cbxisUse1 = new System.Windows.Forms.CheckBox(); this.txtRemark1 = new Shine.ShineTextBox(); this.label3 = new System.Windows.Forms.Label(); this.label4 = new System.Windows.Forms.Label(); this.label7 = new System.Windows.Forms.Label(); this.txtUser1 = new Shine.ShineTextBox(); this.label8 = new System.Windows.Forms.Label(); this.ids = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.UGName = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.IsEnable = new System.Windows.Forms.DataGridViewCheckBoxColumn(); this.IsUseEndDate = new System.Windows.Forms.DataGridViewCheckBoxColumn(); this.UseEndDate = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.remark = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.Column6 = new System.Windows.Forms.DataGridViewLinkColumn(); this.Column7 = new System.Windows.Forms.DataGridViewLinkColumn(); this.panel2 = new System.Windows.Forms.Panel(); this.sxpPanel1 = new Wilson.Controls.XPPanel.SXPPanel(); dgv_userGroup = new KJ128NInterfaceShow.DataGridViewKJ128(); this.panel1.SuspendLayout(); this.panel2.SuspendLayout(); this.sxpPanel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(dgv_userGroup)).BeginInit(); this.SuspendLayout(); // // groupBox1 // this.groupBox1.Location = new System.Drawing.Point(96, 3); this.groupBox1.Name = "groupBox1"; this.groupBox1.Size = new System.Drawing.Size(48, 23); this.groupBox1.TabIndex = 0; this.groupBox1.TabStop = false; this.groupBox1.Text = "添加"; this.groupBox1.Visible = false; // // lbIssame // this.lbIssame.AutoSize = true; this.lbIssame.ForeColor = System.Drawing.Color.Red; this.lbIssame.Location = new System.Drawing.Point(185, 91); this.lbIssame.Name = "lbIssame"; this.lbIssame.Size = new System.Drawing.Size(0, 13); this.lbIssame.TabIndex = 63; // // buttonCaptionPanel2 // this.buttonCaptionPanel2.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Stretch; this.buttonCaptionPanel2.BorderLineColor = System.Drawing.Color.FromArgb(((int)(((byte)(118)))), ((int)(((byte)(153)))), ((int)(((byte)(199))))); this.buttonCaptionPanel2.CaptionBackColor = System.Drawing.Color.FromArgb(((int)(((byte)(184)))), ((int)(((byte)(207)))), ((int)(((byte)(233))))); this.buttonCaptionPanel2.CaptionBackColor1 = System.Drawing.Color.FromArgb(((int)(((byte)(244)))), ((int)(((byte)(248)))), ((int)(((byte)(250))))); this.buttonCaptionPanel2.CaptionBackColor2 = System.Drawing.Color.FromArgb(((int)(((byte)(211)))), ((int)(((byte)(220)))), ((int)(((byte)(233))))); this.buttonCaptionPanel2.CaptionBottomLineColor = System.Drawing.Color.FromArgb(((int)(((byte)(197)))), ((int)(((byte)(197)))), ((int)(((byte)(197))))); this.buttonCaptionPanel2.CaptionBottomLineWidth = 1; this.buttonCaptionPanel2.CaptionCloseButtonControlLeft = 2; this.buttonCaptionPanel2.CaptionCloseButtonForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(192))))); this.buttonCaptionPanel2.CaptionCloseButtonTitle = "×"; this.buttonCaptionPanel2.CaptionFont = new System.Drawing.Font("宋体", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.buttonCaptionPanel2.CaptionForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))); this.buttonCaptionPanel2.CaptionHeight = 20; this.buttonCaptionPanel2.CaptionLeft = 1; this.buttonCaptionPanel2.CaptionPanelLineMode = System.Drawing.Drawing2D.LinearGradientMode.Vertical; this.buttonCaptionPanel2.CaptionTitle = "取消"; this.buttonCaptionPanel2.CaptionTitleLeft = 8; this.buttonCaptionPanel2.CaptionTitleTop = 4; this.buttonCaptionPanel2.CaptionTop = 1; this.buttonCaptionPanel2.Cursor = System.Windows.Forms.Cursors.Hand; this.buttonCaptionPanel2.IsBorderLine = true; this.buttonCaptionPanel2.IsCaptionSingleColor = false; this.buttonCaptionPanel2.IsOnlyCaption = true; this.buttonCaptionPanel2.IsPanelImage = true; this.buttonCaptionPanel2.IsUserButtonClose = false; this.buttonCaptionPanel2.IsUserCaptionBottomLine = false; this.buttonCaptionPanel2.IsUserSystemCloseButtonLeft = true; this.buttonCaptionPanel2.Location = new System.Drawing.Point(117, 314); this.buttonCaptionPanel2.Name = "buttonCaptionPanel2"; this.buttonCaptionPanel2.PanelImage = null; this.buttonCaptionPanel2.SetButtonStyle = KJ128WindowsLibrary.ButtonCaptionPanelButtonStyle.WindowsStyle; this.buttonCaptionPanel2.SetCaptionPanelStyle = KJ128WindowsLibrary.CaptionPanelStyleEnum.windowsStyle; this.buttonCaptionPanel2.Size = new System.Drawing.Size(58, 22); this.buttonCaptionPanel2.TabIndex = 19; this.buttonCaptionPanel2.UnEnableStyle = KJ128WindowsLibrary.CaptionPanelStyleEnum.UnEnableWindowsStyle; this.buttonCaptionPanel2.Click += new System.EventHandler(this.buttonCaptionPanel2_Load); // // buttonCaptionPanel1 // this.buttonCaptionPanel1.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Stretch; this.buttonCaptionPanel1.BorderLineColor = System.Drawing.Color.FromArgb(((int)(((byte)(118)))), ((int)(((byte)(153)))), ((int)(((byte)(199))))); this.buttonCaptionPanel1.CaptionBackColor = System.Drawing.Color.FromArgb(((int)(((byte)(184)))), ((int)(((byte)(207)))), ((int)(((byte)(233))))); this.buttonCaptionPanel1.CaptionBackColor1 = System.Drawing.Color.FromArgb(((int)(((byte)(244)))), ((int)(((byte)(248)))), ((int)(((byte)(250))))); this.buttonCaptionPanel1.CaptionBackColor2 = System.Drawing.Color.FromArgb(((int)(((byte)(211)))), ((int)(((byte)(220)))), ((int)(((byte)(233))))); this.buttonCaptionPanel1.CaptionBottomLineColor = System.Drawing.Color.FromArgb(((int)(((byte)(197)))), ((int)(((byte)(197)))), ((int)(((byte)(197))))); this.buttonCaptionPanel1.CaptionBottomLineWidth = 1; this.buttonCaptionPanel1.CaptionCloseButtonControlLeft = 2; this.buttonCaptionPanel1.CaptionCloseButtonForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(192))))); this.buttonCaptionPanel1.CaptionCloseButtonTitle = "×"; this.buttonCaptionPanel1.CaptionFont = new System.Drawing.Font("宋体", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.buttonCaptionPanel1.CaptionForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))); this.buttonCaptionPanel1.CaptionHeight = 20; this.buttonCaptionPanel1.CaptionLeft = 1; this.buttonCaptionPanel1.CaptionPanelLineMode = System.Drawing.Drawing2D.LinearGradientMode.Vertical; this.buttonCaptionPanel1.CaptionTitle = "保存"; this.buttonCaptionPanel1.CaptionTitleLeft = 8; this.buttonCaptionPanel1.CaptionTitleTop = 4; this.buttonCaptionPanel1.CaptionTop = 1; this.buttonCaptionPanel1.Cursor = System.Windows.Forms.Cursors.Hand; this.buttonCaptionPanel1.IsBorderLine = true; this.buttonCaptionPanel1.IsCaptionSingleColor = false; this.buttonCaptionPanel1.IsOnlyCaption = true; this.buttonCaptionPanel1.IsPanelImage = true; this.buttonCaptionPanel1.IsUserButtonClose = false; this.buttonCaptionPanel1.IsUserCaptionBottomLine = false; this.buttonCaptionPanel1.IsUserSystemCloseButtonLeft = true; this.buttonCaptionPanel1.Location = new System.Drawing.Point(18, 314); this.buttonCaptionPanel1.Name = "buttonCaptionPanel1"; this.buttonCaptionPanel1.PanelImage = null; this.buttonCaptionPanel1.SetButtonStyle = KJ128WindowsLibrary.ButtonCaptionPanelButtonStyle.WindowsStyle; this.buttonCaptionPanel1.SetCaptionPanelStyle = KJ128WindowsLibrary.CaptionPanelStyleEnum.windowsStyle; this.buttonCaptionPanel1.Size = new System.Drawing.Size(52, 22); this.buttonCaptionPanel1.TabIndex = 17; this.buttonCaptionPanel1.UnEnableStyle = KJ128WindowsLibrary.CaptionPanelStyleEnum.UnEnableWindowsStyle; this.buttonCaptionPanel1.Click += new System.EventHandler(this.buttonCaptionPanel1_Load); // // dateTimePicker1 // this.dateTimePicker1.Location = new System.Drawing.Point(77, 161); this.dateTimePicker1.Name = "dateTimePicker1"; this.dateTimePicker1.Size = new System.Drawing.Size(105, 20); this.dateTimePicker1.TabIndex = 13; this.dateTimePicker1.Visible = false; // // cbxUserPower // this.cbxUserPower.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; this.cbxUserPower.FormattingEnabled = true; this.cbxUserPower.Location = new System.Drawing.Point(85, 50); this.cbxUserPower.Name = "cbxUserPower"; this.cbxUserPower.Size = new System.Drawing.Size(97, 20); this.cbxUserPower.TabIndex = 12; this.cbxUserPower.Visible = false; // // cbxisEndDATE // this.cbxisEndDATE.AutoSize = true; this.cbxisEndDATE.Location = new System.Drawing.Point(87, 134); this.cbxisEndDATE.Name = "cbxisEndDATE"; this.cbxisEndDATE.Size = new System.Drawing.Size(117, 17); this.cbxisEndDATE.TabIndex = 11; this.cbxisEndDATE.Text = "是否有截止日期"; this.cbxisEndDATE.UseVisualStyleBackColor = true; this.cbxisEndDATE.Visible = false; this.cbxisEndDATE.CheckedChanged += new System.EventHandler(this.cbxisEndDATE_CheckedChanged); // // cbxisUse // this.cbxisUse.AutoSize = true; this.cbxisUse.Location = new System.Drawing.Point(18, 134); this.cbxisUse.Name = "cbxisUse"; this.cbxisUse.Size = new System.Drawing.Size(78, 17); this.cbxisUse.TabIndex = 10; this.cbxisUse.Text = "是否可用"; this.cbxisUse.UseVisualStyleBackColor = true; // // txtRemark // this.txtRemark.Location = new System.Drawing.Point(15, 187); this.txtRemark.Multiline = true; this.txtRemark.Name = "txtRemark"; this.txtRemark.Size = new System.Drawing.Size(167, 104); this.txtRemark.TabIndex = 8; // // label6 // this.label6.AutoSize = true; this.label6.Location = new System.Drawing.Point(15, 168); this.label6.Name = "label6"; this.label6.Size = new System.Drawing.Size(33, 13); this.label6.TabIndex = 6; this.label6.Text = "备注"; // // label5 // this.label5.AutoSize = true; this.label5.Location = new System.Drawing.Point(10, 165); this.label5.Name = "label5"; this.label5.Size = new System.Drawing.Size(59, 13); this.label5.TabIndex = 5; this.label5.Text = "截止日期"; this.label5.Visible = false; // // label2 // this.label2.AutoSize = true; this.label2.Location = new System.Drawing.Point(12, 53); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(72, 13); this.label2.TabIndex = 2; this.label2.Text = "用户组权限"; this.label2.Visible = false; // // txtUser // this.txtUser.Location = new System.Drawing.Point(85, 87); this.txtUser.MaxLength = 20; this.txtUser.Name = "txtUser"; this.txtUser.Size = new System.Drawing.Size(97, 20); this.txtUser.TabIndex = 1; this.txtUser.TextChanged += new System.EventHandler(this.txtUser_TextChanged); // // label1 // this.label1.AutoSize = true; this.label1.Location = new System.Drawing.Point(12, 90); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(46, 13); this.label1.TabIndex = 0; this.label1.Text = "用户组"; // // panel1 // this.panel1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.panel1.Controls.Add(this.buttonCaptionPanel4); this.panel1.Controls.Add(this.buttonCaptionPanel3); this.panel1.Controls.Add(this.label9); this.panel1.Controls.Add(this.dateTimePicker2); this.panel1.Controls.Add(this.cbxUserPower1); this.panel1.Controls.Add(this.cbxisEndDATE1); this.panel1.Controls.Add(this.cbxisUse1); this.panel1.Controls.Add(this.txtRemark1); this.panel1.Controls.Add(this.label3); this.panel1.Controls.Add(this.label4); this.panel1.Controls.Add(this.label7); this.panel1.Controls.Add(this.txtUser1); this.panel1.Controls.Add(this.label8); this.panel1.Location = new System.Drawing.Point(539, 35); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(288, 357); this.panel1.TabIndex = 15; this.panel1.MouseLeave += new System.EventHandler(this.panel1_MouseLeave); this.panel1.MouseDown += new System.Windows.Forms.MouseEventHandler(this.panel1_MouseDown); this.panel1.MouseUp += new System.Windows.Forms.MouseEventHandler(this.panel1_MouseUp); this.panel1.MouseEnter += new System.EventHandler(this.panel1_MouseEnter); // // buttonCaptionPanel4 // this.buttonCaptionPanel4.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Stretch; this.buttonCaptionPanel4.BorderLineColor = System.Drawing.Color.FromArgb(((int)(((byte)(118)))), ((int)(((byte)(153)))), ((int)(((byte)(199))))); this.buttonCaptionPanel4.CaptionBackColor = System.Drawing.Color.FromArgb(((int)(((byte)(184)))), ((int)(((byte)(207)))), ((int)(((byte)(233))))); this.buttonCaptionPanel4.CaptionBackColor1 = System.Drawing.Color.FromArgb(((int)(((byte)(244)))), ((int)(((byte)(248)))), ((int)(((byte)(250))))); this.buttonCaptionPanel4.CaptionBackColor2 = System.Drawing.Color.FromArgb(((int)(((byte)(211)))), ((int)(((byte)(220)))), ((int)(((byte)(233))))); this.buttonCaptionPanel4.CaptionBottomLineColor = System.Drawing.Color.FromArgb(((int)(((byte)(197)))), ((int)(((byte)(197)))), ((int)(((byte)(197))))); this.buttonCaptionPanel4.CaptionBottomLineWidth = 1; this.buttonCaptionPanel4.CaptionCloseButtonControlLeft = 2; this.buttonCaptionPanel4.CaptionCloseButtonForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(192))))); this.buttonCaptionPanel4.CaptionCloseButtonTitle = "×"; this.buttonCaptionPanel4.CaptionFont = new System.Drawing.Font("宋体", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.buttonCaptionPanel4.CaptionForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))); this.buttonCaptionPanel4.CaptionHeight = 20; this.buttonCaptionPanel4.CaptionLeft = 1; this.buttonCaptionPanel4.CaptionPanelLineMode = System.Drawing.Drawing2D.LinearGradientMode.Vertical; this.buttonCaptionPanel4.CaptionTitle = "关闭"; this.buttonCaptionPanel4.CaptionTitleLeft = 8; this.buttonCaptionPanel4.CaptionTitleTop = 4; this.buttonCaptionPanel4.CaptionTop = 1; this.buttonCaptionPanel4.Cursor = System.Windows.Forms.Cursors.Hand; this.buttonCaptionPanel4.IsBorderLine = true; this.buttonCaptionPanel4.IsCaptionSingleColor = false; this.buttonCaptionPanel4.IsOnlyCaption = true; this.buttonCaptionPanel4.IsPanelImage = true; this.buttonCaptionPanel4.IsUserButtonClose = false; this.buttonCaptionPanel4.IsUserCaptionBottomLine = false; this.buttonCaptionPanel4.IsUserSystemCloseButtonLeft = true; this.buttonCaptionPanel4.Location = new System.Drawing.Point(157, 277); this.buttonCaptionPanel4.Name = "buttonCaptionPanel4"; this.buttonCaptionPanel4.PanelImage = null; this.buttonCaptionPanel4.SetButtonStyle = KJ128WindowsLibrary.ButtonCaptionPanelButtonStyle.WindowsStyle; this.buttonCaptionPanel4.SetCaptionPanelStyle = KJ128WindowsLibrary.CaptionPanelStyleEnum.windowsStyle; this.buttonCaptionPanel4.Size = new System.Drawing.Size(69, 22); this.buttonCaptionPanel4.TabIndex = 31; this.buttonCaptionPanel4.UnEnableStyle = KJ128WindowsLibrary.CaptionPanelStyleEnum.UnEnableWindowsStyle; this.buttonCaptionPanel4.Click += new System.EventHandler(this.buttonCaptionPanel4_Load); // // buttonCaptionPanel3 // this.buttonCaptionPanel3.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Stretch; this.buttonCaptionPanel3.BorderLineColor = System.Drawing.Color.FromArgb(((int)(((byte)(118)))), ((int)(((byte)(153)))), ((int)(((byte)(199))))); this.buttonCaptionPanel3.CaptionBackColor = System.Drawing.Color.FromArgb(((int)(((byte)(184)))), ((int)(((byte)(207)))), ((int)(((byte)(233))))); this.buttonCaptionPanel3.CaptionBackColor1 = System.Drawing.Color.FromArgb(((int)(((byte)(244)))), ((int)(((byte)(248)))), ((int)(((byte)(250))))); this.buttonCaptionPanel3.CaptionBackColor2 = System.Drawing.Color.FromArgb(((int)(((byte)(211)))), ((int)(((byte)(220)))), ((int)(((byte)(233))))); this.buttonCaptionPanel3.CaptionBottomLineColor = System.Drawing.Color.FromArgb(((int)(((byte)(197)))), ((int)(((byte)(197)))), ((int)(((byte)(197))))); this.buttonCaptionPanel3.CaptionBottomLineWidth = 1; this.buttonCaptionPanel3.CaptionCloseButtonControlLeft = 2; this.buttonCaptionPanel3.CaptionCloseButtonForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(192))))); this.buttonCaptionPanel3.CaptionCloseButtonTitle = "×"; this.buttonCaptionPanel3.CaptionFont = new System.Drawing.Font("宋体", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.buttonCaptionPanel3.CaptionForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))); this.buttonCaptionPanel3.CaptionHeight = 20; this.buttonCaptionPanel3.CaptionLeft = 1; this.buttonCaptionPanel3.CaptionPanelLineMode = System.Drawing.Drawing2D.LinearGradientMode.Vertical; this.buttonCaptionPanel3.CaptionTitle = "更新"; this.buttonCaptionPanel3.CaptionTitleLeft = 8; this.buttonCaptionPanel3.CaptionTitleTop = 4; this.buttonCaptionPanel3.CaptionTop = 1; this.buttonCaptionPanel3.Cursor = System.Windows.Forms.Cursors.Hand; this.buttonCaptionPanel3.IsBorderLine = true; this.buttonCaptionPanel3.IsCaptionSingleColor = false; this.buttonCaptionPanel3.IsOnlyCaption = true; this.buttonCaptionPanel3.IsPanelImage = true; this.buttonCaptionPanel3.IsUserButtonClose = false; this.buttonCaptionPanel3.IsUserCaptionBottomLine = false; this.buttonCaptionPanel3.IsUserSystemCloseButtonLeft = true; this.buttonCaptionPanel3.Location = new System.Drawing.Point(57, 277); this.buttonCaptionPanel3.Name = "buttonCaptionPanel3"; this.buttonCaptionPanel3.PanelImage = null; this.buttonCaptionPanel3.SetButtonStyle = KJ128WindowsLibrary.ButtonCaptionPanelButtonStyle.WindowsStyle; this.buttonCaptionPanel3.SetCaptionPanelStyle = KJ128WindowsLibrary.CaptionPanelStyleEnum.windowsStyle; this.buttonCaptionPanel3.Size = new System.Drawing.Size(59, 22); this.buttonCaptionPanel3.TabIndex = 30; this.buttonCaptionPanel3.UnEnableStyle = KJ128WindowsLibrary.CaptionPanelStyleEnum.UnEnableWindowsStyle; this.buttonCaptionPanel3.Click += new System.EventHandler(this.buttonCaptionPanel3_Load); // // label9 // this.label9.AutoSize = true; this.label9.Location = new System.Drawing.Point(96, 16); this.label9.Name = "label9"; this.label9.Size = new System.Drawing.Size(65, 12); this.label9.TabIndex = 29; this.label9.Text = "更新用户组"; // // dateTimePicker2 // this.dateTimePicker2.Location = new System.Drawing.Point(124, 144); this.dateTimePicker2.Name = "dateTimePicker2"; this.dateTimePicker2.Size = new System.Drawing.Size(130, 21); this.dateTimePicker2.TabIndex = 26; this.dateTimePicker2.Visible = false; // // cbxUserPower1 // this.cbxUserPower1.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; this.cbxUserPower1.FormattingEnabled = true; this.cbxUserPower1.Location = new System.Drawing.Point(128, 40); this.cbxUserPower1.Name = "cbxUserPower1"; this.cbxUserPower1.Size = new System.Drawing.Size(100, 20); this.cbxUserPower1.TabIndex = 25; this.cbxUserPower1.Visible = false; // // cbxisEndDATE1 // this.cbxisEndDATE1.AutoSize = true; this.cbxisEndDATE1.Location = new System.Drawing.Point(127, 108); this.cbxisEndDATE1.Name = "cbxisEndDATE1"; this.cbxisEndDATE1.Size = new System.Drawing.Size(108, 16); this.cbxisEndDATE1.TabIndex = 24; this.cbxisEndDATE1.Text = "是否有截止日期"; this.cbxisEndDATE1.UseVisualStyleBackColor = true; this.cbxisEndDATE1.Visible = false; // // cbxisUse1 // this.cbxisUse1.AutoSize = true; this.cbxisUse1.Location = new System.Drawing.Point(58, 108); this.cbxisUse1.Name = "cbxisUse1"; this.cbxisUse1.Size = new System.Drawing.Size(72, 16); this.cbxisUse1.TabIndex = 23; this.cbxisUse1.Text = "是否可用"; this.cbxisUse1.UseVisualStyleBackColor = true; // // txtRemark1 // this.txtRemark1.Location = new System.Drawing.Point(77, 171); this.txtRemark1.Multiline = true; this.txtRemark1.Name = "txtRemark1"; this.txtRemark1.Size = new System.Drawing.Size(167, 78); this.txtRemark1.TabIndex = 22; // // label3 // this.label3.AutoSize = true; this.label3.Location = new System.Drawing.Point(55, 150); this.label3.Name = "label3"; this.label3.Size = new System.Drawing.Size(29, 12); this.label3.TabIndex = 21; this.label3.Text = "备注"; // // label4 // this.label4.AutoSize = true; this.label4.Location = new System.Drawing.Point(55, 147); this.label4.Name = "label4"; this.label4.Size = new System.Drawing.Size(53, 12); this.label4.TabIndex = 20; this.label4.Text = "截止日期"; this.label4.Visible = false; // // label7 // this.label7.AutoSize = true; this.label7.Location = new System.Drawing.Point(57, 43); this.label7.Name = "label7"; this.label7.Size = new System.Drawing.Size(65, 12); this.label7.TabIndex = 19; this.label7.Text = "用户组权限"; this.label7.Visible = false; // // txtUser1 // this.txtUser1.Enabled = false; this.txtUser1.Location = new System.Drawing.Point(128, 71); this.txtUser1.MaxLength = 20; this.txtUser1.Name = "txtUser1"; this.txtUser1.Size = new System.Drawing.Size(100, 21); this.txtUser1.TabIndex = 18; // // label8 // this.label8.AutoSize = true; this.label8.Location = new System.Drawing.Point(57, 74); this.label8.Name = "label8"; this.label8.Size = new System.Drawing.Size(41, 12); this.label8.TabIndex = 17; this.label8.Text = "用户组"; // // ids // this.ids.DataPropertyName = "id"; this.ids.HeaderText = "id"; this.ids.Name = "ids"; this.ids.ReadOnly = true; this.ids.Visible = false; // // UGName // this.UGName.DataPropertyName = "UGName"; this.UGName.HeaderText = "用户名"; this.UGName.Name = "UGName"; this.UGName.ReadOnly = true; // // IsEnable // this.IsEnable.DataPropertyName = "IsEnable"; this.IsEnable.HeaderText = "是否可用"; this.IsEnable.Name = "IsEnable"; this.IsEnable.ReadOnly = true; this.IsEnable.Width = 70; // // IsUseEndDate // this.IsUseEndDate.DataPropertyName = "IsUseEndDate"; this.IsUseEndDate.HeaderText = "是否有截止日期"; this.IsUseEndDate.Name = "IsUseEndDate"; this.IsUseEndDate.ReadOnly = true; this.IsUseEndDate.Visible = false; // // UseEndDate // this.UseEndDate.DataPropertyName = "UseEndDate"; dataGridViewCellStyle1.Format = "yyyy-MM-dd"; this.UseEndDate.DefaultCellStyle = dataGridViewCellStyle1; this.UseEndDate.HeaderText = "截止日期"; this.UseEndDate.Name = "UseEndDate"; this.UseEndDate.ReadOnly = true; this.UseEndDate.Visible = false; this.UseEndDate.Width = 70; // // remark // this.remark.DataPropertyName = "remark"; this.remark.HeaderText = "备注"; this.remark.Name = "remark"; this.remark.ReadOnly = true; // // Column6 // this.Column6.FillWeight = 50F; this.Column6.HeaderText = "修改"; this.Column6.Name = "Column6"; this.Column6.ReadOnly = true; this.Column6.Text = "修改"; this.Column6.UseColumnTextForLinkValue = true; this.Column6.Width = 50; // // Column7 // this.Column7.HeaderText = "删除"; this.Column7.Name = "Column7"; this.Column7.ReadOnly = true; this.Column7.Text = "删除"; this.Column7.UseColumnTextForLinkValue = true; this.Column7.Width = 50; // // panel2 // this.panel2.Controls.Add(this.sxpPanel1); this.panel2.Dock = System.Windows.Forms.DockStyle.Left; this.panel2.Location = new System.Drawing.Point(0, 0); this.panel2.Name = "panel2"; this.panel2.Size = new System.Drawing.Size(215, 472); this.panel2.TabIndex = 16; // // sxpPanel1 // this.sxpPanel1.BackColor = System.Drawing.Color.Transparent; this.sxpPanel1.Caption = "用户组管理"; this.sxpPanel1.CaptionCornerType = ((Wilson.Controls.XPPanel.Enums.CornerType)((Wilson.Controls.XPPanel.Enums.CornerType.TopLeft | Wilson.Controls.XPPanel.Enums.CornerType.TopRight))); this.sxpPanel1.CaptionGradient.End = System.Drawing.Color.FromArgb(((int)(((byte)(200)))), ((int)(((byte)(213)))), ((int)(((byte)(247))))); this.sxpPanel1.CaptionGradient.Start = System.Drawing.Color.White; this.sxpPanel1.CaptionGradientMode = System.Drawing.Drawing2D.LinearGradientMode.Horizontal; this.sxpPanel1.CaptionUnderline = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(255)))), ((int)(((byte)(255))))); this.sxpPanel1.Controls.Add(this.lbIssame); this.sxpPanel1.Controls.Add(this.label2); this.sxpPanel1.Controls.Add(this.buttonCaptionPanel2); this.sxpPanel1.Controls.Add(this.groupBox1); this.sxpPanel1.Controls.Add(this.label1); this.sxpPanel1.Controls.Add(this.buttonCaptionPanel1); this.sxpPanel1.Controls.Add(this.txtUser); this.sxpPanel1.Controls.Add(this.dateTimePicker1); this.sxpPanel1.Controls.Add(this.label5); this.sxpPanel1.Controls.Add(this.cbxUserPower); this.sxpPanel1.Controls.Add(this.label6); this.sxpPanel1.Controls.Add(this.cbxisEndDATE); this.sxpPanel1.Controls.Add(this.txtRemark); this.sxpPanel1.Controls.Add(this.cbxisUse); this.sxpPanel1.Dock = System.Windows.Forms.DockStyle.Top; this.sxpPanel1.Font = new System.Drawing.Font("Microsoft Sans Serif", 8F, System.Drawing.FontStyle.Bold); this.sxpPanel1.ForeColor = System.Drawing.SystemColors.WindowText; this.sxpPanel1.HorzAlignment = System.Drawing.StringAlignment.Near; this.sxpPanel1.ImageItems.ImageSet = null; this.sxpPanel1.ImageItems.Normal = -1; this.sxpPanel1.Location = new System.Drawing.Point(0, 0); this.sxpPanel1.Name = "sxpPanel1"; this.sxpPanel1.PanelGradient.End = System.Drawing.Color.FromArgb(((int)(((byte)(214)))), ((int)(((byte)(223)))), ((int)(((byte)(247))))); this.sxpPanel1.PanelGradient.Start = System.Drawing.Color.FromArgb(((int)(((byte)(214)))), ((int)(((byte)(223)))), ((int)(((byte)(247))))); this.sxpPanel1.PanelGradientMode = System.Drawing.Drawing2D.LinearGradientMode.Horizontal; this.sxpPanel1.Size = new System.Drawing.Size(215, 392); this.sxpPanel1.TabIndex = 17; this.sxpPanel1.TextColors.Foreground = System.Drawing.Color.FromArgb(((int)(((byte)(33)))), ((int)(((byte)(93)))), ((int)(((byte)(198))))); this.sxpPanel1.TextHighlightColors.Foreground = System.Drawing.Color.FromArgb(((int)(((byte)(66)))), ((int)(((byte)(142)))), ((int)(((byte)(255))))); this.sxpPanel1.VertAlignment = System.Drawing.StringAlignment.Center; this.sxpPanel1.XPPanelStyle = Wilson.Controls.XPPanel.Enums.XPPanelStyle.WindowsXP; // // dgv_userGroup // dgv_userGroup = new DataGridViewKJ128(); dgv_userGroup.AllowUserToAddRows = false; dgv_userGroup.AllowUserToDeleteRows = false; dataGridViewCellStyle2.BackColor = System.Drawing.Color.White; dgv_userGroup.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle2; dgv_userGroup.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(231)))), ((int)(((byte)(241)))), ((int)(((byte)(251))))); dgv_userGroup.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; dgv_userGroup.ColumnHeadersBorderStyle = System.Windows.Forms.DataGridViewHeaderBorderStyle.Single; dataGridViewCellStyle3.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft; dataGridViewCellStyle3.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(236)))), ((int)(((byte)(251)))), ((int)(((byte)(248))))); dataGridViewCellStyle3.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); dataGridViewCellStyle3.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))); dataGridViewCellStyle3.SelectionBackColor = System.Drawing.SystemColors.Highlight; dataGridViewCellStyle3.SelectionForeColor = System.Drawing.SystemColors.HighlightText; dataGridViewCellStyle3.WrapMode = System.Windows.Forms.DataGridViewTriState.True; dgv_userGroup.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle3; dgv_userGroup.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.DisableResizing; dgv_userGroup.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] { this.ids, this.UGName, this.IsEnable, this.IsUseEndDate, this.UseEndDate, this.remark, this.Column6, this.Column7 }); dgv_userGroup.DataGridShowStype = KJ128NInterfaceShow.DataGridViewKJ128Style.BlueStyle; dgv_userGroup.Dock = System.Windows.Forms.DockStyle.Fill; dgv_userGroup.EnableHeadersVisualStyles = false; dgv_userGroup.GridColor = System.Drawing.Color.FromArgb(((int)(((byte)(184)))), ((int)(((byte)(191)))), ((int)(((byte)(219))))); dgv_userGroup.Location = new System.Drawing.Point(215, 0); dgv_userGroup.Name = "dgv_userGroup"; dgv_userGroup.ReadOnly = true; dataGridViewCellStyle4.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft; dataGridViewCellStyle4.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(245)))), ((int)(((byte)(240)))), ((int)(((byte)(217))))); dataGridViewCellStyle4.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); dataGridViewCellStyle4.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(255))))); dataGridViewCellStyle4.SelectionBackColor = System.Drawing.SystemColors.Highlight; dataGridViewCellStyle4.SelectionForeColor = System.Drawing.SystemColors.HighlightText; dataGridViewCellStyle4.WrapMode = System.Windows.Forms.DataGridViewTriState.True; dgv_userGroup.RowHeadersDefaultCellStyle = dataGridViewCellStyle4; dgv_userGroup.RowHeadersVisible = false; dataGridViewCellStyle5.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(231)))), ((int)(((byte)(241)))), ((int)(((byte)(251))))); dataGridViewCellStyle5.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(49)))), ((int)(((byte)(93)))), ((int)(((byte)(165))))); dataGridViewCellStyle5.SelectionBackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(247)))), ((int)(((byte)(222))))); dataGridViewCellStyle5.SelectionForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(49)))), ((int)(((byte)(93)))), ((int)(((byte)(165))))); dgv_userGroup.RowsDefaultCellStyle = dataGridViewCellStyle5; dgv_userGroup.RowTemplate.Height = 23; dgv_userGroup.Size = new System.Drawing.Size(735, 472); dgv_userGroup.TabIndex = 1; dgv_userGroup.VerticalScrollBarMax = 1; dgv_userGroup.VerticalScrollBarValue = 0; dgv_userGroup.CellContentClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.dataGridViewKJ1281_CellContentClick); // // usergroupInfo // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(215)))), ((int)(((byte)(232)))), ((int)(((byte)(253))))); this.ClientSize = new System.Drawing.Size(950, 472); this.Controls.Add(this.panel1); this.Controls.Add(dgv_userGroup); this.Controls.Add(this.panel2); this.MaximumSize = new System.Drawing.Size(958, 506); this.MinimumSize = new System.Drawing.Size(958, 506); this.Name = "usergroupInfo"; this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; this.TabText = "用户组管理"; this.Text = "用户组管理"; this.Load += new System.EventHandler(this.usergroupInfo_Load); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); this.panel2.ResumeLayout(false); this.sxpPanel1.ResumeLayout(false); this.sxpPanel1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(dgv_userGroup)).EndInit(); this.ResumeLayout(false); }
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); }
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 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); }
/// <summary> /// 设计器支持所需的方法 - 不要 /// 使用代码编辑器修改此方法的内容。 /// </summary> private void InitializeComponent() { System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle(); System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 = new System.Windows.Forms.DataGridViewCellStyle(); System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle3 = new System.Windows.Forms.DataGridViewCellStyle(); System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle4 = new System.Windows.Forms.DataGridViewCellStyle(); System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle5 = new System.Windows.Forms.DataGridViewCellStyle(); this.groupBox1 = new System.Windows.Forms.GroupBox(); this.lbIssame = new System.Windows.Forms.Label(); this.buttonCaptionPanel2 = new KJ128WindowsLibrary.ButtonCaptionPanel(); this.buttonCaptionPanel1 = new KJ128WindowsLibrary.ButtonCaptionPanel(); this.dateTimePicker1 = new System.Windows.Forms.DateTimePicker(); this.cbxUserPower = new System.Windows.Forms.ComboBox(); this.cbxisEndDATE = new System.Windows.Forms.CheckBox(); this.cbxisUse = new System.Windows.Forms.CheckBox(); this.txtRemark = new Shine.ShineTextBox(); this.label6 = new System.Windows.Forms.Label(); this.label5 = new System.Windows.Forms.Label(); this.label2 = new System.Windows.Forms.Label(); this.txtUser = new Shine.ShineTextBox(); this.label1 = new System.Windows.Forms.Label(); this.panel1 = new System.Windows.Forms.Panel(); this.buttonCaptionPanel4 = new KJ128WindowsLibrary.ButtonCaptionPanel(); this.buttonCaptionPanel3 = new KJ128WindowsLibrary.ButtonCaptionPanel(); this.label9 = new System.Windows.Forms.Label(); this.dateTimePicker2 = new System.Windows.Forms.DateTimePicker(); this.cbxUserPower1 = new System.Windows.Forms.ComboBox(); this.cbxisEndDATE1 = new System.Windows.Forms.CheckBox(); this.cbxisUse1 = new System.Windows.Forms.CheckBox(); this.txtRemark1 = new Shine.ShineTextBox(); this.label3 = new System.Windows.Forms.Label(); this.label4 = new System.Windows.Forms.Label(); this.label7 = new System.Windows.Forms.Label(); this.txtUser1 = new Shine.ShineTextBox(); this.label8 = new System.Windows.Forms.Label(); this.ids = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.UGName = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.IsEnable = new System.Windows.Forms.DataGridViewCheckBoxColumn(); this.IsUseEndDate = new System.Windows.Forms.DataGridViewCheckBoxColumn(); this.UseEndDate = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.remark = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.Column6 = new System.Windows.Forms.DataGridViewLinkColumn(); this.Column7 = new System.Windows.Forms.DataGridViewLinkColumn(); this.panel2 = new System.Windows.Forms.Panel(); this.sxpPanel1 = new Wilson.Controls.XPPanel.SXPPanel(); dgv_userGroup = new KJ128NInterfaceShow.DataGridViewKJ128(); this.panel1.SuspendLayout(); this.panel2.SuspendLayout(); this.sxpPanel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(dgv_userGroup)).BeginInit(); this.SuspendLayout(); // // groupBox1 // this.groupBox1.Location = new System.Drawing.Point(96, 3); this.groupBox1.Name = "groupBox1"; this.groupBox1.Size = new System.Drawing.Size(48, 23); this.groupBox1.TabIndex = 0; this.groupBox1.TabStop = false; this.groupBox1.Text = "添加"; this.groupBox1.Visible = false; // // lbIssame // this.lbIssame.AutoSize = true; this.lbIssame.ForeColor = System.Drawing.Color.Red; this.lbIssame.Location = new System.Drawing.Point(185, 91); this.lbIssame.Name = "lbIssame"; this.lbIssame.Size = new System.Drawing.Size(0, 13); this.lbIssame.TabIndex = 63; // // buttonCaptionPanel2 // this.buttonCaptionPanel2.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Stretch; this.buttonCaptionPanel2.BorderLineColor = System.Drawing.Color.FromArgb(((int)(((byte)(118)))), ((int)(((byte)(153)))), ((int)(((byte)(199))))); this.buttonCaptionPanel2.CaptionBackColor = System.Drawing.Color.FromArgb(((int)(((byte)(184)))), ((int)(((byte)(207)))), ((int)(((byte)(233))))); this.buttonCaptionPanel2.CaptionBackColor1 = System.Drawing.Color.FromArgb(((int)(((byte)(244)))), ((int)(((byte)(248)))), ((int)(((byte)(250))))); this.buttonCaptionPanel2.CaptionBackColor2 = System.Drawing.Color.FromArgb(((int)(((byte)(211)))), ((int)(((byte)(220)))), ((int)(((byte)(233))))); this.buttonCaptionPanel2.CaptionBottomLineColor = System.Drawing.Color.FromArgb(((int)(((byte)(197)))), ((int)(((byte)(197)))), ((int)(((byte)(197))))); this.buttonCaptionPanel2.CaptionBottomLineWidth = 1; this.buttonCaptionPanel2.CaptionCloseButtonControlLeft = 2; this.buttonCaptionPanel2.CaptionCloseButtonForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(192))))); this.buttonCaptionPanel2.CaptionCloseButtonTitle = "×"; this.buttonCaptionPanel2.CaptionFont = new System.Drawing.Font("宋体", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.buttonCaptionPanel2.CaptionForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))); this.buttonCaptionPanel2.CaptionHeight = 20; this.buttonCaptionPanel2.CaptionLeft = 1; this.buttonCaptionPanel2.CaptionPanelLineMode = System.Drawing.Drawing2D.LinearGradientMode.Vertical; this.buttonCaptionPanel2.CaptionTitle = "取消"; this.buttonCaptionPanel2.CaptionTitleLeft = 8; this.buttonCaptionPanel2.CaptionTitleTop = 4; this.buttonCaptionPanel2.CaptionTop = 1; this.buttonCaptionPanel2.Cursor = System.Windows.Forms.Cursors.Hand; this.buttonCaptionPanel2.IsBorderLine = true; this.buttonCaptionPanel2.IsCaptionSingleColor = false; this.buttonCaptionPanel2.IsOnlyCaption = true; this.buttonCaptionPanel2.IsPanelImage = true; this.buttonCaptionPanel2.IsUserButtonClose = false; this.buttonCaptionPanel2.IsUserCaptionBottomLine = false; this.buttonCaptionPanel2.IsUserSystemCloseButtonLeft = true; this.buttonCaptionPanel2.Location = new System.Drawing.Point(117, 314); this.buttonCaptionPanel2.Name = "buttonCaptionPanel2"; this.buttonCaptionPanel2.PanelImage = null; this.buttonCaptionPanel2.SetButtonStyle = KJ128WindowsLibrary.ButtonCaptionPanelButtonStyle.WindowsStyle; this.buttonCaptionPanel2.SetCaptionPanelStyle = KJ128WindowsLibrary.CaptionPanelStyleEnum.windowsStyle; this.buttonCaptionPanel2.Size = new System.Drawing.Size(58, 22); this.buttonCaptionPanel2.TabIndex = 19; this.buttonCaptionPanel2.UnEnableStyle = KJ128WindowsLibrary.CaptionPanelStyleEnum.UnEnableWindowsStyle; this.buttonCaptionPanel2.Click += new System.EventHandler(this.buttonCaptionPanel2_Load); // // buttonCaptionPanel1 // this.buttonCaptionPanel1.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Stretch; this.buttonCaptionPanel1.BorderLineColor = System.Drawing.Color.FromArgb(((int)(((byte)(118)))), ((int)(((byte)(153)))), ((int)(((byte)(199))))); this.buttonCaptionPanel1.CaptionBackColor = System.Drawing.Color.FromArgb(((int)(((byte)(184)))), ((int)(((byte)(207)))), ((int)(((byte)(233))))); this.buttonCaptionPanel1.CaptionBackColor1 = System.Drawing.Color.FromArgb(((int)(((byte)(244)))), ((int)(((byte)(248)))), ((int)(((byte)(250))))); this.buttonCaptionPanel1.CaptionBackColor2 = System.Drawing.Color.FromArgb(((int)(((byte)(211)))), ((int)(((byte)(220)))), ((int)(((byte)(233))))); this.buttonCaptionPanel1.CaptionBottomLineColor = System.Drawing.Color.FromArgb(((int)(((byte)(197)))), ((int)(((byte)(197)))), ((int)(((byte)(197))))); this.buttonCaptionPanel1.CaptionBottomLineWidth = 1; this.buttonCaptionPanel1.CaptionCloseButtonControlLeft = 2; this.buttonCaptionPanel1.CaptionCloseButtonForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(192))))); this.buttonCaptionPanel1.CaptionCloseButtonTitle = "×"; this.buttonCaptionPanel1.CaptionFont = new System.Drawing.Font("宋体", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.buttonCaptionPanel1.CaptionForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))); this.buttonCaptionPanel1.CaptionHeight = 20; this.buttonCaptionPanel1.CaptionLeft = 1; this.buttonCaptionPanel1.CaptionPanelLineMode = System.Drawing.Drawing2D.LinearGradientMode.Vertical; this.buttonCaptionPanel1.CaptionTitle = "保存"; this.buttonCaptionPanel1.CaptionTitleLeft = 8; this.buttonCaptionPanel1.CaptionTitleTop = 4; this.buttonCaptionPanel1.CaptionTop = 1; this.buttonCaptionPanel1.Cursor = System.Windows.Forms.Cursors.Hand; this.buttonCaptionPanel1.IsBorderLine = true; this.buttonCaptionPanel1.IsCaptionSingleColor = false; this.buttonCaptionPanel1.IsOnlyCaption = true; this.buttonCaptionPanel1.IsPanelImage = true; this.buttonCaptionPanel1.IsUserButtonClose = false; this.buttonCaptionPanel1.IsUserCaptionBottomLine = false; this.buttonCaptionPanel1.IsUserSystemCloseButtonLeft = true; this.buttonCaptionPanel1.Location = new System.Drawing.Point(18, 314); this.buttonCaptionPanel1.Name = "buttonCaptionPanel1"; this.buttonCaptionPanel1.PanelImage = null; this.buttonCaptionPanel1.SetButtonStyle = KJ128WindowsLibrary.ButtonCaptionPanelButtonStyle.WindowsStyle; this.buttonCaptionPanel1.SetCaptionPanelStyle = KJ128WindowsLibrary.CaptionPanelStyleEnum.windowsStyle; this.buttonCaptionPanel1.Size = new System.Drawing.Size(52, 22); this.buttonCaptionPanel1.TabIndex = 17; this.buttonCaptionPanel1.UnEnableStyle = KJ128WindowsLibrary.CaptionPanelStyleEnum.UnEnableWindowsStyle; this.buttonCaptionPanel1.Click += new System.EventHandler(this.buttonCaptionPanel1_Load); // // dateTimePicker1 // this.dateTimePicker1.Location = new System.Drawing.Point(77, 161); this.dateTimePicker1.Name = "dateTimePicker1"; this.dateTimePicker1.Size = new System.Drawing.Size(105, 20); this.dateTimePicker1.TabIndex = 13; this.dateTimePicker1.Visible = false; // // cbxUserPower // this.cbxUserPower.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; this.cbxUserPower.FormattingEnabled = true; this.cbxUserPower.Location = new System.Drawing.Point(85, 50); this.cbxUserPower.Name = "cbxUserPower"; this.cbxUserPower.Size = new System.Drawing.Size(97, 20); this.cbxUserPower.TabIndex = 12; this.cbxUserPower.Visible = false; // // cbxisEndDATE // this.cbxisEndDATE.AutoSize = true; this.cbxisEndDATE.Location = new System.Drawing.Point(87, 134); this.cbxisEndDATE.Name = "cbxisEndDATE"; this.cbxisEndDATE.Size = new System.Drawing.Size(117, 17); this.cbxisEndDATE.TabIndex = 11; this.cbxisEndDATE.Text = "是否有截止日期"; this.cbxisEndDATE.UseVisualStyleBackColor = true; this.cbxisEndDATE.Visible = false; this.cbxisEndDATE.CheckedChanged += new System.EventHandler(this.cbxisEndDATE_CheckedChanged); // // cbxisUse // this.cbxisUse.AutoSize = true; this.cbxisUse.Location = new System.Drawing.Point(18, 134); this.cbxisUse.Name = "cbxisUse"; this.cbxisUse.Size = new System.Drawing.Size(78, 17); this.cbxisUse.TabIndex = 10; this.cbxisUse.Text = "是否可用"; this.cbxisUse.UseVisualStyleBackColor = true; // // txtRemark // this.txtRemark.Location = new System.Drawing.Point(15, 187); this.txtRemark.Multiline = true; this.txtRemark.Name = "txtRemark"; this.txtRemark.Size = new System.Drawing.Size(167, 104); this.txtRemark.TabIndex = 8; // // label6 // this.label6.AutoSize = true; this.label6.Location = new System.Drawing.Point(15, 168); this.label6.Name = "label6"; this.label6.Size = new System.Drawing.Size(33, 13); this.label6.TabIndex = 6; this.label6.Text = "备注"; // // label5 // this.label5.AutoSize = true; this.label5.Location = new System.Drawing.Point(10, 165); this.label5.Name = "label5"; this.label5.Size = new System.Drawing.Size(59, 13); this.label5.TabIndex = 5; this.label5.Text = "截止日期"; this.label5.Visible = false; // // label2 // this.label2.AutoSize = true; this.label2.Location = new System.Drawing.Point(12, 53); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(72, 13); this.label2.TabIndex = 2; this.label2.Text = "用户组权限"; this.label2.Visible = false; // // txtUser // this.txtUser.Location = new System.Drawing.Point(85, 87); this.txtUser.MaxLength = 20; this.txtUser.Name = "txtUser"; this.txtUser.Size = new System.Drawing.Size(97, 20); this.txtUser.TabIndex = 1; this.txtUser.TextChanged += new System.EventHandler(this.txtUser_TextChanged); // // label1 // this.label1.AutoSize = true; this.label1.Location = new System.Drawing.Point(12, 90); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(46, 13); this.label1.TabIndex = 0; this.label1.Text = "用户组"; // // panel1 // this.panel1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.panel1.Controls.Add(this.buttonCaptionPanel4); this.panel1.Controls.Add(this.buttonCaptionPanel3); this.panel1.Controls.Add(this.label9); this.panel1.Controls.Add(this.dateTimePicker2); this.panel1.Controls.Add(this.cbxUserPower1); this.panel1.Controls.Add(this.cbxisEndDATE1); this.panel1.Controls.Add(this.cbxisUse1); this.panel1.Controls.Add(this.txtRemark1); this.panel1.Controls.Add(this.label3); this.panel1.Controls.Add(this.label4); this.panel1.Controls.Add(this.label7); this.panel1.Controls.Add(this.txtUser1); this.panel1.Controls.Add(this.label8); this.panel1.Location = new System.Drawing.Point(539, 35); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(288, 357); this.panel1.TabIndex = 15; this.panel1.MouseLeave += new System.EventHandler(this.panel1_MouseLeave); this.panel1.MouseDown += new System.Windows.Forms.MouseEventHandler(this.panel1_MouseDown); this.panel1.MouseUp += new System.Windows.Forms.MouseEventHandler(this.panel1_MouseUp); this.panel1.MouseEnter += new System.EventHandler(this.panel1_MouseEnter); // // buttonCaptionPanel4 // this.buttonCaptionPanel4.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Stretch; this.buttonCaptionPanel4.BorderLineColor = System.Drawing.Color.FromArgb(((int)(((byte)(118)))), ((int)(((byte)(153)))), ((int)(((byte)(199))))); this.buttonCaptionPanel4.CaptionBackColor = System.Drawing.Color.FromArgb(((int)(((byte)(184)))), ((int)(((byte)(207)))), ((int)(((byte)(233))))); this.buttonCaptionPanel4.CaptionBackColor1 = System.Drawing.Color.FromArgb(((int)(((byte)(244)))), ((int)(((byte)(248)))), ((int)(((byte)(250))))); this.buttonCaptionPanel4.CaptionBackColor2 = System.Drawing.Color.FromArgb(((int)(((byte)(211)))), ((int)(((byte)(220)))), ((int)(((byte)(233))))); this.buttonCaptionPanel4.CaptionBottomLineColor = System.Drawing.Color.FromArgb(((int)(((byte)(197)))), ((int)(((byte)(197)))), ((int)(((byte)(197))))); this.buttonCaptionPanel4.CaptionBottomLineWidth = 1; this.buttonCaptionPanel4.CaptionCloseButtonControlLeft = 2; this.buttonCaptionPanel4.CaptionCloseButtonForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(192))))); this.buttonCaptionPanel4.CaptionCloseButtonTitle = "×"; this.buttonCaptionPanel4.CaptionFont = new System.Drawing.Font("宋体", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.buttonCaptionPanel4.CaptionForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))); this.buttonCaptionPanel4.CaptionHeight = 20; this.buttonCaptionPanel4.CaptionLeft = 1; this.buttonCaptionPanel4.CaptionPanelLineMode = System.Drawing.Drawing2D.LinearGradientMode.Vertical; this.buttonCaptionPanel4.CaptionTitle = "关闭"; this.buttonCaptionPanel4.CaptionTitleLeft = 8; this.buttonCaptionPanel4.CaptionTitleTop = 4; this.buttonCaptionPanel4.CaptionTop = 1; this.buttonCaptionPanel4.Cursor = System.Windows.Forms.Cursors.Hand; this.buttonCaptionPanel4.IsBorderLine = true; this.buttonCaptionPanel4.IsCaptionSingleColor = false; this.buttonCaptionPanel4.IsOnlyCaption = true; this.buttonCaptionPanel4.IsPanelImage = true; this.buttonCaptionPanel4.IsUserButtonClose = false; this.buttonCaptionPanel4.IsUserCaptionBottomLine = false; this.buttonCaptionPanel4.IsUserSystemCloseButtonLeft = true; this.buttonCaptionPanel4.Location = new System.Drawing.Point(157, 277); this.buttonCaptionPanel4.Name = "buttonCaptionPanel4"; this.buttonCaptionPanel4.PanelImage = null; this.buttonCaptionPanel4.SetButtonStyle = KJ128WindowsLibrary.ButtonCaptionPanelButtonStyle.WindowsStyle; this.buttonCaptionPanel4.SetCaptionPanelStyle = KJ128WindowsLibrary.CaptionPanelStyleEnum.windowsStyle; this.buttonCaptionPanel4.Size = new System.Drawing.Size(69, 22); this.buttonCaptionPanel4.TabIndex = 31; this.buttonCaptionPanel4.UnEnableStyle = KJ128WindowsLibrary.CaptionPanelStyleEnum.UnEnableWindowsStyle; this.buttonCaptionPanel4.Click += new System.EventHandler(this.buttonCaptionPanel4_Load); // // buttonCaptionPanel3 // this.buttonCaptionPanel3.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Stretch; this.buttonCaptionPanel3.BorderLineColor = System.Drawing.Color.FromArgb(((int)(((byte)(118)))), ((int)(((byte)(153)))), ((int)(((byte)(199))))); this.buttonCaptionPanel3.CaptionBackColor = System.Drawing.Color.FromArgb(((int)(((byte)(184)))), ((int)(((byte)(207)))), ((int)(((byte)(233))))); this.buttonCaptionPanel3.CaptionBackColor1 = System.Drawing.Color.FromArgb(((int)(((byte)(244)))), ((int)(((byte)(248)))), ((int)(((byte)(250))))); this.buttonCaptionPanel3.CaptionBackColor2 = System.Drawing.Color.FromArgb(((int)(((byte)(211)))), ((int)(((byte)(220)))), ((int)(((byte)(233))))); this.buttonCaptionPanel3.CaptionBottomLineColor = System.Drawing.Color.FromArgb(((int)(((byte)(197)))), ((int)(((byte)(197)))), ((int)(((byte)(197))))); this.buttonCaptionPanel3.CaptionBottomLineWidth = 1; this.buttonCaptionPanel3.CaptionCloseButtonControlLeft = 2; this.buttonCaptionPanel3.CaptionCloseButtonForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(192))))); this.buttonCaptionPanel3.CaptionCloseButtonTitle = "×"; this.buttonCaptionPanel3.CaptionFont = new System.Drawing.Font("宋体", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.buttonCaptionPanel3.CaptionForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))); this.buttonCaptionPanel3.CaptionHeight = 20; this.buttonCaptionPanel3.CaptionLeft = 1; this.buttonCaptionPanel3.CaptionPanelLineMode = System.Drawing.Drawing2D.LinearGradientMode.Vertical; this.buttonCaptionPanel3.CaptionTitle = "更新"; this.buttonCaptionPanel3.CaptionTitleLeft = 8; this.buttonCaptionPanel3.CaptionTitleTop = 4; this.buttonCaptionPanel3.CaptionTop = 1; this.buttonCaptionPanel3.Cursor = System.Windows.Forms.Cursors.Hand; this.buttonCaptionPanel3.IsBorderLine = true; this.buttonCaptionPanel3.IsCaptionSingleColor = false; this.buttonCaptionPanel3.IsOnlyCaption = true; this.buttonCaptionPanel3.IsPanelImage = true; this.buttonCaptionPanel3.IsUserButtonClose = false; this.buttonCaptionPanel3.IsUserCaptionBottomLine = false; this.buttonCaptionPanel3.IsUserSystemCloseButtonLeft = true; this.buttonCaptionPanel3.Location = new System.Drawing.Point(57, 277); this.buttonCaptionPanel3.Name = "buttonCaptionPanel3"; this.buttonCaptionPanel3.PanelImage = null; this.buttonCaptionPanel3.SetButtonStyle = KJ128WindowsLibrary.ButtonCaptionPanelButtonStyle.WindowsStyle; this.buttonCaptionPanel3.SetCaptionPanelStyle = KJ128WindowsLibrary.CaptionPanelStyleEnum.windowsStyle; this.buttonCaptionPanel3.Size = new System.Drawing.Size(59, 22); this.buttonCaptionPanel3.TabIndex = 30; this.buttonCaptionPanel3.UnEnableStyle = KJ128WindowsLibrary.CaptionPanelStyleEnum.UnEnableWindowsStyle; this.buttonCaptionPanel3.Click += new System.EventHandler(this.buttonCaptionPanel3_Load); // // label9 // this.label9.AutoSize = true; this.label9.Location = new System.Drawing.Point(96, 16); this.label9.Name = "label9"; this.label9.Size = new System.Drawing.Size(65, 12); this.label9.TabIndex = 29; this.label9.Text = "更新用户组"; // // dateTimePicker2 // this.dateTimePicker2.Location = new System.Drawing.Point(124, 144); this.dateTimePicker2.Name = "dateTimePicker2"; this.dateTimePicker2.Size = new System.Drawing.Size(130, 21); this.dateTimePicker2.TabIndex = 26; this.dateTimePicker2.Visible = false; // // cbxUserPower1 // this.cbxUserPower1.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; this.cbxUserPower1.FormattingEnabled = true; this.cbxUserPower1.Location = new System.Drawing.Point(128, 40); this.cbxUserPower1.Name = "cbxUserPower1"; this.cbxUserPower1.Size = new System.Drawing.Size(100, 20); this.cbxUserPower1.TabIndex = 25; this.cbxUserPower1.Visible = false; // // cbxisEndDATE1 // this.cbxisEndDATE1.AutoSize = true; this.cbxisEndDATE1.Location = new System.Drawing.Point(127, 108); this.cbxisEndDATE1.Name = "cbxisEndDATE1"; this.cbxisEndDATE1.Size = new System.Drawing.Size(108, 16); this.cbxisEndDATE1.TabIndex = 24; this.cbxisEndDATE1.Text = "是否有截止日期"; this.cbxisEndDATE1.UseVisualStyleBackColor = true; this.cbxisEndDATE1.Visible = false; // // cbxisUse1 // this.cbxisUse1.AutoSize = true; this.cbxisUse1.Location = new System.Drawing.Point(58, 108); this.cbxisUse1.Name = "cbxisUse1"; this.cbxisUse1.Size = new System.Drawing.Size(72, 16); this.cbxisUse1.TabIndex = 23; this.cbxisUse1.Text = "是否可用"; this.cbxisUse1.UseVisualStyleBackColor = true; // // txtRemark1 // this.txtRemark1.Location = new System.Drawing.Point(77, 171); this.txtRemark1.Multiline = true; this.txtRemark1.Name = "txtRemark1"; this.txtRemark1.Size = new System.Drawing.Size(167, 78); this.txtRemark1.TabIndex = 22; // // label3 // this.label3.AutoSize = true; this.label3.Location = new System.Drawing.Point(55, 150); this.label3.Name = "label3"; this.label3.Size = new System.Drawing.Size(29, 12); this.label3.TabIndex = 21; this.label3.Text = "备注"; // // label4 // this.label4.AutoSize = true; this.label4.Location = new System.Drawing.Point(55, 147); this.label4.Name = "label4"; this.label4.Size = new System.Drawing.Size(53, 12); this.label4.TabIndex = 20; this.label4.Text = "截止日期"; this.label4.Visible = false; // // label7 // this.label7.AutoSize = true; this.label7.Location = new System.Drawing.Point(57, 43); this.label7.Name = "label7"; this.label7.Size = new System.Drawing.Size(65, 12); this.label7.TabIndex = 19; this.label7.Text = "用户组权限"; this.label7.Visible = false; // // txtUser1 // this.txtUser1.Enabled = false; this.txtUser1.Location = new System.Drawing.Point(128, 71); this.txtUser1.MaxLength = 20; this.txtUser1.Name = "txtUser1"; this.txtUser1.Size = new System.Drawing.Size(100, 21); this.txtUser1.TabIndex = 18; // // label8 // this.label8.AutoSize = true; this.label8.Location = new System.Drawing.Point(57, 74); this.label8.Name = "label8"; this.label8.Size = new System.Drawing.Size(41, 12); this.label8.TabIndex = 17; this.label8.Text = "用户组"; // // ids // this.ids.DataPropertyName = "id"; this.ids.HeaderText = "id"; this.ids.Name = "ids"; this.ids.ReadOnly = true; this.ids.Visible = false; // // UGName // this.UGName.DataPropertyName = "UGName"; this.UGName.HeaderText = "用户名"; this.UGName.Name = "UGName"; this.UGName.ReadOnly = true; // // IsEnable // this.IsEnable.DataPropertyName = "IsEnable"; this.IsEnable.HeaderText = "是否可用"; this.IsEnable.Name = "IsEnable"; this.IsEnable.ReadOnly = true; this.IsEnable.Width = 70; // // IsUseEndDate // this.IsUseEndDate.DataPropertyName = "IsUseEndDate"; this.IsUseEndDate.HeaderText = "是否有截止日期"; this.IsUseEndDate.Name = "IsUseEndDate"; this.IsUseEndDate.ReadOnly = true; this.IsUseEndDate.Visible = false; // // UseEndDate // this.UseEndDate.DataPropertyName = "UseEndDate"; dataGridViewCellStyle1.Format = "yyyy-MM-dd"; this.UseEndDate.DefaultCellStyle = dataGridViewCellStyle1; this.UseEndDate.HeaderText = "截止日期"; this.UseEndDate.Name = "UseEndDate"; this.UseEndDate.ReadOnly = true; this.UseEndDate.Visible = false; this.UseEndDate.Width = 70; // // remark // this.remark.DataPropertyName = "remark"; this.remark.HeaderText = "备注"; this.remark.Name = "remark"; this.remark.ReadOnly = true; // // Column6 // this.Column6.FillWeight = 50F; this.Column6.HeaderText = "修改"; this.Column6.Name = "Column6"; this.Column6.ReadOnly = true; this.Column6.Text = "修改"; this.Column6.UseColumnTextForLinkValue = true; this.Column6.Width = 50; // // Column7 // this.Column7.HeaderText = "删除"; this.Column7.Name = "Column7"; this.Column7.ReadOnly = true; this.Column7.Text = "删除"; this.Column7.UseColumnTextForLinkValue = true; this.Column7.Width = 50; // // panel2 // this.panel2.Controls.Add(this.sxpPanel1); this.panel2.Dock = System.Windows.Forms.DockStyle.Left; this.panel2.Location = new System.Drawing.Point(0, 0); this.panel2.Name = "panel2"; this.panel2.Size = new System.Drawing.Size(215, 472); this.panel2.TabIndex = 16; // // sxpPanel1 // this.sxpPanel1.BackColor = System.Drawing.Color.Transparent; this.sxpPanel1.Caption = "用户组管理"; this.sxpPanel1.CaptionCornerType = ((Wilson.Controls.XPPanel.Enums.CornerType)((Wilson.Controls.XPPanel.Enums.CornerType.TopLeft | Wilson.Controls.XPPanel.Enums.CornerType.TopRight))); this.sxpPanel1.CaptionGradient.End = System.Drawing.Color.FromArgb(((int)(((byte)(200)))), ((int)(((byte)(213)))), ((int)(((byte)(247))))); this.sxpPanel1.CaptionGradient.Start = System.Drawing.Color.White; this.sxpPanel1.CaptionGradientMode = System.Drawing.Drawing2D.LinearGradientMode.Horizontal; this.sxpPanel1.CaptionUnderline = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(255)))), ((int)(((byte)(255))))); this.sxpPanel1.Controls.Add(this.lbIssame); this.sxpPanel1.Controls.Add(this.label2); this.sxpPanel1.Controls.Add(this.buttonCaptionPanel2); this.sxpPanel1.Controls.Add(this.groupBox1); this.sxpPanel1.Controls.Add(this.label1); this.sxpPanel1.Controls.Add(this.buttonCaptionPanel1); this.sxpPanel1.Controls.Add(this.txtUser); this.sxpPanel1.Controls.Add(this.dateTimePicker1); this.sxpPanel1.Controls.Add(this.label5); this.sxpPanel1.Controls.Add(this.cbxUserPower); this.sxpPanel1.Controls.Add(this.label6); this.sxpPanel1.Controls.Add(this.cbxisEndDATE); this.sxpPanel1.Controls.Add(this.txtRemark); this.sxpPanel1.Controls.Add(this.cbxisUse); this.sxpPanel1.Dock = System.Windows.Forms.DockStyle.Top; this.sxpPanel1.Font = new System.Drawing.Font("Microsoft Sans Serif", 8F, System.Drawing.FontStyle.Bold); this.sxpPanel1.ForeColor = System.Drawing.SystemColors.WindowText; this.sxpPanel1.HorzAlignment = System.Drawing.StringAlignment.Near; this.sxpPanel1.ImageItems.ImageSet = null; this.sxpPanel1.ImageItems.Normal = -1; this.sxpPanel1.Location = new System.Drawing.Point(0, 0); this.sxpPanel1.Name = "sxpPanel1"; this.sxpPanel1.PanelGradient.End = System.Drawing.Color.FromArgb(((int)(((byte)(214)))), ((int)(((byte)(223)))), ((int)(((byte)(247))))); this.sxpPanel1.PanelGradient.Start = System.Drawing.Color.FromArgb(((int)(((byte)(214)))), ((int)(((byte)(223)))), ((int)(((byte)(247))))); this.sxpPanel1.PanelGradientMode = System.Drawing.Drawing2D.LinearGradientMode.Horizontal; this.sxpPanel1.Size = new System.Drawing.Size(215, 392); this.sxpPanel1.TabIndex = 17; this.sxpPanel1.TextColors.Foreground = System.Drawing.Color.FromArgb(((int)(((byte)(33)))), ((int)(((byte)(93)))), ((int)(((byte)(198))))); this.sxpPanel1.TextHighlightColors.Foreground = System.Drawing.Color.FromArgb(((int)(((byte)(66)))), ((int)(((byte)(142)))), ((int)(((byte)(255))))); this.sxpPanel1.VertAlignment = System.Drawing.StringAlignment.Center; this.sxpPanel1.XPPanelStyle = Wilson.Controls.XPPanel.Enums.XPPanelStyle.WindowsXP; // // dgv_userGroup // dgv_userGroup = new DataGridViewKJ128(); dgv_userGroup.AllowUserToAddRows = false; dgv_userGroup.AllowUserToDeleteRows = false; dataGridViewCellStyle2.BackColor = System.Drawing.Color.White; dgv_userGroup.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle2; dgv_userGroup.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(231)))), ((int)(((byte)(241)))), ((int)(((byte)(251))))); dgv_userGroup.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; dgv_userGroup.ColumnHeadersBorderStyle = System.Windows.Forms.DataGridViewHeaderBorderStyle.Single; dataGridViewCellStyle3.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft; dataGridViewCellStyle3.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(236)))), ((int)(((byte)(251)))), ((int)(((byte)(248))))); dataGridViewCellStyle3.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); dataGridViewCellStyle3.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))); dataGridViewCellStyle3.SelectionBackColor = System.Drawing.SystemColors.Highlight; dataGridViewCellStyle3.SelectionForeColor = System.Drawing.SystemColors.HighlightText; dataGridViewCellStyle3.WrapMode = System.Windows.Forms.DataGridViewTriState.True; dgv_userGroup.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle3; dgv_userGroup.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.DisableResizing; dgv_userGroup.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] { this.ids, this.UGName, this.IsEnable, this.IsUseEndDate, this.UseEndDate, this.remark, this.Column6, this.Column7}); dgv_userGroup.DataGridShowStype = KJ128NInterfaceShow.DataGridViewKJ128Style.BlueStyle; dgv_userGroup.Dock = System.Windows.Forms.DockStyle.Fill; dgv_userGroup.EnableHeadersVisualStyles = false; dgv_userGroup.GridColor = System.Drawing.Color.FromArgb(((int)(((byte)(184)))), ((int)(((byte)(191)))), ((int)(((byte)(219))))); dgv_userGroup.Location = new System.Drawing.Point(215, 0); dgv_userGroup.Name = "dgv_userGroup"; dgv_userGroup.ReadOnly = true; dataGridViewCellStyle4.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft; dataGridViewCellStyle4.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(245)))), ((int)(((byte)(240)))), ((int)(((byte)(217))))); dataGridViewCellStyle4.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); dataGridViewCellStyle4.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(255))))); dataGridViewCellStyle4.SelectionBackColor = System.Drawing.SystemColors.Highlight; dataGridViewCellStyle4.SelectionForeColor = System.Drawing.SystemColors.HighlightText; dataGridViewCellStyle4.WrapMode = System.Windows.Forms.DataGridViewTriState.True; dgv_userGroup.RowHeadersDefaultCellStyle = dataGridViewCellStyle4; dgv_userGroup.RowHeadersVisible = false; dataGridViewCellStyle5.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(231)))), ((int)(((byte)(241)))), ((int)(((byte)(251))))); dataGridViewCellStyle5.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(49)))), ((int)(((byte)(93)))), ((int)(((byte)(165))))); dataGridViewCellStyle5.SelectionBackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(247)))), ((int)(((byte)(222))))); dataGridViewCellStyle5.SelectionForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(49)))), ((int)(((byte)(93)))), ((int)(((byte)(165))))); dgv_userGroup.RowsDefaultCellStyle = dataGridViewCellStyle5; dgv_userGroup.RowTemplate.Height = 23; dgv_userGroup.Size = new System.Drawing.Size(735, 472); dgv_userGroup.TabIndex = 1; dgv_userGroup.VerticalScrollBarMax = 1; dgv_userGroup.VerticalScrollBarValue = 0; dgv_userGroup.CellContentClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.dataGridViewKJ1281_CellContentClick); // // usergroupInfo // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(215)))), ((int)(((byte)(232)))), ((int)(((byte)(253))))); this.ClientSize = new System.Drawing.Size(950, 472); this.Controls.Add(this.panel1); this.Controls.Add(dgv_userGroup); this.Controls.Add(this.panel2); this.MaximumSize = new System.Drawing.Size(958, 506); this.MinimumSize = new System.Drawing.Size(958, 506); this.Name = "usergroupInfo"; this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; this.TabText = "用户组管理"; this.Text = "用户组管理"; this.Load += new System.EventHandler(this.usergroupInfo_Load); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); this.panel2.ResumeLayout(false); this.sxpPanel1.ResumeLayout(false); this.sxpPanel1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(dgv_userGroup)).EndInit(); this.ResumeLayout(false); }
//#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); }
/// <summary> /// 发码器配置查询 /// </summary> /// <param name="strCodeSender">发码器地址</param> /// <param name="strName">设备或员工的名称</param> /// <param name="intUserType">0表示人员,1表示设备,2表示人员和设备</param> /// <param name="dv">要绑定的DataGridView</param> /// <returns>true 成功,false 不成功</returns> public bool N_SearchCodeSetInfo(string strCodeSender, string strName, int intUserType, DataGridViewKJ128 dv, out string strCounts) { using (ds = new DataSet()) { dv.Columns.Clear(); ds = ccsdal.N_SearchCodeSetInfo(strCodeSender, strName, intUserType); dv.DataSource = ds.Tables[0].DefaultView; dv.Columns[0].FillWeight = 50; dv.Columns[1].FillWeight = 40; dv.Columns[2].FillWeight = 40; dv.Columns[3].FillWeight = 50; 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); }