protected override void InitForm() { formCode = "KQEmpShift"; SetToolItemState("ItemTAG1", true); SetToolItemState("ItemTAG2", true); SetToolItemState("ItemTAG3", true); //SetToolItemState("ItemLine3", true); //SetToolItemState("ItemLine5", true); SetToolItemState("ItemFindLabel", true); SetToolItemState("ItemFindText", true); InitEmp = true; IgnoreDimission = false; base.InitForm(); SetToolImage("ItemTAG1", "FileSave"); SetToolImage("ItemTAG2", "EditUndo"); SetToolImage("ItemTAG3", "FileSaveAll"); DataTableReader dr = null; TIDAndName idn = new TIDAndName("", ""); ComboBox cbb; for (int i = 1; i <= 31; i++) { cbb = (ComboBox)pnlRight.Controls["cbbDay" + i.ToString("00")]; cbb.Items.Clear(); cbb.Items.Add(idn); } try { dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000204, new string[] { "0" })); while (dr.Read()) { idn = new TIDAndName(dr["ShiftID"].ToString(), "[" + dr["ShiftID"].ToString() + "]" + dr["ShiftName"].ToString()); for (int i = 1; i <= 31; i++) { cbb = (ComboBox)pnlRight.Controls["cbbDay" + i.ToString("00")]; cbb.Items.Add(idn); } } 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.Year, DateTime.Now.Month, 1); }
private void LoadData() { TIDAndName idn = new TIDAndName("", ""); cbbSort.Items.Clear(); DataTableReader dr = null; try { dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000211, new string[] { "2" })); while (dr.Read()) { idn = new TIDAndName(dr["SortID"].ToString(), "[" + dr["SortID"].ToString() + "]" + dr["SortName"].ToString()); cbbSort.Items.Add(idn); } cbbSort.SelectedIndex = 0; dr.Close(); if (SysID != "") { dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000211, new string[] { "3", SysID })); if (dr.Read()) { txtEmpNo.Text = dr["EmpNo"].ToString(); txtEmpName.Text = dr["EmpName"].ToString(); txtDepart.Text = "[" + dr["DepartID"].ToString() + "]" + dr["DepartName"].ToString(); dtpStart.Value = Convert.ToDateTime(dr["BeginTime"].ToString()); dtpEnd.Value = Convert.ToDateTime(dr["EndTime"].ToString()); chkAheadHrs.Checked = Pub.ValueToBool(dr["AheadHrs"].ToString()); chkDeferHrs.Checked = Pub.ValueToBool(dr["DeferHrs"].ToString()); txtAheadMins.Text = dr["AheadMins"].ToString(); txtDeferMins.Text = dr["DeferMins"].ToString(); txtReason.Text = dr["OtReason"].ToString(); for (int i = 0; i < cbbSort.Items.Count; i++) { if (((TIDAndName)cbbSort.Items[i]).id == dr["SortID"].ToString()) { cbbSort.SelectedIndex = i; break; } } dr.Close(); } } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } }
private void LoadData() { TIDAndName idn = new TIDAndName("", ""); cbbRule.Items.Clear(); DataTableReader dr = null; try { dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000401, new string[] { "1" })); while (dr.Read()) { idn = new TIDAndName(dr["ItemID"].ToString(), "[" + dr["ItemID"].ToString() + "]" + dr["ItemName"].ToString()); cbbRule.Items.Add(idn); } if (cbbRule.Items.Count > 0) { cbbRule.SelectedIndex = 0; } dr.Close(); if (SysID != "") { dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000101, new string[] { "12", SysID })); if (dr.Read()) { txtEmpNo.Text = dr["EmpNo"].ToString(); txtEmpName.Text = dr["EmpName"].ToString(); txtEmpNo.Enabled = false; btnSelectEmp.Enabled = false; txtDepartName.Text = dr["DepartName"].ToString(); txtDepartName.Tag = dr["EmpNo"].ToString(); for (int i = 0; i < cbbRule.Items.Count; i++) { if (((TIDAndName)cbbRule.Items[i]).id == dr["EmpGZRuleID"].ToString()) { cbbRule.SelectedIndex = i; break; } } } } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } }
private void initListBox() { TIDAndName item = new TIDAndName("EmpGZ", Pub.GetResText(formCode, "EmpGZ", "")); ListGZItem.Items.Add(item); item = new TIDAndName("MustDaysM", Pub.GetResText(formCode, "MustDays", "")); ListGZItem.Items.Add(item); item = new TIDAndName("WorkDays", Pub.GetResText(formCode, "WorkDays", "")); ListGZItem.Items.Add(item); item = new TIDAndName("SunDays", Pub.GetResText(formCode, "SunDays", "")); ListGZItem.Items.Add(item); item = new TIDAndName("HdDays", Pub.GetResText(formCode, "HdDays", "")); ListGZItem.Items.Add(item); item = new TIDAndName("AbsentDays", Pub.GetResText(formCode, "AbsentDays", "")); ListGZItem.Items.Add(item); item = new TIDAndName("WorkHrs", Pub.GetResText(formCode, "WorkHrs", "")); ListGZItem.Items.Add(item); item = new TIDAndName("LateMins", Pub.GetResText(formCode, "LateMins", "")); ListGZItem.Items.Add(item); item = new TIDAndName("LateCount", Pub.GetResText(formCode, "LateCount", "")); ListGZItem.Items.Add(item); item = new TIDAndName("LeaveMins", Pub.GetResText(formCode, "LeaveMins", "")); ListGZItem.Items.Add(item); item = new TIDAndName("LeaveCount", Pub.GetResText(formCode, "LeaveCount", "")); ListGZItem.Items.Add(item); item = new TIDAndName("OtHrs", Pub.GetResText(formCode, "OtHrs", "")); ListGZItem.Items.Add(item); item = new TIDAndName("SunHrs", Pub.GetResText(formCode, "SunHrs", "")); ListGZItem.Items.Add(item); item = new TIDAndName("HdHrs", Pub.GetResText(formCode, "HdHrs", "")); ListGZItem.Items.Add(item); DataTableReader dr = null; try { dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000400, new string[] { "0" })); while (dr.Read()) { int num = Convert.ToInt32(dr["SortID"].ToString().Substring(3)) - 1; item = new TIDAndName("Hrs1" + num, dr["SortName"].ToString()); ListGZItem.Items.Add(item); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } }
private void InitcbbGZItem() { DataTableReader dr = null; TIDAndName idn = null; bool ret = false; try { dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000404, new string[] { "0" })); while (dr.Read()) { idn = new TIDAndName(dr["ItemID"].ToString(), "[" + dr["ItemID"].ToString() + "]" + dr["ItemName"].ToString()); for (int i = 0; i < cbbGZItem.Items.Count; i++) { if (((TIDAndName)cbbGZItem.Items[i]).name.Equals(idn.name)) { ret = true; break; } ret = false; } if (!ret) { cbbGZItem.Items.Add(idn); } } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } if (cbbGZItem.Items.Count > 0) { cbbGZItem.SelectedIndex = 0; } else { ItemRefresh.Enabled = false; InitRepVisiable(); } }
private void initlb() { DataTableReader dr = null; try { TIDAndName item; dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000401, new string[] { "0", SysID })); while (dr.Read()) { item = new TIDAndName(dr["RuleID"].ToString(), dr["RuleName"].ToString()); if (dr["RuleMode"].ToString() == "1") { lbGZItemIn.Items.Add(item); } else { lbGZItemOut.Items.Add(item); } list.Add(dr["RuleID"].ToString(), item); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } if (lbGZItemIn.Items.Count > 0) { lbGZItemIn.SelectedIndex = 0; } if (lbGZItemOut.Items.Count > 0) { lbGZItemOut.SelectedIndex = 0; } }
protected override void InitForm() { SelectVer = ""; USBFile = ""; formCode = "FKFirmwareVer"; base.InitForm(); this.Text = Title; dlgOpen.Filter = Pub.GetResText(formCode, "FilterUSBF", "") + "(*.dat)|*.dat"; dlgSave.Filter = Pub.GetResText(formCode, "FilterUSBF", "") + "(*.dat)|*.dat"; USBPath = SystemInfo.AppPath; cbbVer.Items.Clear(); TIDAndName id = new TIDAndName("HS001", "HS001[NEO]"); cbbVer.Items.Add(id); id = new TIDAndName("HS002", "HS002[NEO]"); cbbVer.Items.Add(id); id = new TIDAndName("HS101", "HS101[PRO]"); cbbVer.Items.Add(id); cbbVer.SelectedIndex = 0; }
private void add(ListBox lbFrom, ListBox lbTo) { TIDAndName item = (TIDAndName)lbFrom.SelectedItem; int i = lbFrom.SelectedIndex; if (item == null) { return; } lbFrom.Items.Remove(item); if (lbFrom.Items.Count > 0) { if (i == 0) { i++; } lbFrom.SelectedIndex = i - 1; } lbTo.Items.Add(item); lbTo.SelectedItem = item; }
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 = dtpStart.Value.AddMonths(1).AddDays(-1); DataTableReader dr = null; TIDAndName idn; cbbRule.Items.Clear(); try { dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000205, new string[] { "0" })); while (dr.Read()) { idn = new TIDAndName(dr["ShiftRuleID"].ToString(), "[" + dr["ShiftRuleID"].ToString() + "]" + dr["ShiftRuleName"].ToString()); cbbRule.Items.Add(idn); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } if (cbbRule.Items.Count > 0) { cbbRule.SelectedIndex = 0; } InitDepartTreeView(tvDepart); }
private void AddClearItem(byte flag, string name) { TIDAndName idn = new TIDAndName(flag.ToString() + name, Pub.GetResText(formCode, "mnu" + name, "")); clbClear.Items.Add(idn); }
private void LoadData() { TIDAndName idn = new TIDAndName("", ""); ComboBox cbb; for (int i = 1; i <= 31; i++) { cbb = (ComboBox)this.groupBox1.Controls["cbb" + i.ToString().Trim()]; cbb.Items.Add(idn); cbb.SelectedIndex = 0; } DataTableReader dr = null; try { dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000204, new string[] { "0" })); while (dr.Read()) { idn = new TIDAndName(dr["ShiftID"].ToString(), "[" + dr["ShiftID"].ToString() + "]" + dr["ShiftName"].ToString()); for (int i = 1; i <= 31; i++) { cbb = (ComboBox)this.groupBox1.Controls["cbb" + i.ToString().Trim()]; cbb.Items.Add(idn); } } dr.Close(); if (SysID != "") { int row = 0; txtShiftRuleID.Enabled = false; dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000205, new string[] { "3", SysID })); if (dr.Read()) { txtShiftRuleID.Text = dr["ShiftRuleID"].ToString(); txtShiftRuleName.Text = dr["ShiftRuleName"].ToString(); cbbShiftRulecycName.SelectedIndex = int.Parse(dr["ShiftRulecycID"].ToString()); txtShiftRulecyc.Text = dr["ShiftRulecyc"].ToString(); dr.Close(); dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000205, new string[] { "4", SysID })); while (dr.Read()) { int.TryParse(dr["ShiftRulecycNo"].ToString(), out row); cbb = (ComboBox)this.groupBox1.Controls["cbb" + row.ToString().Trim()]; for (int i = 0; i < cbb.Items.Count; i++) { if (((TIDAndName)cbb.Items[i]).id == dr["ShiftID"].ToString()) { cbb.SelectedIndex = i; break; } } } } } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } }
private void LoadData() { cbbSun.Items.Clear(); cbbMon.Items.Clear(); cbbTue.Items.Clear(); cbbWed.Items.Clear(); cbbThu.Items.Clear(); cbbFri.Items.Clear(); cbbSat.Items.Clear(); cbbSun.Items.Add("0"); cbbMon.Items.Add("0"); cbbTue.Items.Add("0"); cbbWed.Items.Add("0"); cbbThu.Items.Add("0"); cbbFri.Items.Add("0"); cbbSat.Items.Add("0"); DataTableReader dr = null; TIDAndName idn; try { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_002001, new string[] { "3000" })); while (dr.Read()) { idn = new TIDAndName(dr["PassTimeID"].ToString(), "[" + dr["PassTimeID"].ToString() + "]" + dr["PassTimeName"].ToString()); cbbSun.Items.Add(idn); cbbMon.Items.Add(idn); cbbTue.Items.Add(idn); cbbWed.Items.Add(idn); cbbThu.Items.Add(idn); cbbFri.Items.Add(idn); cbbSat.Items.Add(idn); } dr.Close(); dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_002001, new string[] { "4009", SysID, _MacSN })); if (dr.Read()) { txtEmpNo.Text = dr["EmpNo"].ToString(); txtEmpName.Text = dr["EmpName"].ToString(); txtDepartName.Text = dr["DepartName"].ToString(); SetTimeIndex(cbbSun, dr["SunID"].ToString()); SetTimeIndex(cbbMon, dr["MonID"].ToString()); SetTimeIndex(cbbTue, dr["TueID"].ToString()); SetTimeIndex(cbbWed, dr["WedID"].ToString()); SetTimeIndex(cbbThu, dr["ThuID"].ToString()); SetTimeIndex(cbbFri, dr["FriID"].ToString()); SetTimeIndex(cbbSat, dr["SatID"].ToString()); DateTime d = new DateTime(); if (DateTime.TryParse(dr["StartDate"].ToString(), out d)) { txtStartDate.Text = d.ToShortDateString(); } if (DateTime.TryParse(dr["EndDate"].ToString(), out d)) { txtEndDate.Text = d.ToShortDateString(); } } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } }
private void LoadData() { TIDAndName idn = new TIDAndName("", ""); cbbSort1.Items.Clear(); cbbSort2.Items.Clear(); cbbSort3.Items.Clear(); cbbSort4.Items.Clear(); cbbSort5.Items.Clear(); idn = new TIDAndName("", ""); cbbSort2.Items.Add(idn); cbbSort3.Items.Add(idn); cbbSort4.Items.Add(idn); cbbSort5.Items.Add(idn); DataTableReader dr = null; try { dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000204, new string[] { "2" })); while (dr.Read()) { idn = new TIDAndName(dr["SortID"].ToString(), "[" + dr["SortID"].ToString() + "]" + dr["SortName"].ToString()); cbbSort1.Items.Add(idn); cbbSort2.Items.Add(idn); cbbSort3.Items.Add(idn); cbbSort4.Items.Add(idn); cbbSort5.Items.Add(idn); } cbbSort1.SelectedIndex = 0; cbbSort2.SelectedIndex = 0; cbbSort3.SelectedIndex = 0; cbbSort4.SelectedIndex = 0; cbbSort5.SelectedIndex = 0; dr.Close(); if (SysID != "") { txtShiftID.Enabled = false; dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000204, new string[] { "3", SysID })); if (dr.Read()) { txtShiftID.Text = dr["ShiftID"].ToString(); txtShiftName.Text = dr["ShiftName"].ToString(); chkIsAuto.Checked = Pub.ValueToBool(dr["IsAuto"].ToString()); TextBox txtAhead; TextBox txtDefer; MaskedTextBox txtSignin; MaskedTextBox txtSignout; CheckBox chkSignin; CheckBox chkSignout; CheckBox chkDrift; ComboBox cbbSort; string s; for (int No = 1; No <= 5; No++) { txtAhead = (TextBox)this.Controls["txtAhead" + No.ToString()]; txtDefer = (TextBox)this.Controls["txtDefer" + No.ToString()]; txtSignin = (MaskedTextBox)this.Controls["txtSignin" + No.ToString()]; txtSignout = (MaskedTextBox)this.Controls["txtSignout" + No.ToString()]; chkSignin = (CheckBox)this.Controls["chkSignin" + No.ToString()]; chkSignout = (CheckBox)this.Controls["chkSignout" + No.ToString()]; chkDrift = (CheckBox)this.Controls["chkDrift" + No.ToString()]; cbbSort = (ComboBox)this.Controls["cbbSort" + No.ToString()]; chkDrift.Checked = Pub.ValueToBool(dr["Drift" + No.ToString()].ToString()); chkSignin.Checked = Pub.ValueToBool(dr["Signin" + No.ToString()].ToString()); chkSignout.Checked = Pub.ValueToBool(dr["Signout" + No.ToString()].ToString()); txtAhead.Text = dr["ShiftAhead" + No.ToString()].ToString(); txtDefer.Text = dr["ShiftDefer" + No.ToString()].ToString(); s = dr["SigninTime" + No.ToString()].ToString(); if (s == "") { s = "00:00"; } txtSignin.Text = s; s = dr["SignoutTime" + No.ToString()].ToString(); if (s == "") { s = "00:00"; } txtSignout.Text = s; for (int i = 0; i < cbbSort.Items.Count; i++) { if (((TIDAndName)cbbSort.Items[i]).id == dr["SortID" + No.ToString()].ToString()) { cbbSort.SelectedIndex = i; break; } } } dr.Close(); dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000204, new string[] { "4", txtShiftID.Text })); while (dr.Read()) { for (int i = 0; i < tvDepart.Nodes.Count; i++) { SetNodeChecked(tvDepart.Nodes[i], dr["DepartID"].ToString()); } } } } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } }
private void LoadData() { cbbSun.Items.Clear(); cbbMon.Items.Clear(); cbbTue.Items.Clear(); cbbWed.Items.Clear(); cbbThu.Items.Clear(); cbbFri.Items.Clear(); cbbSat.Items.Clear(); cbbSun.Items.Add("0"); cbbMon.Items.Add("0"); cbbTue.Items.Add("0"); cbbWed.Items.Add("0"); cbbThu.Items.Add("0"); cbbFri.Items.Add("0"); cbbSat.Items.Add("0"); DataTableReader dr = null; TIDAndName idn; try { dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000300, new string[] { "400" })); while (dr.Read()) { idn = new TIDAndName(dr["PassTimeID"].ToString(), "[" + dr["PassTimeID"].ToString() + "]" + dr["PassTimeName"].ToString()); cbbSun.Items.Add(idn); cbbMon.Items.Add(idn); cbbTue.Items.Add(idn); cbbWed.Items.Add(idn); cbbThu.Items.Add(idn); cbbFri.Items.Add(idn); cbbSat.Items.Add(idn); } dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000300, new string[] { "0" })); int rowindex = 0; while (dr.Read()) { macGrid.Rows.Add(); macGrid[0, rowindex].Value = true; macGrid[1, rowindex].Value = dr["MacSN"].ToString(); rowindex++; } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } cbbSun.SelectedIndex = 0; cbbMon.SelectedIndex = 0; cbbTue.SelectedIndex = 0; cbbWed.SelectedIndex = 0; cbbThu.SelectedIndex = 0; cbbFri.SelectedIndex = 0; cbbSat.SelectedIndex = 0; }
private void cbbGZItem_SelectedIndexChanged(object sender, EventArgs e) { InitRepVisiable(); if (cbbGZItem.SelectedIndex == -1) { return; } DataTableReader dr = null; TIDAndName idn = null; string[] In = null, Out = null; idn = (TIDAndName)cbbGZItem.SelectedItem; if (idn != null) { try { dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000404, new string[] { "1", idn.id })); if (dr.Read()) { In = dr["In"].ToString().Split(','); Out = dr["Out"].ToString().Split(','); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } } if (In != null) { Report.DetailGrid.Columns[3].TitleCell.Visible = true; for (int i = 0; i < In.Length; i++) { if (In[i] == "") { continue; } Report.DetailGrid.Columns[i + 3].Visible = true; Report.DetailGrid.Columns[i + 3].TitleCell.Text = In[i]; } } if (Out != null) { Report.DetailGrid.Columns[23].TitleCell.Visible = true; for (int i = 0; i < Out.Length; i++) { if (Out[i] == "") { continue; } Report.DetailGrid.Columns[i + 23].Visible = true; Report.DetailGrid.Columns[i + 23].TitleCell.Text = Out[i]; } } QuerySQL = ""; dispView.Refresh(); base.ExecItemRefresh(); }