private void LoadData() { DataTableReader dr = null; TCommonType ctype; cbbID.Items.Clear(); try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003003, new string[] { "1000" })); while (dr.Read()) { ctype = new TCommonType(dr["MacTimeHeaderSysID"].ToString(), dr["MacTimeHeaderTimeNo"].ToString(), dr["MacTimeHeaderName"].ToString()); cbbID.Items.Add(ctype); } bindingSource.DataSource = db.GetDataTable(Pub.GetSQL(DBCode.DB_003001, new string[] { "1007" })); } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } cbbID.SelectedIndex = 1; }
protected override void InitForm() { formCode = "SFReportSFMobile"; ReportFile = "SFReportSFMobile"; base.InitForm(); dtpStart.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1, 0, 0, 0); dtpEnd.Value = DateTime.Now.Date.AddHours(23).AddMinutes(59).AddSeconds(59); dtpStart.CustomFormat = SystemInfo.DateTimeFormat; dtpEnd.CustomFormat = SystemInfo.DateTimeFormat; DataTableReader dr = null; TCommonType cType; try { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004011, new string[] { "3" })); while (dr.Read()) { cType = new TCommonType(dr["SFTypeSysID"].ToString(), dr["SFTypeID"].ToString(), dr["SFTypeName"].ToString(), true); clbSFType.Items.Add(cType); clbSFType.SetItemChecked(clbSFType.Items.Count - 1, false); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } try { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004004, new string[] { "0" })); while (dr.Read()) { clbMacSN.Items.Add(dr["MacSN"].ToString()); clbMacSN.SetItemChecked(clbMacSN.Items.Count - 1, false); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } clbMacSN.SetItemChecked(clbMacSN.Items.Count - 1, false); chkSFType_CheckedChanged(null, null); chkMacSN_CheckedChanged(null, null); btnAddress.Text = Pub.GetResText(formCode, "btnSelectAddress", ""); }
protected override void InitForm() { formCode = "SFOrderManual"; base.InitForm(); this.Text = Title + "[" + CurrentOprt + "]"; dtpStart.Value = DateTime.Now.Date.AddDays(-6); dtpEnd.Value = DateTime.Now.Date; DataTableReader dr = null; TCommonType cType; try { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004005, new string[] { "2" })); while (dr.Read()) { cType = new TCommonType(dr["MealTypeSysID"].ToString(), dr["MealTypeID"].ToString(), dr["MealTypeName"].ToString(), true); mealList.Add(cType); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } }
protected override void InitForm() { formCode = "KQEmpShift"; SetToolItemState("ItemTAG1", true); SetToolItemState("ItemTAG2", true); SetToolItemState("ItemTAG3", true); SetToolItemState("ItemLine3", true); InitEmp = true; CheckForward = false; base.InitForm(); SetToolImage("ItemTAG1", "FileSave"); SetToolImage("ItemTAG2", "EditUndo"); SetToolImage("ItemTAG3", "FileSaveAll"); DataTableReader dr = null; TCommonType ctype = new TCommonType("", "", "", true); ComboBox cbb; for (int i = 1; i <= 31; i++) { cbb = (ComboBox)pnlRight.Controls["cbbDay" + i.ToString("00")]; cbb.Items.Clear(); cbb.Items.Add(ctype); } try { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_002004, new string[] { "3" })); while (dr.Read()) { ctype = new TCommonType(dr["GUID"].ToString(), dr["ShiftNo"].ToString(), dr["ShiftName"].ToString(), true); for (int i = 1; i <= 31; i++) { cbb = (ComboBox)pnlRight.Controls["cbbDay" + i.ToString("00")]; cbb.Items.Add(ctype); } } for (int i = 1; i <= 31; i++) { cbb = (ComboBox)pnlRight.Controls["cbbDay" + i.ToString("00")]; cbb.SelectedIndex = 0; } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } dtpYM.Value = new DateTime(DateTime.Now.Date.Year, DateTime.Now.Date.Month, 1); dtpYM.CustomFormat = SystemInfo.YMFormat; }
protected override void InitForm() { SetToolItemState("ItemImport", false); SetToolItemState("ItemEdit", false); SetToolItemState("ItemTAG1", true); SetToolItemState("ItemTAG2", true); formCode = "MJMacPower"; ReportFile = "MJMacPower"; ReportStartIndex = 3; base.InitForm(); QuerySQL = Pub.GetSQL(DBCode.DB_003004, new string[] { "0", OprtInfo.DepartPower }); FindSQL = Pub.GetSQL(DBCode.DB_003004, new string[] { "101", OprtInfo.DepartPower }); FindOrderBy = Pub.GetSQL(DBCode.DB_003004, new string[] { "102" }); FindKeyWord = formCode; if (SystemInfo.HasFaCard) { SetReportColumnVisible("CardSectorNo", true); SetReportColumnVisible("CardPhysicsNo10", false); } else { SetReportColumnVisible("CardSectorNo", false); SetReportColumnVisible("CardPhysicsNo10", true); } DataTableReader dr = null; TCommonType cType; try { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003001, new string[] { "101" })); while (dr.Read()) { cType = new TCommonType(dr["MacDoorName"].ToString(), dr["MacDoorID"].ToString(), dr["MacDoorName"].ToString(), true); clbDoor.Items.Add(cType); clbDoor.SetItemChecked(clbDoor.Items.Count - 1, true); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } chkDoor_CheckedChanged(null, null); }
private void LoadData() { DataTableReader dr = null; try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } TCommonType ctype; dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003001, new string[] { "110" })); while (dr.Read()) { ctype = new TCommonType(dr["MacDoorCommandWaySysID"].ToString(), dr["MacDoorCommandWayID"].ToString(), dr["MacDoorCommandWayName"].ToString(), true); cbbMode1.Items.Add(ctype); cbbMode2.Items.Add(ctype); cbbMode3.Items.Add(ctype); cbbMode4.Items.Add(ctype); } dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003009, new string[] { "1", SysID })); if (dr.Read()) { MaskedTextBox txt; ComboBox cbb; for (int i = 1; i <= 4; i++) { txt = (MaskedTextBox)this.Controls["txtBeginTime" + i.ToString()]; txt.Text = dr["BeginTime" + i.ToString()].ToString(); txt = (MaskedTextBox)this.Controls["txtEndTime" + i.ToString()]; txt.Text = dr["EndTime" + i.ToString()].ToString(); cbb = (ComboBox)this.Controls["cbbMode" + i.ToString()]; SetModeIndex(cbb, dr["Mode" + i.ToString()].ToString()); } } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } }
private void LoadGroup() { gpGrid.Rows.Clear(); orGrid.Rows.Clear(); smGrid.Rows.Clear(); cbbTime1.Items.Clear(); cbbTime2.Items.Clear(); cbbTime3.Items.Clear(); TCommonType ctype; for (int i = 0; i < fdGrid.RowCount; i++) { if ((bool)fdGrid[0, i].EditedFormattedValue) { gpGrid.Rows.Add(); orGrid.Rows.Add(); smGrid.Rows.Add(); for (int j = 1; j < fdGrid.ColumnCount; j++) { gpGrid[j, gpGrid.RowCount - 1].Value = fdGrid[j, i].Value; orGrid[j, gpGrid.RowCount - 1].Value = fdGrid[j, i].Value; smGrid[j, smGrid.RowCount - 1].Value = fdGrid[j, i].Value; } ctype = new TCommonType(fdGrid[1, i].Value.ToString(), fdGrid[1, i].Value.ToString(), fdGrid[2, i].Value.ToString()); switch (fdGrid[3, i].Value.ToString().ToLower()) { case "datetime": cbbTime1.Items.Add(ctype); cbbTime2.Items.Add(ctype); break; case "string": cbbTime3.Items.Add(ctype); break; } } } if (cbbTime1.Items.Count > 0) { cbbTime1.SelectedIndex = 0; } if (cbbTime2.Items.Count > 0) { cbbTime2.SelectedIndex = 0; } if (cbbTime3.Items.Count > 0) { cbbTime3.SelectedIndex = 0; } }
private void LoadData() { DataTableReader dr = null; TCommonType ctype; cbbTimeNo.Items.Clear(); try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003003, new string[] { "7" })); while (dr.Read()) { ctype = new TCommonType(dr["MacTimeSysID"].ToString(), dr["MacTimeNo"].ToString(), dr["MacTimeName"].ToString()); cbbTimeNo.Items.Add(ctype); } dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003002, new string[] { "1", SysID })); if (dr.Read()) { txtID.Text = dr["MJHoliID"].ToString(); chkApply.Checked = Convert.ToBoolean(dr["MJHoliIsApply"].ToString()); DateTime d = new DateTime(); if (DateTime.TryParse(dr["MJHoliBeginDate"].ToString(), out d)) { txtBegin.Text = d.ToString(); } if (DateTime.TryParse(dr["MJHoliEndDate"].ToString(), out d)) { txtEnd.Text = d.ToString(); } SetTimeIndex(cbbTimeNo, dr["MacTimeNo"].ToString()); txtMemo.Text = dr["MJHoliMemo"].ToString(); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } }
private void LoadData() { DataTableReader dr = null; TCommonType ctype = new TCommonType("", "", "", true); cbbShiftNo.Items.Clear(); cbbShiftNo.Items.Add(ctype); try { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_002004, new string[] { "3" })); while (dr.Read()) { ctype = new TCommonType(dr["GUID"].ToString(), dr["ShiftNo"].ToString(), dr["ShiftName"].ToString(), true); cbbShiftNo.Items.Add(ctype); } dr.Close(); dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_002007, new string[] { "8", SysID })); if (dr.Read()) { txtEmpNo.Text = dr["EmpNo"].ToString(); txtEmpName.Text = dr["EmpName"].ToString(); txtDepartID.Text = dr["DepartID"].ToString(); txtDepartName.Text = dr["DepartName"].ToString(); DateTime dt = new DateTime(); DateTime.TryParse(dr["EmpShiftDate"].ToString(), out dt); txtDate.Text = dt.ToShortDateString(); for (int i = 0; i < cbbShiftNo.Items.Count; i++) { if (((TCommonType)cbbShiftNo.Items[i]).id == dr["ShiftNo"].ToString()) { cbbShiftNo.SelectedIndex = i; break; } } } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } }
protected override void InitForm() { formCode = "KQDepShiftBatch"; base.InitForm(); this.Text = Title + "[" + CurrentOprt + "]"; dtpStart.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); dtpEnd.Value = DateTime.Now.Date; DataTableReader dr = null; TCommonType ctype; cbbRule.Items.Clear(); try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_002004, new string[] { "0", Pub.GetResText(formCode, "ShiftRuleFlag0", ""), Pub.GetResText(formCode, "ShiftRuleFlag1", ""), Pub.GetResText(formCode, "ShiftRuleFlag2", "") })); while (dr.Read()) { ctype = new TCommonType(dr["ShiftRuleSysID"].ToString(), "", dr["ShiftRuleName"].ToString(), true); cbbRule.Items.Add(ctype); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } if (cbbRule.Items.Count > 0) { cbbRule.SelectedIndex = 0; } InitDepartTreeView(tvDepart); }
protected override void InitForm() { formCode = "SYAutoAdd"; base.InitForm(); this.Text = Title + "[" + CurrentOprt + "]"; TCommonType ctype; cbbType.Items.Clear(); for (int i = 1; i <= 4; i++) { ctype = new TCommonType(i.ToString(), i.ToString(), Pub.GetResText(formCode, "AutoType" + i.ToString(), ""), true); cbbType.Items.Add(ctype); } cbbType.SelectedIndex = 0; if (SysID != "") { LoadData(); } }
protected override void InitForm() { formCode = "SFReportRefundmentDetail"; ReportFile = "SFReportRefundmentDetail"; base.InitForm(); dtpStart.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1, 0, 0, 0); dtpEnd.Value = DateTime.Now.Date.AddHours(23).AddMinutes(59).AddSeconds(59); dtpStart.CustomFormat = SystemInfo.DateTimeFormat; dtpEnd.CustomFormat = SystemInfo.DateTimeFormat; DataTableReader dr = null; TCommonType cType; try { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_000002, new string[] { "1" })); while (dr.Read()) { cType = new TCommonType(dr["OprtNo"].ToString(), dr["OprtNo"].ToString(), dr["OprtName"].ToString()); clbOprt.Items.Add(cType); clbOprt.SetItemChecked(clbOprt.Items.Count - 1, false); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } GetCardTypeList(); for (int i = 0; i < cardTypeList.Count; i++) { clbCardType.Items.Add(cardTypeList[i]); clbCardType.SetItemChecked(clbCardType.Items.Count - 1, false); } chkOprt_CheckedChanged(null, null); chkCardType_CheckedChanged(null, null); }
protected override void InitForm() { formCode = "SKReportTotal"; ReportFile = "SKReportTotal"; base.InitForm(); dtpStart.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1, 0, 0, 0); dtpEnd.Value = DateTime.Now.Date.AddHours(23).AddMinutes(59).AddSeconds(59); dtpStart.CustomFormat = SystemInfo.DateTimeFormat; dtpEnd.CustomFormat = SystemInfo.DateTimeFormat; DataTableReader dr = null; TCommonType cType; try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_005001, new string[] { "1" })); while (dr.Read()) { cType = new TCommonType(dr["SKTypeSysID"].ToString(), dr["SKTypeID"].ToString(), dr["SKTypeName"].ToString()); clbSKType.Items.Add(cType); clbSKType.SetItemChecked(clbSKType.Items.Count - 1, false); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } chkSKType_CheckedChanged(null, null); }
protected override void InitForm() { formCode = "SyncTime"; base.InitForm(); txtMacSN.Text = SystemInfo.MaxSN603Find.ToString(); lblMacSN.ForeColor = Color.Red; lblMacType.ForeColor = Color.Red; lblCommPort.ForeColor = Color.Red; lblCommBaudRate.ForeColor = Color.Red; lblLANIP.ForeColor = Color.Red; lblLANPort.ForeColor = Color.Red; lblWANIP.ForeColor = Color.Red; lblWANPort.ForeColor = Color.Red; lblWANAddress.ForeColor = Color.Red; SetTextboxNumber(txtMacSN); SetTextboxNumber(txtLANPort); SetTextboxNumber(txtWANPort); Pub.InitCommList(cbbCommPort); cbbMacType.Items.Clear(); TCommonType cType; string s = ""; for (int i = 1; i <= 6; i++) { s = Pub.GetResText(formCode, i.ToString("Dev00"), ""); if (s == "") { continue; } cType = new TCommonType(i.ToString(), i.ToString(), s); cbbMacType.Items.Add(cType); } cbbMacType.SelectedIndex = 0; RadioButton_Click(null, null); if (SystemInfo.IsBigMacAdd) { txtMacSN.MaxLength = 5; txtMacSN.Text = SystemInfo.MaxSN603FindEx.ToString(); } }
private void LoadAccount() { DataTableReader dr = null; string AccName; string DBName; TCommonType obj; cbbAccount.Items.Clear(); try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_000001, new string[] { "119" })); while (dr.Read()) { AccName = dr["AccName"].ToString(); DBName = dr["DBName"].ToString(); obj = new TCommonType(DBName, DBName, AccName); cbbAccount.Items.Add(obj); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } if (cbbAccount.Items.Count > 0) { cbbAccount.SelectedIndex = 0; } }
protected override void InitForm() { formCode = "RSCardOpterDetail"; ReportFile = "RSCardOpterDetail"; base.InitForm(); dtpStart.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); dtpEnd.Value = DateTime.Now.Date; DataTableReader dr = null; TCommonType cType; try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_001004, new string[] { "0" })); while (dr.Read()) { cType = new TCommonType(dr["OpterTypeSysID"].ToString(), dr["OpterTypeID"].ToString(), dr["OpterTypeName"].ToString(), true); clbOpterType.Items.Add(cType); clbOpterType.SetItemChecked(clbOpterType.Items.Count - 1, false); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } chkOpterType_CheckedChanged(null, null); }
private void LoadDataTable() { cbbTable.Items.Clear(); DataTableReader dr = null; TCommonType ctype; string na; try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_000002, new string[] { "401", ReportTable.Substring(0, 3), SystemInfo.DatabaseName })); while (dr.Read()) { na = dr["name"].ToString(); ctype = new TCommonType(na, na, Pub.GetResText(formCode, na, "")); cbbTable.Items.Add(ctype); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } if (cbbTable.Items.Count > 0) { cbbTable.SelectedIndex = 0; } }
public void ShowRealData(QHKS.TMJRecordInfo recInfo, string MacSN) { string EmpSysID = ""; string EmpNo = ""; string EmpName = ""; string DepartID = ""; string DepartName = ""; string CardSectorNo = ""; string MacDoorName = ""; string MacPassState = Pub.GetResText("MJMacReal", "AllowPass", ""); string MacReadImpact = ""; string Memo = ""; string readerid = Pub.GetMJReaderID(MacSN, recInfo.ReaderID); string wavFile = ""; DataTableReader dr = null; try { if (recInfo.IsCard == 1) { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003006, new string[] { "1", recInfo.CardNo })); if (dr.Read()) { EmpSysID = dr["EmpSysID"].ToString(); EmpNo = dr["EmpNo"].ToString(); EmpName = dr["EmpName"].ToString(); DepartID = dr["DepartID"].ToString(); DepartName = dr["DepartName"].ToString(); if (SystemInfo.HasFaCard) { CardSectorNo = dr["CardSectorNo"].ToString(); } else { CardSectorNo = dr["CardPhysicsNo10"].ToString(); } } dr.Close(); } dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003006, new string[] { "3", MacSN, readerid })); if (dr.Read()) { MacDoorName = dr["MacDoorName"].ToString(); MacReadImpact = dr["MacReadImpact"].ToString(); } } catch { } finally { if (dr != null) { dr.Close(); } dr = null; } string msg = ""; if ((EmpSysID == "") || (recInfo.IsPass == 0)) { int IndexNum = recInfo.AlarmType; if (recInfo.IsCard == 1) { IndexNum = 144; } Memo = Pub.GetResText(formCode, "MJRecordMemo" + IndexNum.ToString(), ""); if (recInfo.IsCard == 1) { Memo += "[" + recInfo.CardNo + "]"; wavFile = "PassDis.wav"; } else if (IndexNum == 140) { wavFile = "NormalIn.wav"; } else if (IndexNum == 141) { wavFile = "AlarmDur.wav"; } else if (IndexNum == 142) { wavFile = "DoorTime.wav"; } else if ((IndexNum == 143) || (IndexNum == 145) || (IndexNum == 146)) { wavFile = "Alarm.wav"; } else if (IndexNum == 148) { wavFile = "AlarmDis.wav"; } if (wavFile != "") { wavFile = wavPath + wavFile; Pub.PlaySound(wavFile); } msg = recInfo.CardTime.ToString() + " " + MacSN + " " + MacDoorName + " " + Memo; } else { if (MacReadImpact.ToLower() == "in") { wavFile = "NormalIn.wav"; } else { wavFile = "NormalIn.wav"; } wavFile = wavPath + wavFile; Pub.PlaySound(wavFile); msg = CardSectorNo + " " + recInfo.CardTime.ToString() + " " + EmpNo + " " + EmpName + " " + DepartID + " " + DepartName + " " + MacSN + " " + MacDoorName + " " + MacPassState + " " + MacReadImpact; } TCommonType ctype = new TCommonType(EmpSysID, "", msg, true); lbMsg.Items.Add(ctype); while (lbMsg.Items.Count > maxCount) { lbMsg.Items.RemoveAt(0); } lbMsg.SelectedIndex = lbMsg.Items.Count - 1; }
protected override void InitForm() { formCode = "SFReportSFDetail"; ReportFile = "SFReportSFDetail"; base.InitForm(); //clbSFType.Size = new System.Drawing.Size(200, 491); SetToolItemState("ItemTAG1", true); dtpStart.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1, 0, 0, 0); dtpEnd.Value = DateTime.Now.Date.AddHours(23).AddMinutes(59).AddSeconds(59); dtpStart.CustomFormat = SystemInfo.DateTimeFormat; dtpEnd.CustomFormat = SystemInfo.DateTimeFormat; Report.Initialize += new _IGridppReportEvents_InitializeEventHandler(Report_Initialize); Report.SectionFormat += new _IGridppReportEvents_SectionFormatEventHandler(Report_SectionFormat); GetCardTypeList(); for (int i = 0; i < cardTypeList.Count; i++) { clbCardType.Items.Add(cardTypeList[i]); clbCardType.SetItemChecked(clbCardType.Items.Count - 1, false); } DataTableReader dr = null; TCommonType cType; try { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004011, new string[] { "0" })); while (dr.Read()) { cType = new TCommonType(dr["SFTypeSysID"].ToString(), dr["SFTypeID"].ToString(), dr["SFTypeName"].ToString(), true); clbSFType.Items.Add(cType); clbSFType.SetItemChecked(clbSFType.Items.Count - 1, false); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } try { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004005, new string[] { "2" })); while (dr.Read()) { cType = new TCommonType(dr["MealTypeSysID"].ToString(), dr["MealTypeID"].ToString(), dr["MealTypeName"].ToString(), true); clbMealType.Items.Add(cType); clbMealType.SetItemChecked(clbMealType.Items.Count - 1, false); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } try { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004004, new string[] { "0" })); while (dr.Read()) { clbMacSN.Items.Add(dr["MacSN"].ToString()); clbMacSN.SetItemChecked(clbMacSN.Items.Count - 1, false); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } clbMacSN.Items.Add("255"); clbMacSN.SetItemChecked(clbMacSN.Items.Count - 1, false); chkCardType_CheckedChanged(null, null); chkSFType_CheckedChanged(null, null); chkSFMealType_CheckedChanged(null, null); chkMacSN_CheckedChanged(null, null); btnAddress.Text = btnSelectEmp.Text; //SetToolItemState("ItemTAG7", true); }
protected override void InitForm() { formCode = "SFAllowance"; switch (Application.CurrentCulture.LCID) { case 0x804: Report.Language = 0x804; break; case 0x404: case 0x0c04: case 0x1004: case 0x1404: Report.Language = 0x404; break; default: Report.Language = 0x0409; break; } Report1.Language = Report.Language; ReportFile = SystemInfo.ReportPath + "SFAllowance.grf"; ReportFile1 = SystemInfo.ReportPath + "SFAllowanceHistory.grf"; if ((ReportFile != "") && File.Exists(ReportFile)) { try { Report.Register(SystemInfo.ReportRegister); Report.LoadFromFile(ReportFile); Report.DetailGrid.Recordset.ConnectionString = SystemInfo.ConnStrReport; Report.DetailGrid.Recordset.QuerySQL = ""; Report.ShowProgressUI = false; ShowReportHeader(false); Report.FetchRecord -= new _IGridppReportEvents_FetchRecordEventHandler(ProductListFetchRecord); Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ProductListFetchRecord); dispView.Report = Report; //指示查询显示控件分批获取数据 dispView.BatchGetRecord = true; dispView.BatchWantRecords = 0; //指示查询显示控件显示出工具栏,并按分页方式显示数据 dispView.ShowToolbar = true; dispView.RowsPerPage = 0; dispView.Start(); } catch (Exception E) { Pub.ShowErrorMsg(E); } } if ((ReportFile1 != "") && File.Exists(ReportFile1)) { try { Report1.Register(SystemInfo.ReportRegister); Report1.LoadFromFile(ReportFile1); Report1.DetailGrid.Recordset.ConnectionString = SystemInfo.ConnStrReport; Report1.DetailGrid.Recordset.QuerySQL = ""; Report1.ShowProgressUI = false; ShowReportHeader(false); Report1.FetchRecord -= new _IGridppReportEvents_FetchRecordEventHandler(ProductListFetchRecord1); Report1.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ProductListFetchRecord1); dispView1.Report = Report1; //指示查询显示控件分批获取数据 dispView1.BatchGetRecord = true; dispView1.BatchWantRecords = 0; //指示查询显示控件显示出工具栏,并按分页方式显示数据 dispView1.ShowToolbar = true; dispView1.RowsPerPage = 0; dispView1.Start(); } catch (Exception E) { Pub.ShowErrorMsg(E); } } AddExtDropDownItem("ItemSetupDisplay", ItemSetupDisplay_Click); SetToolItemState("ItemTAG1", true); SetToolItemState("ItemTAGExt", true); SetToolItemState("ItemLine3", true); SetToolItemState("ItemSearch", true); AddExtDropDownItem("BatchAllowance", BatchAllowance_Click); IgnoreSelect = true; base.InitForm(); QuerySQL = Pub.GetSQL(DBCode.DB_004006, new string[] { "0", OprtInfo.DepartPower }); QuerySQL1 = Pub.GetSQL(DBCode.DB_004006, new string[] { "1", OprtInfo.DepartPower }); FindSQL = Pub.GetSQL(DBCode.DB_004006, new string[] { "2", OprtInfo.DepartPower }); FindSQL1 = Pub.GetSQL(DBCode.DB_004006, new string[] { "3", OprtInfo.DepartPower }); FindOrderBy = Pub.GetSQL(DBCode.DB_004006, new string[] { "4" }); if (SystemInfo.AllowanceCardType) { ImportFieldList = new string[] { "EmpNo", "CardType", "AllowanceFlag", "AllowanceWayName", "AllowanceAmount" } } ; else { ImportFieldList = new string[] { "EmpNo", "AllowanceFlag", "AllowanceWayName", "AllowanceAmount" } }; ImportShowCount = true; clbAllowanceStatus.Items.Clear(); clbAllowanceStatus1.Items.Clear(); TCommonType cType; DataTableReader dr = null; try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004006, new string[] { "21" })); while (dr.Read()) { cType = new TCommonType(dr["AllowanceStatusID"].ToString(), dr["AllowanceStatusID"].ToString(), dr["AllowanceStatusName"].ToString(), true); clbAllowanceStatus.Items.Add(cType); clbAllowanceStatus1.Items.Add(cType); clbAllowanceStatus.SetItemChecked(clbAllowanceStatus.Items.Count - 1, false); clbAllowanceStatus1.SetItemChecked(clbAllowanceStatus1.Items.Count - 1, false); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } chkAllowanceStatus_CheckedChanged(null, null); chkAllowanceStatus1_CheckedChanged(null, null); dtpStart.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1, 0, 0, 0); dtpEnd.Value = DateTime.Now.Date; dtpStart1.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1, 0, 0, 0); dtpEnd1.Value = DateTime.Now.Date; }
private void LoadData() { cbbMacType.Items.Clear(); TCommonType cType; DataTableReader dr = null; byte MacTypeID = 0; try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004004, new string[] { "103" })); while (dr.Read()) { MacTypeID = Convert.ToByte(dr["MacTypeID"].ToString()); cType = new TCommonType(dr["MacTypeSysID"].ToString(), dr["MacTypeID"].ToString(), dr["MacTypeName"].ToString()); cbbMacType.Items.Add(cType); } if (SysID == "") { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004004, new string[] { "101" })); if (dr.Read()) { int no = 0; int.TryParse(dr[0].ToString(), out no); if (SystemInfo.IsBigMacAdd) { if (no > SystemInfo.MaxSN603Ex) { no = SystemInfo.MaxSN603Ex; } } else { if (no > SystemInfo.MaxSN603) { no = SystemInfo.MaxSN603; } } txtMacSN.Text = no.ToString(); } cbbMacType.SelectedIndex = 0; } else { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004004, new string[] { "4", SysID })); if (dr.Read()) { txtMacSN.Text = dr["MacSN"].ToString(); cbbMacType.Text = dr["MacType"].ToString(); switch (dr["MacConnType"].ToString()) { case MacConnTypeString.USB: rbUSB.Checked = true; break; case MacConnTypeString.Comm: rbComm.Checked = true; cbbCommPort.Text = dr["MacPort"].ToString(); cbbCommBaudRate.Text = dr["MacConnPWD"].ToString(); break; case MacConnTypeString.LAN: rbLAN.Checked = true; txtLANIP.Text = dr["MacIpAddress"].ToString(); txtLANPort.Text = dr["MacPort"].ToString(); break; case MacConnTypeString.GPRS: rbWAN.Checked = true; txtWANIP.Text = dr["MacIpAddress"].ToString(); txtWANPort.Text = dr["MacPort"].ToString(); break; } txtWANAddress.Text = dr["MacPhysicsAddress"].ToString(); txtMacAddress.Text = dr["MacAddress"].ToString(); txtMacAddress.Tag = dr["MacAddressSysID"].ToString(); txtDesc.Text = dr["MacDesc"].ToString(); } } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } }
private void LoadData() { cbbRest.Items.Clear(); cbbRest.Items.Add(Pub.GetResText(formCode, "NormalRest", "")); cbbRest.Items.Add(Pub.GetResText(formCode, "TurnsoffRest", "")); cbbShiftNo.Items.Clear(); cbbWeek.Items.Clear(); cbbHoli.Items.Clear(); cbbUnit.Items.Clear(); TCommonType ctype = new TCommonType("M", "M", Pub.GetResText(formCode, "RestMonth", "")); cbbUnit.Items.Add(ctype); ctype = new TCommonType("W", "W", Pub.GetResText(formCode, "RestWeek", "")); cbbUnit.Items.Add(ctype); ctype = new TCommonType("", "", "", true); cbbShiftNo.Items.Add(ctype); cbbWeek.Items.Add(ctype); cbbHoli.Items.Add(ctype); DataTableReader dr = null; try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_002004, new string[] { "3" })); while (dr.Read()) { ctype = new TCommonType(dr["GUID"].ToString(), dr["ShiftNo"].ToString(), dr["ShiftName"].ToString(), true); cbbShiftNo.Items.Add(ctype); } dr.Close(); dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_002017, new string[] { "0" })); while (dr.Read()) { ctype = new TCommonType(dr["WeekEndSysID"].ToString(), dr["WeekEndNo"].ToString(), dr["WeekEndName"].ToString(), true); cbbWeek.Items.Add(ctype); } dr.Close(); dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_002016, new string[] { "0" })); while (dr.Read()) { ctype = new TCommonType(dr["HolidaySysID"].ToString(), dr["HolidayNo"].ToString(), dr["HolidayName"].ToString(), true); cbbHoli.Items.Add(ctype); } cbbShiftNo.SelectedIndex = 0; cbbRest.SelectedIndex = 0; cbbWeek.SelectedIndex = 0; cbbHoli.SelectedIndex = 0; cbbUnit.SelectedIndex = 0; if (SysID != "") { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_002018, new string[] { "4", SysID })); if (dr.Read()) { txtEmpNo.Text = dr["EmpNo"].ToString(); txtEmpNo.Tag = dr["EmpSysID"].ToString(); txtEmpName.Text = dr["EmpName"].ToString(); txtDepart.Text = "[" + dr["DepartID"].ToString() + "]" + dr["DepartName"].ToString(); for (int i = 0; i < cbbShiftNo.Items.Count; i++) { if (((TCommonType)cbbShiftNo.Items[i]).id == dr["ShiftNo"].ToString()) { cbbShiftNo.SelectedIndex = i; break; } } chkOtIsHaveBar.Checked = dr["EmpOtIsHaveBar"].ToString().ToUpper() == "Y"; chkIsPressed.Checked = dr["EmpIsPressed"].ToString().ToUpper() == "Y"; int index = 0; int.TryParse(dr["EmpRest"].ToString(), out index); cbbRest.SelectedIndex = index - 1; if (cbbRest.SelectedIndex == 0) { for (int i = 0; i < cbbWeek.Items.Count; i++) { if (((TCommonType)cbbWeek.Items[i]).sysID == dr["WeekEndSysID"].ToString()) { cbbWeek.SelectedIndex = i; break; } } for (int i = 0; i < cbbHoli.Items.Count; i++) { if (((TCommonType)cbbHoli.Items[i]).sysID == dr["HolidaySysID"].ToString()) { cbbHoli.SelectedIndex = i; break; } } } else { for (int i = 0; i < cbbUnit.Items.Count; i++) { if (((TCommonType)cbbUnit.Items[i]).id == dr["EmpTimeWorkUnit"].ToString()) { cbbUnit.SelectedIndex = i; break; } } txtDays.Text = dr["EmpRestDays"].ToString(); } } } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } }
private void LoadData() { DataTableReader dr = null; TCommonType ctype = new TCommonType("", "", "", true); TextBox txt; MaskedTextBox txtA; MaskedTextBox txtB; ComboBox cbb; CheckBox chk; int v = 0; for (int i = 1; i <= 5; i++) { cbb = (ComboBox)tabPage1.Controls["cbbOtType" + i.ToString()]; cbb.Items.Clear(); cbb.Items.Add(ctype); } try { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_002002, new string[] { "0" })); while (dr.Read()) { ctype = new TCommonType(dr["OtTypeSysID"].ToString(), dr["OtTypeNo"].ToString(), dr["OtTypeName"].ToString(), true); for (int i = 1; i <= 5; i++) { cbb = (ComboBox)tabPage1.Controls["cbbOtType" + i.ToString()]; cbb.Items.Add(ctype); } } if (SysID == "") { for (int i = 1; i <= 5; i++) { cbb = (ComboBox)tabPage1.Controls["cbbOtType" + i.ToString()]; cbb.SelectedIndex = 0; cbb = (ComboBox)tabPage1.Controls["cbbInNextDay" + i.ToString()]; cbb.SelectedIndex = 0; cbb = (ComboBox)tabPage1.Controls["cbbOutNextDay" + i.ToString()]; cbb.SelectedIndex = 0; } } else { txtNo.Enabled = false; dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_002003, new string[] { "4", SysID })); if (dr.Read()) { txtNo.Text = dr["ShiftNo"].ToString(); txtName.Text = dr["ShiftName"].ToString(); txtShiftNormalMin.Text = dr["ShiftNormalHrs"].ToString(); for (int i = 1; i <= 5; i++) { txtA = (MaskedTextBox)tabPage1.Controls["txtInTime" + i.ToString()]; txtB = (MaskedTextBox)tabPage1.Controls["txtOutTime" + i.ToString()]; txtA.Text = Pub.ValidatTime(dr["InTime" + i.ToString() + "Str"].ToString()); txtB.Text = Pub.ValidatTime(dr["OutTime" + i.ToString() + "Str"].ToString()); cbb = (ComboBox)tabPage1.Controls["cbbInNextDay" + i.ToString()]; cbb.SelectedIndex = dr["InNextDay" + i.ToString()].ToString().ToUpper() == "Y" ? 1 : 0; cbb = (ComboBox)tabPage1.Controls["cbbOutNextDay" + i.ToString()]; cbb.SelectedIndex = dr["OutNextDay" + i.ToString()].ToString().ToUpper() == "Y" ? 1 : 0; chk = (CheckBox)tabPage1.Controls["chkInIsPressed" + i.ToString()]; chk.Checked = dr["InIsPressed" + i.ToString()].ToString().ToUpper() == "Y"; chk = (CheckBox)tabPage1.Controls["chkOutIsPressed" + i.ToString()]; chk.Checked = dr["OutIsPressed" + i.ToString()].ToString().ToUpper() == "Y"; txt = (TextBox)tabPage1.Controls["txtInBefore" + i.ToString()]; int.TryParse(dr["InBefore" + i.ToString()].ToString(), out v); v = v / 60; txt.Text = v.ToString(); txt = (TextBox)tabPage1.Controls["txtOutAfter" + i.ToString()]; int.TryParse(dr["OutAfter" + i.ToString()].ToString(), out v); v = v / 60; txt.Text = v.ToString(); txt = (TextBox)tabPage1.Controls["txtInLater" + i.ToString()]; int.TryParse(dr["InLater" + i.ToString()].ToString(), out v); v = v / 60; txt.Text = v.ToString(); txt = (TextBox)tabPage1.Controls["txtInMaxLater" + i.ToString()]; int.TryParse(dr["InMaxLater" + i.ToString()].ToString(), out v); v = v / 60; txt.Text = v.ToString(); txt = (TextBox)tabPage1.Controls["txtOutLeaveEarly" + i.ToString()]; int.TryParse(dr["OutLeaveEarly" + i.ToString()].ToString(), out v); v = v / 60; txt.Text = v.ToString(); txt = (TextBox)tabPage1.Controls["txtOutMaxLeaveEarly" + i.ToString()]; int.TryParse(dr["OutMaxLeaveEarly" + i.ToString()].ToString(), out v); v = v / 60; txt.Text = v.ToString(); cbb = (ComboBox)tabPage1.Controls["cbbOtType" + i.ToString()]; cbb.SelectedIndex = 0; for (int j = 0; j < cbb.Items.Count; j++) { if (((TCommonType)cbb.Items[j]).id == dr["OtTypeSysID" + i.ToString()].ToString()) { cbb.SelectedIndex = j; break; } } } chkNormalRound.Checked = dr["AddISNormalGetInt"].ToString().ToUpper() == "Y"; chkOtRound.Checked = dr["AddISOtGetInt"].ToString().ToUpper() == "Y"; rbRoundHour.Checked = dr["AddGetInt"].ToString() == "2"; rbRoundHalf.Checked = !rbRoundHour.Checked; chkInBeforeOt.Checked = dr["AddIsAutoInBeforeOt"].ToString().ToUpper() == "Y"; txtInBeforeOtMin.Text = dr["AddInBeforeOtMin"].ToString(); chkOutAfterOt.Checked = dr["AddIsAutoOutAfterOt"].ToString().ToUpper() == "Y"; txtOutAfterOtMin.Text = dr["AddOutAfterOtMin"].ToString(); textBox1.Text = dr["AddRestMin1"].ToString(); textBox2.Text = dr["AddRestMin2"].ToString(); textBox3.Text = dr["AddRestMin3"].ToString(); textBox4.Text = dr["AddRestMin4"].ToString(); for (int i = 1; i <= 5; i++) { chk = (CheckBox)tabPage2.Controls["chkISFu" + i.ToString()]; chk.Checked = dr["AddISFu" + i.ToString()].ToString().ToUpper() == "Y"; } checkBox1.Checked = Pub.ValueToBool(dr["AddIsZL1"].ToString()); checkBox2.Checked = Pub.ValueToBool(dr["AddIsZL2"].ToString()); checkBox3.Checked = Pub.ValueToBool(dr["AddIsZL3"].ToString()); checkBox4.Checked = Pub.ValueToBool(dr["AddIsZL4"].ToString()); } } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } }
private void LoadData() { DataTableReader dr = null; TCommonType ctype; cbbSun.Items.Clear(); cbbMon.Items.Clear(); cbbTue.Items.Clear(); cbbWed.Items.Clear(); cbbThu.Items.Clear(); cbbFri.Items.Clear(); cbbSat.Items.Clear(); try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003003, new string[] { "7" })); while (dr.Read()) { ctype = new TCommonType(dr["MacTimeSysID"].ToString(), dr["MacTimeNo"].ToString(), dr["MacTimeName"].ToString()); cbbSun.Items.Add(ctype); cbbMon.Items.Add(ctype); cbbTue.Items.Add(ctype); cbbWed.Items.Add(ctype); cbbThu.Items.Add(ctype); cbbFri.Items.Add(ctype); cbbSat.Items.Add(ctype); } if (SysID == "") { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003003, new string[] { "1010" })); if (dr.Read()) { int no = 0; int.TryParse(dr[0].ToString(), out no); if (no > SystemInfo.MaxTimeNoNew) { no = SystemInfo.MaxTimeNoNew; } txtID.Text = no.ToString(); } cbbSun.SelectedIndex = 0; cbbMon.SelectedIndex = 0; cbbTue.SelectedIndex = 0; cbbWed.SelectedIndex = 0; cbbThu.SelectedIndex = 0; cbbFri.SelectedIndex = 0; cbbSat.SelectedIndex = 0; } else { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003003, new string[] { "1006", SysID })); if (dr.Read()) { txtID.Text = dr["MacTimeHeaderTimeNo"].ToString(); txtName.Text = dr["MacTimeHeaderName"].ToString(); SetTimeIndex(cbbSun, dr["MacTimeHeaderSunday"].ToString()); SetTimeIndex(cbbMon, dr["MacTimeHeaderMonday"].ToString()); SetTimeIndex(cbbTue, dr["MacTimeHeaderTuesday"].ToString()); SetTimeIndex(cbbWed, dr["MacTimeHeaderWednesday"].ToString()); SetTimeIndex(cbbThu, dr["MacTimeHeaderThursday"].ToString()); SetTimeIndex(cbbFri, dr["MacTimeHeaderFriday"].ToString()); SetTimeIndex(cbbSat, dr["MacTimeHeaderSaturday"].ToString()); int v = 0; int.TryParse(dr["MacTimeHeaderHoliday"].ToString(), out v); chkHoliday.Checked = v > 0; } } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } }
private void LoadData() { DataTableReader dr = null; clb11.Items.Clear(); clb12.Items.Clear(); clb21.Items.Clear(); clb22.Items.Clear(); clb31.Items.Clear(); clb32.Items.Clear(); clb41.Items.Clear(); clb42.Items.Clear(); string s = ""; for (int i = 1; i <= 7; i++) { s = Pub.GetResText(formCode, "Item" + i.ToString(), ""); clb12.Items.Add(s); clb22.Items.Add(s); clb32.Items.Add(s); clb42.Items.Add(s); } string MacExtensionBoard = ""; try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } TCommonType ctype; dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003001, new string[] { "7", SysID })); while (dr.Read()) { ctype = new TCommonType(dr["MacDoorSysID"].ToString(), dr["MacDoorID"].ToString(), dr["MacDoorName"].ToString(), true); clb11.Items.Add(ctype); clb21.Items.Add(ctype); clb31.Items.Add(ctype); clb41.Items.Add(ctype); } dr.Close(); dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003001, new string[] { "4", SysID })); if (dr.Read()) { MacExtensionBoard = dr["MacExtensionBoard"].ToString(); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } TMacExtensionBoardNew extBoard = new TMacExtensionBoardNew(MacExtensionBoard); CheckedListBox clb; CheckedListBox clb1; Button btn; TextBox txt1; TextBox txt2; for (int i = 0; i < 4; i++) { if (i == 0) { clb = clb11; clb1 = clb12; btn = btnAdv1; txt1 = txtTime1; txt2 = txtLoop1; } else if (i == 1) { clb = clb21; clb1 = clb22; btn = btnAdv2; txt1 = txtTime2; txt2 = txtLoop2; } else if (i == 2) { clb = clb31; clb1 = clb32; btn = btnAdv3; txt1 = txtTime3; txt2 = txtLoop3; } else { clb = clb41; clb1 = clb42; btn = btnAdv4; txt1 = txtTime4; txt2 = txtLoop4; } for (int j = 0; j < clb.Items.Count; j++) { if (((TCommonType)clb.Items[j]).id == extBoard.DoorID[i].ToString()) { clb.SetItemChecked(j, true); break; } } for (int j = 0; j < clb1.Items.Count; j++) { clb1.SetItemChecked(j, extBoard.Events[i].Substring(j, 1) == "1"); } txt1.Text = extBoard.TimeOut[i].ToString(); txt2.Text = extBoard.TimeLoop[i].ToString(); source[i] = extBoard.Souce[i]; } }
protected override void InitForm() { formCode = "SFReportProductDetail"; ReportFile = SystemInfo.IsDecimalProduct ? "SFReportProductsDecimalDetail" : "SFReportProductDetail"; SetToolItemState("ItemTAG1", true); base.InitForm(); dtpStart.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1, 0, 0, 0); dtpEnd.Value = DateTime.Now.Date.AddHours(23).AddMinutes(59).AddSeconds(59); dtpStart.CustomFormat = SystemInfo.DateTimeFormat; dtpEnd.CustomFormat = SystemInfo.DateTimeFormat; GetCardTypeList(); for (int i = 0; i < cardTypeList.Count; i++) { clbCardType.Items.Add(cardTypeList[i]); clbCardType.SetItemChecked(clbCardType.Items.Count - 1, false); } DataTableReader dr = null; TCommonType cType; try { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004005, new string[] { "2" })); while (dr.Read()) { cType = new TCommonType(dr["MealTypeSysID"].ToString(), dr["MealTypeID"].ToString(), dr["MealTypeName"].ToString(), true); clbMealType.Items.Add(cType); clbMealType.SetItemChecked(clbMealType.Items.Count - 1, false); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } try { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004004, new string[] { "0" })); while (dr.Read()) { clbMacSN.Items.Add(dr["MacSN"].ToString()); clbMacSN.SetItemChecked(clbMacSN.Items.Count - 1, false); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } clbMacSN.Items.Add("255"); clbMacSN.SetItemChecked(clbMacSN.Items.Count - 1, false); chkCardType_CheckedChanged(null, null); chkSFMealType_CheckedChanged(null, null); chkMacSN_CheckedChanged(null, null); btnAddress.Text = btnSelectEmp.Text; ItemTAG1.Enabled = false; }
private void LoadData() { DataTableReader dr = null; TCommonType ctype; cbbMode1.Items.Clear(); cbbMode2.Items.Clear(); cbbMode2.Items.Clear(); cbbMode3.Items.Clear(); cbbMode4.Items.Clear(); cbbMode5.Items.Clear(); try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003003, new string[] { "103" })); while (dr.Read()) { ctype = new TCommonType(dr["TimeInTypeSysID"].ToString(), dr["TimeInTypeID"].ToString(), dr["TimeInTypeName"].ToString(), true); cbbMode1.Items.Add(ctype); cbbMode2.Items.Add(ctype); cbbMode3.Items.Add(ctype); cbbMode4.Items.Add(ctype); cbbMode5.Items.Add(ctype); cbbMode6.Items.Add(ctype); } if (SysID == "") { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003003, new string[] { "101" })); if (dr.Read()) { int no = 0; int.TryParse(dr[0].ToString(), out no); if (no > SystemInfo.MaxTimeNoNew) { no = SystemInfo.MaxTimeNoNew; } txtID.Text = no.ToString(); } cbbMode1.SelectedIndex = 1; cbbMode2.SelectedIndex = 1; cbbMode3.SelectedIndex = 1; cbbMode4.SelectedIndex = 1; cbbMode5.SelectedIndex = 1; cbbMode6.SelectedIndex = 1; } else { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003003, new string[] { "6", SysID })); if (dr.Read()) { txtID.Text = dr["MacTimeNo"].ToString(); txtName.Text = dr["MacTimeName"].ToString(); TextBox txt; MaskedTextBox mtxt; for (int i = 1; i <= 6; i++) { txt = (TextBox)groupBox1.Controls["txtTime" + i.ToString()]; txt.Text = dr["MacTimeTimes" + i.ToString()].ToString(); mtxt = (MaskedTextBox)groupBox1.Controls["txtBegin" + i.ToString()]; mtxt.Text = dr["MacTimeBeginTime" + i.ToString()].ToString(); mtxt = (MaskedTextBox)groupBox1.Controls["txtEnd" + i.ToString()]; mtxt.Text = dr["MacTimeEndTime" + i.ToString()].ToString(); } SetInTypeIndex(cbbMode1, dr["MacTimeMode1"].ToString()); SetInTypeIndex(cbbMode2, dr["MacTimeMode2"].ToString()); SetInTypeIndex(cbbMode3, dr["MacTimeMode3"].ToString()); SetInTypeIndex(cbbMode4, dr["MacTimeMode4"].ToString()); SetInTypeIndex(cbbMode5, dr["MacTimeMode5"].ToString()); SetInTypeIndex(cbbMode6, dr["MacTimeMode6"].ToString()); } } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } }
private void LoadData() { DataTableReader dr = null; TCommonType ctype; cbbInType1.Items.Clear(); cbbInType2.Items.Clear(); try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } if (SystemInfo.AdvTimeGroup) { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003003, new string[] { "103" })); } else { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003003, new string[] { "102" })); } while (dr.Read()) { ctype = new TCommonType(dr["TimeInTypeSysID"].ToString(), dr["TimeInTypeID"].ToString(), dr["TimeInTypeName"].ToString(), true); cbbInType1.Items.Add(ctype); cbbInType2.Items.Add(ctype); } if (SysID == "") { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003003, new string[] { "101" })); if (dr.Read()) { int no = 0; int.TryParse(dr[0].ToString(), out no); if (no > SystemInfo.MaxTimeNo) { no = SystemInfo.MaxTimeNo; } txtID.Text = no.ToString(); } cbbInType1.SelectedIndex = 0; cbbInType2.SelectedIndex = 0; if (SystemInfo.AdvTimeGroup) { cbbInType1.SelectedIndex = 1; cbbInType2.SelectedIndex = 1; } } else { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003003, new string[] { "6", SysID })); if (dr.Read()) { txtID.Text = dr["MacTimeNo"].ToString(); txtName.Text = dr["MacTimeName"].ToString(); MaskedTextBox txt; for (int i = 1; i <= 3; i++) { txt = (MaskedTextBox)groupBox1.Controls["txtBeginTime" + i.ToString()]; txt.Text = dr["MacTimeBeginTime" + i.ToString()].ToString(); txt = (MaskedTextBox)groupBox1.Controls["txtEndTime" + i.ToString()]; txt.Text = dr["MacTimeEndTime" + i.ToString()].ToString(); } for (int i = 4; i <= 6; i++) { txt = (MaskedTextBox)groupBox2.Controls["txtBeginTime" + i.ToString()]; txt.Text = dr["MacTimeBeginTime" + i.ToString()].ToString(); txt = (MaskedTextBox)groupBox2.Controls["txtEndTime" + i.ToString()]; txt.Text = dr["MacTimeEndTime" + i.ToString()].ToString(); } SetInTypeIndex(cbbInType1, dr["MacTimeInType1"].ToString()); SetInTypeIndex(cbbInType2, dr["MacTimeInType2"].ToString()); string binStr = Pub.DecToBin(dr["MacTimeWeekIndex"].ToString(), 7); if (binStr.Length == 7) { checkBox1.Checked = binStr.Substring(6, 1) == "1"; checkBox2.Checked = binStr.Substring(0, 1) == "1"; checkBox3.Checked = binStr.Substring(1, 1) == "1"; checkBox4.Checked = binStr.Substring(2, 1) == "1"; checkBox5.Checked = binStr.Substring(3, 1) == "1"; checkBox6.Checked = binStr.Substring(4, 1) == "1"; checkBox7.Checked = binStr.Substring(5, 1) == "1"; } if (dr["MacTimeLimit"].ToString() == "1") { rbLimitOne.Checked = true; } } } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } }
private void LoadData() { cbbType.Items.Clear(); TCommonType ctype; DataTableReader dr = null; try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_002002, new string[] { "200" })); while (dr.Read()) { ctype = new TCommonType(dr["TripTypeSysID"].ToString(), dr["TripTypeNo"].ToString(), dr["TripTypeName"].ToString(), true); cbbType.Items.Add(ctype); } if (SysID == "") { if (cbbType.Items.Count > 0) { cbbType.SelectedIndex = 0; } txtNo.Text = GetBillNo(); } else { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_002009, new string[] { "5", SysID })); if (dr.Read()) { txtNo.Text = dr["TripBillNo"].ToString(); txtEmpNo.Text = dr["EmpNo"].ToString(); txtEmpNo.Tag = dr["EmpSysID"].ToString(); txtEmpName.Text = dr["EmpName"].ToString(); txtDepart.Text = "[" + dr["DepartID"].ToString() + "]" + dr["DepartName"].ToString(); DateTime dt = new DateTime(); DateTime.TryParse(dr["TripStartDate"].ToString(), out dt); string[] tt = dr["TripStartTime"].ToString().Split(':'); dt = dt.AddHours(Convert.ToDouble(tt[0])).AddMinutes(Convert.ToDouble(tt[1])); dtpStart.Value = dt; DateTime.TryParse(dr["TripEndDate"].ToString(), out dt); tt = dr["TripEndTime"].ToString().Split(':'); dt = dt.AddHours(Convert.ToDouble(tt[0])).AddMinutes(Convert.ToDouble(tt[1])); dtpEnd.Value = dt; for (int i = 0; i < cbbType.Items.Count; i++) { if (((TCommonType)cbbType.Items[i]).sysID == dr["TripTypeSysID"].ToString()) { cbbType.SelectedIndex = i; break; } } txtReason.Text = dr["TripReason"].ToString(); } } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } }
private void LoadData() { string IsFirstCard = ""; string MacFirstCard = ""; DataTableReader dr = null; cbbMode1.Items.Clear(); cbbMode2.Items.Clear(); try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } TCommonType ctype; dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003001, new string[] { "110" })); while (dr.Read()) { ctype = new TCommonType(dr["MacDoorCommandWaySysID"].ToString(), dr["MacDoorCommandWayID"].ToString(), dr["MacDoorCommandWayName"].ToString(), true); cbbMode1.Items.Add(ctype); cbbMode2.Items.Add(ctype); } dr.Close(); cbbMode1.SelectedIndex = 0; cbbMode2.SelectedIndex = 0; dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003001, new string[] { "102", SysID })); if (dr.Read()) { IsFirstCard = dr["IsFirstCard"].ToString(); MacFirstCard = dr["MacFirstCard"].ToString(); } dr.Close(); TMacFirstCard card = new TMacFirstCard(MacFirstCard); txtBeginTime.Text = card.StartTime; txtEndTime.Text = card.EndTime; SetWayIndex(cbbMode1, card.Way[0]); SetWayIndex(cbbMode2, card.Way[1]); checkBox1.Checked = card.Week[6] == 1; checkBox2.Checked = card.Week[0] == 1; checkBox3.Checked = card.Week[1] == 1; checkBox4.Checked = card.Week[2] == 1; checkBox5.Checked = card.Week[3] == 1; checkBox6.Checked = card.Week[4] == 1; checkBox7.Checked = card.Week[5] == 1; if (card.EmpList != "") { string sql = ""; if (SystemInfo.HasFaCard) { sql = Pub.GetSQL(DBCode.DB_003001, new string[] { "108", card.EmpList }); } else { sql = Pub.GetSQL(DBCode.DB_003001, new string[] { "301", card.EmpList }); } dr = db.GetDataReader(sql); while (dr.Read()) { QuickSearchNormalCardByEmpSysID(dr["EmpSysID"].ToString(), cardGrid, MaxCard); } } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } chkEnabled.Checked = IsFirstCard.ToUpper() == "Y"; chkEnabled_CheckedChanged(null, null); }