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