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