private void button6_Click(object sender, EventArgs e)
{
if (tabControl1.SelectedTab == tabPage1)
{
SelectReportName = txtName.Text.Trim();
if (SelectReportName == "")
{
txtName.Focus();
ShowErrorEnterCorrect(label2.Text);
return;
}
if (!Pub.CheckTextMaxLength(label2.Text, SelectReportName, txtName.MaxLength))
{
txtName.Focus();
return;
}
if (cbbTable.SelectedIndex == -1)
{
cbbTable.Focus();
ShowErrorSelectCorrect(label3.Text);
return;
}
SelectTableName = ((TCommonType)cbbTable.Items[cbbTable.SelectedIndex]).id;
if (!LoadSource())
{
return;
}
tabControl1.TabPages.Clear();
tabControl1.TabPages.Add(tabPage2);
}
else if (tabControl1.SelectedTab == tabPage2)
{
if (GetGridCount(fdGrid) == 0)
{
fdGrid.Focus();
Pub.MessageBoxShow(Pub.GetResText(formCode, "Error001", ""));
return;
}
LoadGroup();
tabControl1.TabPages.Clear();
tabControl1.TabPages.Add(tabPage3);
}
else if (tabControl1.SelectedTab == tabPage3)
{
tabControl1.TabPages.Clear();
tabControl1.TabPages.Add(tabPage4);
}
else if (tabControl1.SelectedTab == tabPage4)
{
tabControl1.TabPages.Clear();
tabControl1.TabPages.Add(tabPage5);
}
else if (tabControl1.SelectedTab == tabPage5)
{
tabControl1.TabPages.Clear();
tabControl1.TabPages.Add(tabPage6);
}
tabControl1.SelectedTab = tabControl1.TabPages[0];
RefreshForm();
}
private void btnOk_Click(object sender, EventArgs e)
{
if (dtpStart.Value > dtpEnd.Value)
{
dtpStart.Focus();
Pub.ShowErrorMsg(Pub.GetResText(formCode, "ErrorStartDateBegreater", ""));
return;
}
HoliName = txtName.Text.Trim();
if (!Pub.CheckTextMaxLength(label3.Text, HoliName, txtName.MaxLength))
{
return;
}
if (cbbTime.SelectedIndex == -1)
{
cbbTime.Focus();
ShowErrorSelectCorrect(label4.Text);
return;
}
StartDate = dtpStart.Value.Date;
EndDate = dtpEnd.Value.Date;
HoliTime = cbbTime.Text;
OtType = cbbType.Text;
this.DialogResult = DialogResult.OK;
this.Close();
}
private void btnOk_Click(object sender, EventArgs e)
{
string v = "";
for (int i = 0; i < doorGrid.RowCount; i++)
{
v = doorGrid[1, i].EditedFormattedValue.ToString();
if (!Pub.CheckTextMaxLength(doorGrid.Columns[1].HeaderText, v, 50))
{
return;
}
v = doorGrid[2, i].EditedFormattedValue.ToString();
if (!Pub.IsNumeric(v) || (Convert.ToInt32(v) < 0) || (Convert.ToInt32(v) > 255))
{
Pub.ShowErrorMsg(Pub.GetResText(formCode, "Error001", ""));
return;
}
}
bool IsOk = false;
string s1 = "";
string s2 = "";
List <string> sql = new List <string>();
try
{
for (int i = 0; i < doorGrid.RowCount; i++)
{
sql.Add(Pub.GetSQL(DBCode.DB_003001, new string[] { "9", doorGrid[1, i].EditedFormattedValue.ToString(),
doorGrid[2, i].EditedFormattedValue.ToString(), doorGrid[0, i].Tag.ToString() }));
}
for (int i = 0; i < readGrid.RowCount; i++)
{
s1 = Pub.ValueToBool(readGrid[2, i].EditedFormattedValue) ? "Y" : "N";
s2 = Pub.ValueToBool(readGrid[3, i].EditedFormattedValue) ? "Y" : "N";
sql.Add(Pub.GetSQL(DBCode.DB_003001, new string[] { "10", readGrid[1, i].EditedFormattedValue.ToString(),
s1, s2, readGrid[0, i].Tag.ToString() }));
}
if (db.ExecSQL(sql) == 0)
{
IsOk = true;
}
}
catch (Exception E)
{
Pub.ShowErrorMsg(E);
}
if (IsOk)
{
db.WriteSYLog(this.Text, CurrentOprt, sql);
Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
private void btnOk_Click(object sender, EventArgs e)
{
if (!CheckEmp())
{
return;
}
if (dataGrid.RowCount == 0)
{
Pub.ShowErrorMsg(Pub.GetResText(formCode, "Error001", ""));
return;
}
string EmpSysID = txtEmpNo.Tag.ToString();
string Remark = txtRemark.Text.Trim();
if (!Pub.CheckTextMaxLength(label8.Text, Remark, txtRemark.MaxLength))
{
return;
}
List <string> sql = new List <string>();
GetSql(EmpSysID, Remark, ref sql);
if (cardGrid.DataSource != null)
{
DataTable dtGrid = (DataTable)cardGrid.DataSource;
for (int i = 0; i < dtGrid.Rows.Count; i++)
{
if (dtGrid.Rows[i]["EmpSysID"].ToString() == EmpSysID)
{
continue;
}
GetSql(dtGrid.Rows[i]["EmpSysID"].ToString(), Remark, ref sql);
}
}
if (db.ExecSQL(sql) != 0)
{
return;
}
db.WriteSYLog(this.Text, CurrentOprt, sql);
Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
private void btnOk_Click(object sender, EventArgs e)
{
if (!db.CheckOprtRole(formCode, "M", true))
{
return;
}
CurrentOprt = btnOk.Text;
string T0 = txtTitle0.Text;
string T1 = txtTitle1.Text;
string T2 = txtTitle2.Text;
string T3 = txtTitle3.Text;
string T4 = txtTitle4.Text;
int I0 = cbbOption0.SelectedIndex;
int I1 = cbbOption1.SelectedIndex;
int I2 = cbbOption2.SelectedIndex;
int I3 = cbbOption3.SelectedIndex;
int I4 = cbbOption4.SelectedIndex;
if (!Pub.CheckTextMaxLength(label1.Text, T0, txtTitle0.MaxLength))
{
return;
}
if (!Pub.CheckTextMaxLength(label2.Text, T1, txtTitle1.MaxLength))
{
return;
}
if (!Pub.CheckTextMaxLength(label3.Text, T2, txtTitle2.MaxLength))
{
return;
}
if (!Pub.CheckTextMaxLength(label4.Text, T3, txtTitle3.MaxLength))
{
return;
}
if (!Pub.CheckTextMaxLength(label5.Text, T4, txtTitle4.MaxLength))
{
return;
}
int PrintLine = 0;
int.TryParse(txtLine.Text.Trim(), out PrintLine);
if ((PrintLine < 0) || (PrintLine > 255))
{
string msg = string.Format(Pub.GetResText(formCode, "Error001", ""), 0, 255);
Pub.ShowErrorMsg(msg);
return;
}
DataTableReader dr = null;
string sql = "";
bool ret = false;
try
{
if (!db.IsOpen)
{
db.Open(SystemInfo.ConnStr);
}
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004002, new string[] { "0" }));
if (dr.Read())
{
sql = Pub.GetSQL(DBCode.DB_004002, new string[] { "2", T0, T1, T2, T3, T4, I0.ToString(), I1.ToString(),
I2.ToString(), I3.ToString(), I4.ToString(), PrintLine.ToString() });
}
else
{
sql = Pub.GetSQL(DBCode.DB_004002, new string[] { "1", T0, T1, T2, T3, T4, I0.ToString(), I1.ToString(),
I2.ToString(), I3.ToString(), I4.ToString(), PrintLine.ToString() });
}
db.ExecSQL(sql);
byte[] buff = new byte[0];
if (picLogo.BackgroundImage != null)
{
MemoryStream ms = new MemoryStream();
picLogo.BackgroundImage.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp);
buff = ms.ToArray();
}
db.UpdateByteData(Pub.GetSQL(DBCode.DB_004002, new string[] { "3" }), "PrintLogo", buff);
ret = true;
}
catch (Exception E)
{
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
if (ret)
{
db.WriteSYLog(this.Text, CurrentOprt, sql);
Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
private void WriteCard()
{
if (!IsReadCard)
{
Pub.ShowErrorMsg(Pub.GetResText(formCode, "MsgEmpFindFirst", ""));
return;
}
string CardNo = txtCardNo.Text.Trim();
string OldCardNo = txtCardSectorNo.Text;
if (SystemInfo.AllowCustomerCardNo)
{
if ((CardNo == "") || (!Pub.IsNumeric(CardNo)))
{
txtCardNo.Focus();
ShowErrorEnterCorrect(label6.Text);
return;
}
if (!Pub.CheckTextMaxLength(label6.Text, CardNo, txtCardNo.MaxLength))
{
txtCardNo.Focus();
return;
}
CardNo = Convert.ToUInt32(CardNo).ToString("0000000000");
}
if ((CardNo == "") || (!Pub.IsNumeric(CardNo)))
{
txtCardNo.Focus();
ShowErrorEnterCorrect(label6.Text);
return;
}
if (!Pub.CheckTextMaxLength(label6.Text, CardNo, txtCardNo.MaxLength))
{
txtCardNo.Focus();
return;
}
CardNo = Convert.ToUInt32(CardNo).ToString("0000000000");
OldCardNo = Convert.ToUInt32(OldCardNo).ToString("0000000000");
string CardNoDays = "";
string msg = "";
DateTime dt = new DateTime();
if (!db.GetServerDate(ref dt))
{
return;
}
DateTime d = new DateTime();
if (SystemInfo.AllowCustomerCardNo)
{
if (db.CardSectorNoIsExists(EmpSysID, CardNo, ref CardNoDays))
{
if (CardNoDays == " ")
{
msg = Pub.GetResText(formCode, "MsgCardExistsBlack", "");
}
else if (DateTime.TryParse(CardNoDays, out d))
{
msg = Pub.GetResText(formCode, "MsgCardExistsUseDays", "");
}
else
{
msg = Pub.GetResText(formCode, "MsgCardExistsUseing", "");
}
msg = string.Format(msg, CardNo, CardNoDays);
if (Pub.MessageBoxShowQuestion(msg))
{
return;
}
CardNo = db.GetMaxCardSectorNo();
if (CardNo == "")
{
Pub.ShowErrorMsg(Pub.GetResText(formCode, "ErrorBuildCardFailed", ""));
return;
}
}
}
int cardRet = 0;
if (SystemInfo.HasSF)
{
cardRet = db.CheckSFAllowance(EmpSysID);
if (cardRet == 1)
{
if (!Pub.MessageBoxShowQuestion(Pub.GetResText(formCode, "MsgCardHasAllowance", "")))
{
IsWorking = false;
ShowSFAllowance = true;
this.Close();
return;
}
}
else if (cardRet == 2)
{
return;
}
}
string CardData10 = "";
string CardDataH = "";
string CardData8 = "";
string UseEmpNo = "";
if (!Pub.CheckCardExists(ref CardData10, ref CardDataH, ref CardData8))
{
return;
}
cardRet = db.CheckCardPhysicsNo(EmpSysID, CardData10, ref UseEmpNo);
if (cardRet == 1)
{
Pub.ShowErrorMsg(string.Format(Pub.GetResText(formCode, "MsgCardCheckExistsUseing", ""), CardData10, UseEmpNo));
return;
}
else if (cardRet == 2)
{
Pub.ShowErrorMsg(string.Format(Pub.GetResText(formCode, "MsgCardExistsBlackAgainA", ""), CardData10));
return;
}
else if (cardRet == 3)
{
return;
}
if (CardBalance < 0)
{
Pub.ShowErrorMsg(Pub.GetResText(formCode, "Msg001", ""));
return;
}
//if (!SystemInfo.AllowCustomerCardNo) CardNo = CardData10;
if (CardNo == "")
{
CardNo = db.GetMaxCardSectorNo();
CardNo = Convert.ToUInt32(CardNo).ToString("0000000000");
}
if (CardNo != "")
{
DataTableReader dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_001003, new string[] { "206", CardNo }));
if (dr.Read())
{
txtCardNo.Focus();
ShowErrorCannotRepeated(label6.Text);
return;
}
if (db.CardSectorNoIsExists(SysID, CardNo, ref CardNoDays))
{
if (CardNoDays == " ")
{
msg = Pub.GetResText(formCode, "MsgCardExistsBlackAgainA", "");
}
else if (DateTime.TryParse(CardNoDays, out d))
{
msg = Pub.GetResText(formCode, "MsgCardExistsUseDaysAgainA", "");
}
else
{
msg = Pub.GetResText(formCode, "MsgCardExistsUseingAgainA", "");
}
msg = string.Format(msg, CardNo, CardNoDays);
txtCardNo.Focus();
Pub.ShowErrorMsg(msg);
return;
}
}
HSUNFK.TCardPubData pubData = new HSUNFK.TCardPubData();
if (!Pub.ReadCardInfo(ref pubData))
{
return;
}
if (pubData.DealersCode != SystemInfo.DealersCode)
{
Pub.ShowErrorMsg(Pub.GetResText(formCode, "ErrorIllegalCard", ""));
return;
}
if ((pubData.CardNo != "") && (Convert.ToUInt32(pubData.CardNo) > 0))
{
Pub.ShowErrorMsg(Pub.GetResText(formCode, "MsgCardFaExists", ""));
return;
}
pubData.EmpNo = txtEmpNo.Text;
pubData.EmpName = txtEmpName.Text;
pubData.CardNo = CardNo;
pubData.CardTypeID = CardTypeID;
pubData.CardPWD = CardPWD;
pubData.DealersCode = SystemInfo.DealersCode;
pubData.CustomersCode = SystemInfo.CustomersCode;
pubData.CardBeginDate = CardStartDate.Date;
pubData.CardEndDate = CardEndDate.Date;
pubData.IsCheckOrder = Convert.ToByte(CardCheckOrder);
HSUNFK.TCardSFData sfData = new HSUNFK.TCardSFData();
sfData.Balance = CardBalance;
sfData.UseDate = CardUseDate;
sfData.UseTimes = CardUseTimes;
sfData.BtMonery = BTBalance;
if (BTFlag != "")
{
BTFlag = DeviceObject.objCPIC.NumToHex(BTFlag.Substring(0, 2), 1) +
DeviceObject.objCPIC.NumToHex(BTFlag.Substring(2, 2), 1) +
DeviceObject.objCPIC.NumToHex(BTFlag.Substring(4, 2), 1);
}
sfData.BtDate = BTFlag == "" ? "000000" : BTFlag;
HSUNFK.TCardSKData skData = new HSUNFK.TCardSKData();
skData.CardID = pubData.CardNo;
skData.CardTime = CardUseDate;
bool IsError = false;
string CardNo10 = "";
string CardNoH = "";
string CardNo8 = "";
string oprtMsg = "[" + txtEmpNo.Text + "]" + txtEmpName.Text + ": " + CardNo + "/" + txtDepartName.Text;
ContinuePS:
Application.DoEvents();
if (IsError)
{
if (!DeviceObject.objCPIC.GetCardData(ref CardNo10, ref CardNoH, ref CardNo8))
{
lblResult.Text = Pub.GetResText(formCode, "ReadCardError3", "");
goto ContinuePS;
}
if (CardNo10 != CardData10)
{
if (Pub.MessageBoxShowQuestion(Pub.GetResText(formCode, "MsgCardSame", "")))
{
return;
}
else
{
goto ContinuePS;
}
}
IsError = false;
}
cardRet = Pub.WriteCardInfo(pubData, sfData, skData);
if (cardRet != 0)
{
if (Pub.MessageBoxShowQuestion(Pub.GetCardMsg(cardRet) + Pub.GetResText(formCode, "MsgContinue", "")))
{
return;
}
else
{
IsError = true;
goto ContinuePS;
}
}
ContinueData:
Application.DoEvents();
if (!db.EmpCardChange(this.Text, oprt, EmpSysID, CardNo, CardData10, CardData8, CardFee,
CardData10, DeviceObject.objCPIC.GetMacTAG()))
{
if (Pub.MessageBoxShowQuestion(Pub.GetResText(formCode, "ErrorCardDB", "")))
{
Pub.ShowErrorMsg(Pub.GetResText(formCode, "MsgCardChangeFailed", ""));
return;
}
else
{
goto ContinueData;
}
}
Pub.CardBuzzer();
lblResult.Text = Pub.GetResText(formCode, "MsgCardChangeSuccess", "");
IsChgOk = true;
IsReadCard = false;
DateTime cdt = new DateTime();
if (!db.GetServerDate(ref cdt))
{
return;
}
db.EmpHistoryCard(this.Text, oprt, EmpSysID, OldCardNo, cdt, 3);
db.EmpHistoryCard(this.Text, oprt, EmpSysID, CardNo, cdt, 2);
db.WriteSYLog(this.Text, oprt, oprtMsg);
db.UpdateEmpRegisterData(EmpSysID, 11, CardData10);
Pub.MessageBoxShow(lblResult.Text, MessageBoxIcon.Information);
ResetForm();
}
private void btnOk_Click(object sender, EventArgs e)
{
DataTableReader dr = null;
string EmpNo = txtEmpNo.Text.Trim();
try
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_001002, new string[] { "100", EmpNo }));
if (dr.Read())
{
string tmp = dr["CardStatusID"].ToString();
if (!tmp.Contains("10") && !tmp.Contains("60"))
{
Pub.ShowErrorMsg(string.Format(Pub.GetResText(formCode, "ErrorNotEmp", "")));
return;
}
}
}
catch (Exception E)
{
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
if (EmpNo == "" && cardGrid.Rows.Count == 0)
{
txtEmpNo.Focus();
ShowErrorEnterCorrect(label2.Text);
return;
}
string DimissionOprt = txtDimissionOprt.Text.Trim();
if (DimissionOprt == "")
{
txtDimissionOprt.Focus();
ShowErrorEnterCorrect(label4.Text);
return;
}
string DimissionReason = txtDimissionReason.Text.Trim();
//if (DimissionReason == "")
//{
// txtDimissionReason.Focus();
// ShowErrorEnterCorrect(label8.Text);
// return;
//}
string DimissionDate = dtpDimissionDate.Value.ToString(SystemInfo.SQLDateTimeFMT);
if (!Pub.CheckTextMaxLength(label8.Text, DimissionReason, txtDimissionReason.MaxLength))
{
return;
}
List <string> sql = new List <string>();
if (cardGrid.Rows.Count > 0)
{
DataTable dtGrid = (DataTable)cardGrid.DataSource;
for (int i = 0; i < dtGrid.Rows.Count; i++)
{
string dtEmpNo = dtGrid.Rows[i]["EmpNo"].ToString();
try
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_001002, new string[] { "100", dtEmpNo }));
if (dr.Read())
{
string tmp = dr["CardStatusID"].ToString();
if (!tmp.Contains("10") && !tmp.Contains("60"))
{
Pub.ShowErrorMsg(string.Format(Pub.GetResText(formCode, "ErrorNotEmp", "")));
return;
}
}
}
catch (Exception E)
{
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
sql.Add(Pub.GetSQL(DBCode.DB_001003, new string[] { "23", dtEmpNo, DimissionOprt, DimissionReason, DimissionDate }));
}
}
if (EmpNo != "")
{
sql.Add(Pub.GetSQL(DBCode.DB_001003, new string[] { "23", EmpNo, DimissionOprt, DimissionReason, DimissionDate }));
}
try
{
if (!db.IsOpen)
{
db.Open(SystemInfo.ConnStr);
}
}
catch (Exception E)
{
Pub.ShowErrorMsg(E);
return;
}
if (db.ExecSQL(sql) != 0)
{
return;
}
db.WriteSYLog(title, oprt, sql);
Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information);
BtnStauta(false);
this.DialogResult = DialogResult.OK;
this.Close();
}
private bool CheckValue()
{
if (txtMacSN.Text.Trim() == "")
{
txtMacSN.Focus();
ShowErrorEnterCorrect(lblMacSN.Text);
return(false);
}
IsGPRS = false;
if (rbLAN.Checked)
{
IsGPRS = chkGPRS.Checked;
}
if (IsGPRS)
{
MacSN_GPRS = txtMacSN.Text.Trim();
}
else
{
if (!Pub.IsNumeric(txtMacSN.Text))
{
txtMacSN.Focus();
Pub.ShowErrorMsg(string.Format(Pub.GetResText(formCode, "ErrorMacSN603", ""), 1, SystemInfo.MaxSNFinger));
return(false);
}
MacSN = Convert.ToInt32(txtMacSN.Text);
if ((MacSN < 1) || (MacSN > SystemInfo.MaxSNFinger))
{
txtMacSN.Focus();
Pub.ShowErrorMsg(string.Format(Pub.GetResText(formCode, "ErrorMacSN603", ""), 1, SystemInfo.MaxSNFinger));
return(false);
}
MacSN_GPRS = MacSN.ToString();
}
MacConnType = MacConnTypeString.USB;
MacIPAddress = "";
MacPort = "";
MacConnPWD = "";
MacDesc = "";
MacPhysicsAddress = "";
if (rbComm.Checked)
{
MacConnType = MacConnTypeString.Comm;
MacPort = cbbCommPort.Text;
MacConnPWD = cbbCommBaudRate.Text;
}
else if (rbLAN.Checked)
{
MacConnType = MacConnTypeString.LAN;
MacIPAddress = txtLANIP.Text.Trim();
MacPort = txtLANPort.Text.Trim();
if (MacIPAddress == "")
{
txtLANIP.Focus();
Pub.ShowErrorMsg(Pub.GetResText(formCode, "ErrorMacIP", ""));
return(false);
}
if (!Pub.CheckTextMaxLength(lblLANIP.Text, MacIPAddress, txtLANIP.MaxLength))
{
txtLANIP.Focus();
return(false);
}
if (!Pub.IsNumeric(MacPort))
{
txtLANPort.Focus();
Pub.ShowErrorMsg(Pub.GetResText(formCode, "ErrorMacPort", ""));
return(false);
}
}
MacDesc = txtDesc.Text.Trim();
if (!Pub.CheckTextMaxLength(label1.Text, MacDesc, txtDesc.MaxLength))
{
txtDesc.Focus();
return(false);
}
return(true);
}
private void btnOk_Click(object sender, EventArgs e)
{
string ShiftNo = txtNo.Text.Trim();
string ShiftName = txtName.Text.Trim();
if (!Pub.CheckTextMaxLength(label1.Text, ShiftNo, txtNo.MaxLength))
{
return;
}
if (!Pub.CheckTextMaxLength(label2.Text, ShiftName, txtName.MaxLength))
{
return;
}
if (ShiftNo == "")
{
txtNo.Focus();
ShowErrorEnterCorrect(label1.Text);
return;
}
if (ShiftName == "")
{
txtName.Focus();
ShowErrorEnterCorrect(label2.Text);
return;
}
int[] InTime = new int[5];
int[] OutTime = new int[5];
string[] InIsPressed = new string[5];
string[] OutIsPressed = new string[5];
int[] InBefore = new int[5];
int[] OutAfter = new int[5];
int[] InLater = new int[5];
int[] InMaxLater = new int[5];
int[] OutLeaveEarly = new int[5];
int[] OutMaxLeaveEarly = new int[5];
string[] OtTypeSysID = new string[5];
int ShiftNormalMin = 0;
int ShiftOTMin = 0;
int[] RestMin = new int[4];
string[] ISFu = new string[5];
const int DaySeconds = 24 * 3600;
TextBox txt;
MaskedTextBox txtA;
MaskedTextBox txtB;
ComboBox cbb;
CheckBox chk;
DateTime dt = new DateTime();
for (int i = 1; i <= 5; i++)
{
txtA = (MaskedTextBox)tabPage1.Controls["txtInTime" + i.ToString()];
txtB = (MaskedTextBox)tabPage1.Controls["txtOutTime" + i.ToString()];
if ((txtA.Text == "00:00") && (txtB.Text == "00:00"))
{
continue;
}
if (!DateTime.TryParse(txtA.Text, out dt))
{
continue;
}
InTime[i - 1] = dt.Hour * 3600 + dt.Minute * 60;
cbb = (ComboBox)tabPage1.Controls["cbbInNextDay" + i.ToString()];
if (cbb.SelectedIndex == 1)
{
InTime[i - 1] += DaySeconds;
}
if (!DateTime.TryParse(txtB.Text, out dt))
{
continue;
}
OutTime[i - 1] = dt.Hour * 3600 + dt.Minute * 60;
cbb = (ComboBox)tabPage1.Controls["cbbOutNextDay" + i.ToString()];
if (cbb.SelectedIndex == 1)
{
OutTime[i - 1] += DaySeconds;
}
if (InTime[i - 1] >= OutTime[i - 1])
{
txtB.Focus();
Pub.ShowErrorMsg(Pub.GetResText(formCode, "Error001", ""));
return;
}
chk = (CheckBox)tabPage1.Controls["chkInIsPressed" + i.ToString()];
InIsPressed[i - 1] = chk.Checked ? "Y" : "N";
chk = (CheckBox)tabPage1.Controls["chkOutIsPressed" + i.ToString()];
OutIsPressed[i - 1] = chk.Checked ? "Y" : "N";
txt = (TextBox)tabPage1.Controls["txtInBefore" + i.ToString()];
int.TryParse(txt.Text.Trim(), out InBefore[i - 1]);
InBefore[i - 1] *= 60;
txt = (TextBox)tabPage1.Controls["txtOutAfter" + i.ToString()];
int.TryParse(txt.Text.Trim(), out OutAfter[i - 1]);
OutAfter[i - 1] *= 60;
txt = (TextBox)tabPage1.Controls["txtInLater" + i.ToString()];
int.TryParse(txt.Text.Trim(), out InLater[i - 1]);
InLater[i - 1] *= 60;
txt = (TextBox)tabPage1.Controls["txtInMaxLater" + i.ToString()];
int.TryParse(txt.Text.Trim(), out InMaxLater[i - 1]);
InMaxLater[i - 1] *= 60;
txt = (TextBox)tabPage1.Controls["txtOutLeaveEarly" + i.ToString()];
int.TryParse(txt.Text.Trim(), out OutLeaveEarly[i - 1]);
OutLeaveEarly[i - 1] *= 60;
txt = (TextBox)tabPage1.Controls["txtOutMaxLeaveEarly" + i.ToString()];
int.TryParse(txt.Text.Trim(), out OutMaxLeaveEarly[i - 1]);
OutMaxLeaveEarly[i - 1] *= 60;
cbb = (ComboBox)tabPage1.Controls["cbbOtType" + i.ToString()];
OtTypeSysID[i - 1] = ((TCommonType)cbb.Items[cbb.SelectedIndex]).id;
if (OtTypeSysID[i - 1] == "")
{
ShiftNormalMin += OutTime[i - 1] - InTime[i - 1];
}
else
{
ShiftOTMin += OutTime[i - 1] - InTime[i - 1];
}
}
ShiftNormalMin = ShiftNormalMin / 60;
ShiftOTMin = ShiftOTMin / 60;
double ShiftNormalHrs = Convert.ToDouble(ShiftNormalMin) / 60;
string NormalRound = chkNormalRound.Checked ? "Y" : "N";
string OtRound = chkOtRound.Checked ? "Y" : "N";
string RoundFlag = rbRoundHalf.Checked ? "1" : "2";
string InBeforeOt = chkInBeforeOt.Checked ? "Y" : "N";
int InBeforeOtMin = 0;
int.TryParse(txtInBeforeOtMin.Text.Trim(), out InBeforeOtMin);
string OutAfterOt = chkOutAfterOt.Checked ? "Y" : "N";
int OutAfterOtMin = 0;
int.TryParse(txtOutAfterOtMin.Text.Trim(), out OutAfterOtMin);
int.TryParse(textBox1.Text.Trim(), out RestMin[0]);
int.TryParse(textBox2.Text.Trim(), out RestMin[1]);
int.TryParse(textBox3.Text.Trim(), out RestMin[2]);
int.TryParse(textBox4.Text.Trim(), out RestMin[3]);
for (int i = 1; i <= 5; i++)
{
chk = (CheckBox)tabPage2.Controls["chkISFu" + i.ToString()];
ISFu[i - 1] = chk.Checked ? "Y" : "N";
}
string[] vl = new string[84];
vl[1] = "'" + ShiftNo + "'";
vl[2] = "'" + ShiftName + "'";
vl[3] = ShiftNormalHrs.ToString();
vl[4] = ShiftNormalMin.ToString();
vl[5] = ShiftOTMin.ToString();
for (int i = 0; i < 5; i++)
{
if ((InTime[i] == 0) && OutTime[i] == 0)
{
vl[5 + i * 11 + 1] = "NULL";
vl[5 + i * 11 + 2] = "NULL";
vl[5 + i * 11 + 3] = "NULL";
vl[5 + i * 11 + 4] = "NULL";
vl[5 + i * 11 + 5] = "NULL";
vl[5 + i * 11 + 6] = "NULL";
vl[5 + i * 11 + 7] = "NULL";
vl[5 + i * 11 + 8] = "NULL";
vl[5 + i * 11 + 9] = "NULL";
vl[5 + i * 11 + 10] = "NULL";
vl[5 + i * 11 + 11] = "NULL";
}
else
{
vl[5 + i * 11 + 1] = InTime[i].ToString();
vl[5 + i * 11 + 2] = OutTime[i].ToString();
vl[5 + i * 11 + 3] = "'" + InIsPressed[i] + "'";
vl[5 + i * 11 + 4] = "'" + OutIsPressed[i] + "'";
vl[5 + i * 11 + 5] = InBefore[i].ToString();
vl[5 + i * 11 + 6] = OutAfter[i].ToString();
vl[5 + i * 11 + 7] = InLater[i].ToString();
vl[5 + i * 11 + 8] = InMaxLater[i].ToString();
vl[5 + i * 11 + 9] = OutLeaveEarly[i].ToString();
vl[5 + i * 11 + 10] = OutMaxLeaveEarly[i].ToString();
vl[5 + i * 11 + 11] = "'" + OtTypeSysID[i] + "'";
}
}
for (int i = 0; i < 4; i++)
{
vl[61 + i] = RestMin[i].ToString();
}
vl[65] = "NULL";
vl[66] = "NULL";
vl[67] = "'" + NormalRound + "'";
vl[68] = "'" + OtRound + "'";
vl[69] = "'" + RoundFlag + "'";
vl[70] = "'" + InBeforeOt + "'";
vl[71] = InBeforeOtMin.ToString();
vl[72] = "'" + OutAfterOt + "'";
vl[73] = OutAfterOtMin.ToString();
for (int i = 0; i < 5; i++)
{
vl[74 + i] = "'" + ISFu[i] + "'";
}
vl[79] = "0";
vl[80] = checkBox1.Checked ? "1" : "0";
vl[81] = checkBox2.Checked ? "1" : "0";
vl[82] = checkBox3.Checked ? "1" : "0";
vl[83] = checkBox4.Checked ? "1" : "0";
DataTableReader dr = null;
bool IsOk = true;
List <string> sql = new List <string>();
try
{
if (!db.IsOpen)
{
db.Open(SystemInfo.ConnStr);
}
if (SysID == "")
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_002003, new string[] { "5", ShiftNo }));
if (dr.Read())
{
IsOk = false;
txtNo.Focus();
ShowErrorCannotRepeated(label1.Text);
}
else
{
vl[0] = "1";
}
}
else
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_002003, new string[] { "6", SysID, ShiftNo }));
if (dr.Read())
{
IsOk = false;
txtNo.Focus();
ShowErrorCannotRepeated(label1.Text);
}
else
{
vl[0] = "2";
vl[79] = "'" + SysID + "'";
}
}
}
catch (Exception E)
{
IsOk = false;
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
if (!IsOk)
{
return;
}
sql.Add(Pub.GetSQL(DBCode.DB_002003, vl));
if (db.ExecSQL(sql) != 0)
{
IsOk = false;
}
if (IsOk)
{
db.WriteSYLog(this.Text, CurrentOprt, sql);
Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
private void btnOk_Click(object sender, EventArgs e)
{
int OprtNo = 0;
if (Pub.IsNumeric(txtNo.Text.Trim()))
{
OprtNo = Convert.ToInt32(txtNo.Text.Trim());
}
string OprtName = txtName.Text.Trim();
string Pass = txtPass.Text.Trim();
string PassA = txtPassA.Text.Trim();
DataTableReader dr = null;
bool IsOk = false;
string sql = "";
if (!Pub.CheckTextMaxLength(Label2.Text, txtName.Text, txtName.MaxLength))
{
return;
}
if ((OprtNo < 1) || (OprtNo > 20))
{
txtNo.Focus();
ShowErrorSelectCorrect(Label1.Text);
return;
}
if (OprtName == "")
{
txtName.Focus();
ShowErrorSelectCorrect(Label2.Text);
return;
}
if ((Pass == "") || (!Pub.IsNumeric(Pass)))
{
txtPass.Focus();
ShowErrorSelectCorrect(Label3.Text);
return;
}
if (Pass != PassA)
{
txtPass.Focus();
Pub.MessageBoxShow(Pub.GetResText(formCode, "ErrorPasswordTwo", ""));
return;
}
try
{
if (!db.IsOpen)
{
db.Open(SystemInfo.ConnStr);
}
if (SysID == "")
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_000004, new string[] { "5", OprtNo.ToString() }));
if (dr.Read())
{
txtNo.Focus();
ShowErrorCannotRepeated(Label1.Text);
}
else
{
sql = Pub.GetSQL(DBCode.DB_000004, new string[] { "1", OprtNo.ToString(), OprtName, Pass });
db.ExecSQL(sql);
IsOk = true;
}
}
else
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_000004, new string[] { "6", SysID, OprtNo.ToString() }));
if (dr.Read())
{
txtNo.Focus();
Pub.MessageBoxShow(Pub.GetResText(formCode, "Error005", ""));
}
else
{
sql = Pub.GetSQL(DBCode.DB_000004, new string[] { "2", OprtNo.ToString(), OprtName, Pass, SysID });
db.ExecSQL(sql);
IsOk = true;
}
}
}
catch (Exception E)
{
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
if (IsOk)
{
db.WriteSYLog(this.Text, CurrentOprt, sql);
Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
private void btnOk_Click(object sender, EventArgs e)
{
DataTableReader dr = null;
bool IsOk = false;
string sql = "";
string name = txtName.Text.Trim();
if (!Pub.CheckTextMaxLength(label2.Text, name, txtName.MaxLength))
{
txtName.Focus();
return;
}
string desc = txtDesc.Text.Trim();
if (!Pub.CheckTextMaxLength(label6.Text, desc, txtDesc.MaxLength))
{
txtDesc.Focus();
return;
}
string fee = CurrencyToStringEx(txtFee.Text);
string Stored = CurrencyToStringEx(txtStored.Text);
string DepositLimit = "0.00";
if (Convert.ToDecimal(fee) < 0)
{
txtFee.Focus();
Pub.ShowErrorMsg(Pub.GetResText(formCode, "Error001", ""));
return;
}
if ((Convert.ToDecimal(Stored) < 0) || (Convert.ToDecimal(Stored) > 1000))
{
txtStored.Focus();
Pub.ShowErrorMsg(Pub.GetResText(formCode, "Error002", ""));
return;
}
if (txtDepositLimit.Enabled)
{
DepositLimit = CurrencyToStringEx(txtDepositLimit.Text);
if (SystemInfo.AllowCheckDepositLimit == 1)
{
if ((Convert.ToDecimal(DepositLimit) < 0) || (Convert.ToDouble(DepositLimit) > SystemInfo.MaxDeposit))
{
txtDepositLimit.Focus();
Pub.ShowErrorMsg(Pub.GetResText(formCode, "Error004", ""));
return;
}
}
}
string CheckOrder = Convert.ToByte(chkCheckOrder.Checked).ToString();
string CardRetirement = Convert.ToByte(chkCardRetirement.Checked).ToString();
string CardRefundment = Convert.ToByte(chkCardRefundment.Checked).ToString();
string CardRefundmentDev = Convert.ToByte(chkCardRefundmentDev.Checked).ToString();
int Deposit = 0;
if (Pub.IsNumeric(txtDeposit.Text.Trim()))
{
Deposit = Convert.ToInt32(txtDeposit.Text.Trim());
}
if (Deposit < 0)
{
txtDeposit.Focus();
Pub.ShowErrorMsg(Pub.GetResText(formCode, "Error003", ""));
return;
}
int Refundment = 0;
if (txtRefundment.Enabled)
{
if (Pub.IsNumeric(txtRefundment.Text.Trim()))
{
Refundment = Convert.ToInt32(txtRefundment.Text.Trim());
}
if (Refundment < 0)
{
txtRefundment.Focus();
Pub.ShowErrorMsg(Pub.GetResText(formCode, "Error005", ""));
return;
}
}
int DepositTimes = 0;
if (txtDepositTimes.Enabled)
{
if (Pub.IsNumeric(txtRefundment.Text.Trim()))
{
DepositTimes = Convert.ToInt32(txtDepositTimes.Text.Trim());
}
if (DepositTimes < 0)
{
txtDepositTimes.Focus();
Pub.ShowErrorMsg(Pub.GetResText(formCode, "Error006", ""));
return;
}
}
try
{
sql = Pub.GetSQL(DBCode.DB_001001, new string[] { "1", name, fee, Stored, CheckOrder, CardRetirement,
CardRefundment, CardRefundmentDev, Deposit.ToString(), Refundment.ToString(), DepositLimit,
DepositTimes.ToString(), desc, SysID });
db.ExecSQL(sql);
IsOk = true;
}
catch (Exception E)
{
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
if (IsOk)
{
db.WriteSYLog(this.Text, CurrentOprt, sql);
Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
private void btnOk_Click(object sender, EventArgs e)
{
string OprtNo = txtOprtNo.Text.Trim();
string OprtName = txtOprtName.Text.Trim();
string Pass = txtOprtPWD.Text.Trim();
string PassA = txtOprtPWDA.Text.Trim();
string StartDay = dtpOprtStartDay.Value.ToString(SystemInfo.SQLDateFMT);
string EndDay = dtpOprtEndDay.Value.ToString(SystemInfo.SQLDateFMT);
string Desc = txtOprtDesc.Text.Trim();
string IsActive = "N";
DataTableReader dr = null;
bool IsOk = false;
string sql = "";
if (!Pub.CheckTextMaxLength(Label1.Text, txtOprtNo.Text, txtOprtNo.MaxLength))
{
return;
}
if (!Pub.CheckTextMaxLength(Label2.Text, txtOprtName.Text, txtOprtName.MaxLength))
{
return;
}
if (!Pub.CheckTextMaxLength(Label3.Text, txtOprtPWD.Text, txtOprtPWD.MaxLength))
{
return;
}
if (!Pub.CheckTextMaxLength(Label8.Text, txtOprtDesc.Text, txtOprtDesc.MaxLength))
{
return;
}
if (OprtNo == "")
{
txtOprtNo.Focus();
ShowErrorEnterCorrect(Label1.Text);
return;
}
if (Pub.GetTextLength(OprtNo) < 3)
{
txtOprtNo.Focus();
Pub.ShowErrorMsg(Pub.GetResText(formCode, "Error001", ""));
return;
}
if (OprtName == "")
{
txtOprtName.Focus();
ShowErrorEnterCorrect(Label2.Text);
return;
}
if (Pass != PassA)
{
txtOprtPWD.Focus();
Pub.ShowErrorMsg(Pub.GetResText(formCode, "ErrorPasswordTwo", ""));
return;
}
Pass = Pub.GetOprtEncrypt(Pass);
if (Pass == "")
{
Pass = Pub.GetOprtEncrypt("0");
}
if (chkActive.Checked)
{
IsActive = "Y";
}
try
{
if (!db.IsOpen)
{
db.Open(SystemInfo.ConnStr);
}
if (SysID == "")
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_000003, new string[] { "5", OprtNo }));
if (dr.Read())
{
txtOprtNo.Focus();
ShowErrorCannotRepeated(Label1.Text);
}
else
{
sql = Pub.GetSQL(DBCode.DB_000003, new string[] { "1", OprtNo, OprtName, Pass,
StartDay, EndDay, Desc, IsActive });
db.ExecSQL(sql);
IsOk = true;
}
}
else
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_000003, new string[] { "6", SysID, OprtNo }));
if (dr.Read())
{
txtOprtNo.Focus();
ShowErrorCannotRepeated(Label1.Text);
}
else
{
sql = Pub.GetSQL(DBCode.DB_000003, new string[] { "2", OprtNo, OprtName, Pass,
StartDay, EndDay, Desc, IsActive, SysID });
db.ExecSQL(sql);
IsOk = true;
}
}
}
catch (Exception E)
{
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
if (IsOk)
{
db.WriteSYLog(this.Text, CurrentOprt, sql);
Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
private void btnOk_Click(object sender, EventArgs e)
{
if (cbbID.SelectedIndex == -1)
{
if (cbbID.Enabled)
{
cbbID.Focus();
}
ShowErrorSelectCorrect(label1.Text);
return;
}
string ID = cbbID.Text;
string Name = txtName.Text.Trim();
if (!Pub.CheckTextMaxLength(label10.Text, Name, txtName.MaxLength))
{
txtName.Focus();
return;
}
string T1S = dtpS1.Text;
string T1E = dtpE1.Text;
string T2S = dtpS2.Text;
string T2E = dtpE2.Text;
string T3S = dtpS3.Text;
string T3E = dtpE3.Text;
string T4S = dtpS4.Text;
string T4E = dtpE4.Text;
string T5S = dtpS5.Text;
string T5E = dtpE5.Text;
string T6S = dtpS6.Text;
string T6E = dtpE6.Text;
DataTableReader dr = null;
bool IsOk = true;
string sql = "";
try
{
if (SysID != "")
{
ID = SysID;
}
dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000300, new string[] { "403", ID }));
if (dr.Read())
{
sql = Pub.GetSQL(DBCode.DB_000300, new string[] { "405", ID, Name, T1S, T1E, T2S, T2E, T3S, T3E,
T4S, T4E, T5S, T5E, T6S, T6E, OprtInfo.OprtNo });
}
else
{
sql = Pub.GetSQL(DBCode.DB_000300, new string[] { "404", ID, Name, T1S, T1E, T2S, T2E, T3S, T3E,
T4S, T4E, T5S, T5E, T6S, T6E, OprtInfo.OprtNo });
}
SystemInfo.db.ExecSQL(sql);
}
catch (Exception E)
{
IsOk = false;
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
if (!IsOk)
{
return;
}
SystemInfo.db.WriteSYLog(this.Text, CurrentOprt, sql);
//Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
private void btnOk_Click(object sender, EventArgs e)
{
if (!CheckEmp())
{
return;
}
if (dtpStart.Value > dtpEnd.Value)
{
dtpStart.Focus();
Pub.ShowErrorMsg(Pub.GetResText(formCode, "ErrorStartTimeBegreater", ""));
return;
}
if (cbbType.SelectedIndex == -1)
{
cbbType.Focus();
ShowErrorSelectCorrect(label7.Text);
return;
}
string BillNo = txtNo.Text;
string EmpSysID = txtEmpNo.Tag.ToString();
string TypeSysID = ((TCommonType)cbbType.Items[cbbType.SelectedIndex]).sysID;
string Reason = txtReason.Text.Trim();
if (!Pub.CheckTextMaxLength(label8.Text, Reason, txtReason.MaxLength))
{
return;
}
List <string> sql = new List <string>();
int days = (int)Pub.DateDiff(DateInterval.Day, dtpStart.Value.Date, dtpEnd.Value.Date);
DataTableReader dr = null;
bool IsError = false;
bool IsExists = true;
try
{
if (SysID == "")
{
while (IsExists)
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_002009, new string[] { "6", BillNo }));
if (!dr.Read())
{
IsExists = false;
}
dr.Close();
if (IsExists)
{
BillNo = GetBillNo();
}
}
GetSql(days, EmpSysID, BillNo, TypeSysID, Reason, ref sql);
if (cardGrid.DataSource != null)
{
DataTable dtGrid = (DataTable)cardGrid.DataSource;
for (int i = 0; i < dtGrid.Rows.Count; i++)
{
if (dtGrid.Rows[i]["EmpSysID"].ToString() == EmpSysID)
{
continue;
}
GetSql(days, dtGrid.Rows[i]["EmpSysID"].ToString(), BillNo, TypeSysID, Reason, ref sql);
}
}
}
else
{
GetSql(days, EmpSysID, BillNo, TypeSysID, Reason, ref sql);
}
}
catch (Exception E)
{
IsError = true;
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
if (IsError)
{
return;
}
if (db.ExecSQL(sql) != 0)
{
return;
}
db.WriteSYLog(this.Text, CurrentOprt, sql);
Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
private void btnOk_Click(object sender, EventArgs e)
{
string EmpNo = txtEmpNo.Text.Trim();
if (EmpNo == "" && cardGrid.DataSource == null)
{
txtEmpNo.Focus();
ShowErrorEnterCorrect(label2.Text);
return;
}
string DimissionOprt = txtDimissionOprt.Text.Trim();
if (DimissionOprt == "")
{
txtDimissionOprt.Focus();
ShowErrorEnterCorrect(label4.Text);
return;
}
string DimissionReason = txtDimissionReason.Text.Trim();
if (DimissionReason == "")
{
txtDimissionReason.Focus();
ShowErrorEnterCorrect(label8.Text);
return;
}
if (!Pub.CheckTextMaxLength(label8.Text, DimissionReason, txtDimissionReason.MaxLength))
{
return;
}
List <string> sql = new List <string>();
DataTableReader dr = null;
bool IsError = false;
try
{
if (SysID == "")
{
GetSql(EmpNo, DimissionOprt, DimissionReason, ref sql);
if (cardGrid.DataSource != null)
{
DataTable dtGrid = (DataTable)cardGrid.DataSource;
for (int i = 0; i < dtGrid.Rows.Count; i++)
{
if (dtGrid.Rows[i]["EmpNo"].ToString() == EmpNo)
{
continue;
}
GetSql(dtGrid.Rows[i]["EmpNo"].ToString(), DimissionOprt, DimissionReason, ref sql);
}
}
}
else
{
GetSql(EmpNo, DimissionOprt, DimissionReason, ref sql);
}
}
catch (Exception E)
{
IsError = true;
Pub.ShowErrorMsg(E, sql);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
if (IsError)
{
return;
}
if (SystemInfo.db.ExecSQL(sql) != 0)
{
return;
}
SystemInfo.db.WriteSYLog(this.Text, CurrentOprt, sql);
//Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
private void btnOk_Click(object sender, EventArgs e)
{
if (!Pub.IsNumeric(txtID.Text.Trim()))
{
txtID.Focus();
ShowErrorEnterCorrect(label1.Text);
return;
}
int id = 0;
int.TryParse(txtID.Text.Trim(), out id);
if ((id < 0) || (id > SystemInfo.MaxTimeNo))
{
txtID.Focus();
Pub.ShowErrorMsg(string.Format(Pub.GetResText(formCode, "Error101", ""), 0, SystemInfo.MaxTimeNo));
return;
}
string name = txtName.Text.Trim();
if (!Pub.CheckTextMaxLength(label10.Text, name, txtName.MaxLength))
{
return;
}
DateTime dt = new DateTime();
MaskedTextBox txt;
string[] timeGroup1Begin = new string[6];
string[] timeGroup1End = new string[6];
for (int i = 1; i <= 3; i++)
{
txt = (MaskedTextBox)groupBox1.Controls["txtBeginTime" + i.ToString()];
if (!DateTime.TryParse(txt.Text, out dt))
{
txt.Focus();
Pub.ShowErrorMsg(Pub.GetResText(formCode, "Error00" + i.ToString(), ""));
return;
}
timeGroup1Begin[i - 1] = txt.Text;
txt = (MaskedTextBox)groupBox1.Controls["txtEndTime" + i.ToString()];
if (!DateTime.TryParse(txt.Text, out dt))
{
txt.Focus();
Pub.ShowErrorMsg(Pub.GetResText(formCode, "Error00" + i.ToString(), ""));
return;
}
timeGroup1End[i - 1] = txt.Text;
}
for (int i = 4; i <= 6; i++)
{
txt = (MaskedTextBox)groupBox2.Controls["txtBeginTime" + i.ToString()];
if (!DateTime.TryParse(txt.Text, out dt))
{
txt.Focus();
Pub.ShowErrorMsg(Pub.GetResText(formCode, "Error00" + i.ToString(), ""));
return;
}
timeGroup1Begin[i - 1] = txt.Text;
txt = (MaskedTextBox)groupBox2.Controls["txtEndTime" + i.ToString()];
if (!DateTime.TryParse(txt.Text, out dt))
{
txt.Focus();
Pub.ShowErrorMsg(Pub.GetResText(formCode, "Error00" + i.ToString(), ""));
return;
}
timeGroup1End[i - 1] = txt.Text;
}
if (cbbInType1.SelectedIndex < 0)
{
ShowErrorSelectCorrect(label5.Text);
return;
}
string InType1 = ((TCommonType)cbbInType1.Items[cbbInType1.SelectedIndex]).id;
if (cbbInType2.SelectedIndex < 0)
{
ShowErrorSelectCorrect(label6.Text);
return;
}
string InType2 = ((TCommonType)cbbInType2.Items[cbbInType2.SelectedIndex]).id;
int WeekIndex = Convert.ToByte(checkBox2.Checked) * 64;
WeekIndex += Convert.ToByte(checkBox3.Checked) * 32;
WeekIndex += Convert.ToByte(checkBox4.Checked) * 16;
WeekIndex += Convert.ToByte(checkBox5.Checked) * 8;
WeekIndex += Convert.ToByte(checkBox6.Checked) * 4;
WeekIndex += Convert.ToByte(checkBox7.Checked) * 2;
WeekIndex += Convert.ToByte(checkBox1.Checked) * 1;
int TimeLimit = 0;
if (rbLimitOne.Checked)
{
TimeLimit = 1;
}
DataTableReader dr = null;
bool IsOk = false;
string sql = "";
try
{
if (SysID == "")
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003003, new string[] { "4", id.ToString() }));
if (dr.Read())
{
txtID.Focus();
ShowErrorCannotRepeated(label1.Text);
}
else
{
sql = Pub.GetSQL(DBCode.DB_003003, new string[] { "1", id.ToString(), name, timeGroup1Begin[0], timeGroup1End[0],
timeGroup1Begin[1], timeGroup1End[1], timeGroup1Begin[2], timeGroup1End[2], InType1, timeGroup1Begin[3],
timeGroup1End[3], timeGroup1Begin[4], timeGroup1End[4], timeGroup1Begin[5], timeGroup1End[5], InType2,
WeekIndex.ToString(), TimeLimit.ToString() });
db.ExecSQL(sql);
IsOk = true;
}
}
else
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003003, new string[] { "5", SysID, id.ToString() }));
if (dr.Read())
{
txtID.Focus();
ShowErrorCannotRepeated(label1.Text);
}
else
{
sql = Pub.GetSQL(DBCode.DB_003003, new string[] { "2", id.ToString(), name, timeGroup1Begin[0], timeGroup1End[0],
timeGroup1Begin[1], timeGroup1End[1], timeGroup1Begin[2], timeGroup1End[2], InType1, timeGroup1Begin[3],
timeGroup1End[3], timeGroup1Begin[4], timeGroup1End[4], timeGroup1Begin[5], timeGroup1End[5], InType2,
WeekIndex.ToString(), TimeLimit.ToString(), SysID });
db.ExecSQL(sql);
IsOk = true;
}
}
}
catch (Exception E)
{
Pub.ShowErrorMsg(E, sql);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
if (IsOk)
{
db.WriteSYLog(this.Text, CurrentOprt, sql);
Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
private void btnOk_Click(object sender, EventArgs e)
{
if (!Pub.IsNumeric(txtID.Text.Trim()))
{
txtID.Focus();
ShowErrorEnterCorrect(label1.Text);
return;
}
int id = 0;
int.TryParse(txtID.Text.Trim(), out id);
if ((id < 0) || (id > SystemInfo.MaxTimeNo))
{
txtID.Focus();
Pub.ShowErrorMsg(string.Format(Pub.GetResText(formCode, "Error101", ""), 0, SystemInfo.MaxTimeNoNew));
return;
}
string name = txtName.Text.Trim();
if (!Pub.CheckTextMaxLength(label10.Text, name, txtName.MaxLength))
{
return;
}
int v = 0;
DateTime dt = new DateTime();
TextBox txt;
MaskedTextBox mtxt;
ComboBox cbb;
string[] Times = new string[6];
string[] timeBegin = new string[6];
string[] timeEnd = new string[6];
string[] Mode = new string[6];
for (int i = 1; i <= 6; i++)
{
txt = (TextBox)groupBox1.Controls["txtTime" + i.ToString()];
if (!int.TryParse(txt.Text, out v) || v < 0 || v > 255)
{
txt.Focus();
Pub.ShowErrorMsg(label2.Text + string.Format(Pub.GetResText(formCode, "ErrorTimes", ""), 0, 255));
return;
}
Times[i - 1] = v.ToString();
mtxt = (MaskedTextBox)groupBox1.Controls["txtBegin" + i.ToString()];
if (!DateTime.TryParse(mtxt.Text, out dt))
{
mtxt.Focus();
Pub.ShowErrorMsg(label4.Text + Pub.GetResText(formCode, "ErrorTime", ""));
return;
}
timeBegin[i - 1] = mtxt.Text;
mtxt = (MaskedTextBox)groupBox1.Controls["txtEnd" + i.ToString()];
if (!DateTime.TryParse(mtxt.Text, out dt))
{
mtxt.Focus();
Pub.ShowErrorMsg(label5.Text + Pub.GetResText(formCode, "ErrorTime", ""));
return;
}
timeEnd[i - 1] = mtxt.Text;
cbb = (ComboBox)groupBox1.Controls["cbbMode" + i.ToString()];
if (cbb.SelectedIndex < 0)
{
ShowErrorSelectCorrect(label13.Text);
return;
}
Mode[i - 1] = ((TCommonType)cbb.Items[cbb.SelectedIndex]).id;
}
DataTableReader dr = null;
bool IsOk = false;
string sql = "";
try
{
if (SysID == "")
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003003, new string[] { "4", id.ToString() }));
if (dr.Read())
{
txtID.Focus();
ShowErrorCannotRepeated(label1.Text);
}
else
{
sql = Pub.GetSQL(DBCode.DB_003003, new string[] { "2000", id.ToString(), name, Times[0], timeBegin[0], timeEnd[0], Mode[0],
Times[1], timeBegin[1], timeEnd[1], Mode[1], Times[2], timeBegin[2], timeEnd[2], Mode[2], Times[3], timeBegin[3],
timeEnd[3], Mode[3], Times[4], timeBegin[4], timeEnd[4], Mode[4], Times[5], timeBegin[5], timeEnd[5], Mode[5] });
db.ExecSQL(sql);
IsOk = true;
}
}
else
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003003, new string[] { "5", SysID, id.ToString() }));
if (dr.Read())
{
txtID.Focus();
ShowErrorCannotRepeated(label1.Text);
}
else
{
sql = Pub.GetSQL(DBCode.DB_003003, new string[] { "2001", id.ToString(), name, Times[0], timeBegin[0], timeEnd[0], Mode[0],
Times[1], timeBegin[1], timeEnd[1], Mode[1], Times[2], timeBegin[2], timeEnd[2], Mode[2], Times[3], timeBegin[3],
timeEnd[3], Mode[3], Times[4], timeBegin[4], timeEnd[4], Mode[4], Times[5], timeBegin[5], timeEnd[5], Mode[5], SysID });
db.ExecSQL(sql);
IsOk = true;
}
}
}
catch (Exception E)
{
Pub.ShowErrorMsg(E, sql);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
if (IsOk)
{
db.WriteSYLog(this.Text, CurrentOprt, sql);
Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
private void btnOk_Click(object sender, EventArgs e)
{
int TypeID = 0;
if (Pub.IsNumeric(txtNo.Text.Trim()))
{
TypeID = Convert.ToInt32(txtNo.Text.Trim());
}
string TypeName = txtName.Text.Trim();
DataTableReader dr = null;
bool IsOk = true;
string sql = "";
if (!Pub.CheckTextMaxLength(Label2.Text, TypeName, txtName.MaxLength))
{
return;
}
if ((TypeID < 200) || (TypeID > 209))
{
txtNo.Focus();
ShowErrorEnterCorrect(Label1.Text);
return;
}
if (TypeName == "")
{
txtName.Focus();
ShowErrorEnterCorrect(Label2.Text);
return;
}
try
{
if (!db.IsOpen)
{
db.Open(SystemInfo.ConnStr);
}
if (SysID == "")
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004014, new string[] { "5", TypeID.ToString() }));
if (dr.Read())
{
if (txtNo.Enabled)
{
txtNo.Focus();
}
ShowErrorCannotRepeated(Label1.Text);
}
else
{
sql = Pub.GetSQL(DBCode.DB_004014, new string[] { "1", TypeID.ToString(), TypeName });
db.ExecSQL(sql);
}
}
else
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004014, new string[] { "6", SysID, TypeID.ToString() }));
if (dr.Read())
{
txtNo.Focus();
ShowErrorCannotRepeated(Label1.Text);
}
else
{
sql = Pub.GetSQL(DBCode.DB_004014, new string[] { "2", TypeID.ToString(), TypeName, SysID });
db.ExecSQL(sql);
}
}
}
catch (Exception E)
{
IsOk = false;
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
if (!IsOk)
{
return;
}
db.WriteSYLog(this.Text, CurrentOprt, sql);
Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
private void btnOk_Click(object sender, EventArgs e)
{
if (!CheckEmp())
{
return;
}
if (dtpStart.Value > dtpEnd.Value)
{
dtpStart.Focus();
Pub.MessageBoxShow(Pub.GetResText(formCode, "ErrorStartTimeBegreater", ""));
return;
}
if (cbbSort.SelectedIndex == -1)
{
cbbSort.Focus();
ShowErrorSelectCorrect(label1.Text);
return;
}
string EmpNo = txtEmpNo.Text.Trim();
string SortID = ((TIDAndName)cbbSort.Items[cbbSort.SelectedIndex]).id;
string Reason = txtReason.Text.Trim();
if (!Pub.CheckTextMaxLength(label8.Text, Reason, txtReason.MaxLength))
{
return;
}
List <string> sql = new List <string>();
DataTableReader dr = null;
bool IsError = false;
try
{
if (SysID == "")
{
if (EmpNo != "")
{
GetSql(EmpNo, SortID, Reason, ref sql);
}
if (cardGrid.DataSource != null)
{
DataTable dtGrid = (DataTable)cardGrid.DataSource;
for (int i = 0; i < dtGrid.Rows.Count; i++)
{
if (dtGrid.Rows[i]["EmpNo"].ToString() == EmpNo)
{
continue;
}
GetSql(dtGrid.Rows[i]["EmpNo"].ToString(), SortID, Reason, ref sql);
}
}
}
else
{
GetSql(EmpNo, SortID, Reason, ref sql);
}
}
catch (Exception E)
{
IsError = true;
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
if (IsError)
{
return;
}
if (SystemInfo.db.ExecSQL(sql) != 0)
{
return;
}
SystemInfo.db.WriteSYLog(this.Text, CurrentOprt, sql);
//Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
private void ItemSave_Click(object sender, EventArgs e)
{
string ID = txtGroupNo.Text.Trim();
string Name = txtGroupName.Text.Trim();
string Desc = txtRemarks.Text.Trim();
if (ID == "")
{
txtGroupNo.Focus();
ShowErrorEnterCorrect(lbGroupNo.Text);
return;
}
if (!Pub.CheckTextMaxLength(lbGroupNo.Text, ID, txtGroupNo.MaxLength))
{
txtGroupNo.Focus();
return;
}
if (Name == "")
{
txtGroupName.Focus();
ShowErrorEnterCorrect(lbGroupName.Text);
return;
}
if (!Pub.CheckTextMaxLength(lbGroupName.Text, Name, txtGroupName.MaxLength))
{
txtGroupName.Focus();
return;
}
if (!Pub.CheckTextMaxLength(lbRemarks.Text, Desc, txtRemarks.MaxLength))
{
txtRemarks.Focus();
return;
}
DataTableReader dr = null;
bool IsOk = false;
List <string> sql = new List <string>();
try
{
if (SysID == "")
{
dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000300, new string[] { "31", ID }));
if (dr.Read())
{
txtGroupNo.Focus();
ShowErrorCannotRepeated(lbGroupNo.Text);
}
else
{
sql.Add(Pub.GetSQL(DBCode.DB_000300, new string[] { "34", ID, Name, DevGroupUpID, Desc }));
IsOk = true;
}
}
else
{
dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000300, new string[] { "35", SysID, ID }));
if (dr.Read())
{
txtGroupNo.Focus();
ShowErrorCannotRepeated(lbGroupNo.Text);
}
else
{
sql.Add(Pub.GetSQL(DBCode.DB_000300, new string[] { "36", ID, Name, DevGroupUpID, Desc, SysID }));
sql.Add(Pub.GetSQL(DBCode.DB_000300, new string[] { "40", ID, SysID }));
dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000300, new string[] { "38", SysID }));
if (dr.Read())
{
sql.Add(Pub.GetSQL(DBCode.DB_000300, new string[] { "37", ID, Name, SysID }));
}
IsOk = true;
}
}
}
catch (Exception E)
{
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
if (IsOk)
{
if (SystemInfo.db.ExecSQL(sql) != 0)
{
return;
}
SystemInfo.db.WriteSYLog(this.Text, currentTool, sql);
//Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information);
//this.DialogResult = DialogResult.OK;
//this.Close();
InitDevGroupTreeView(tvEmp, InitEmp, otherCoin);
//int depth = getDepth(tvEmp.Nodes[0]);
// if (depth > 4)
// {
// SystemInfo.db.ExecSQL(Pub.GetSQL(DBCode.DB_000001, new string[] { "29", ID }));
// InitDevGroupTreeView(tvEmp, InitEmp, otherCoin);
// Pub.MessageBoxShow(Pub.GetResText(formCode, "Error002", ""));
// }
// else
{
for (int i = 0; i < tvEmp.Nodes.Count; i++)
{
SelectNodes(ID, tvEmp.Nodes[i]);
}
}
ItemStatus(false);
}
}
private void btnOk_Click(object sender, EventArgs e)
{
if (!Pub.IsNumeric(txtID.Text.Trim()))
{
txtID.Focus();
ShowErrorEnterCorrect(label1.Text);
return;
}
int id = 0;
int.TryParse(txtID.Text.Trim(), out id);
if ((id < 0) || (id > SystemInfo.MaxTimeNo))
{
txtID.Focus();
Pub.ShowErrorMsg(string.Format(Pub.GetResText(formCode, "Error101", ""), 0, SystemInfo.MaxTimeNo));
return;
}
string name = txtName.Text.Trim();
if (!Pub.CheckTextMaxLength(label2.Text, name, txtName.MaxLength))
{
return;
}
if (cbbSun.SelectedIndex < 0)
{
ShowErrorSelectCorrect(label3.Text);
return;
}
if (cbbMon.SelectedIndex < 0)
{
ShowErrorSelectCorrect(label4.Text);
return;
}
if (cbbTue.SelectedIndex < 0)
{
ShowErrorSelectCorrect(label5.Text);
return;
}
if (cbbWed.SelectedIndex < 0)
{
ShowErrorSelectCorrect(label6.Text);
return;
}
if (cbbThu.SelectedIndex < 0)
{
ShowErrorSelectCorrect(label7.Text);
return;
}
if (cbbFri.SelectedIndex < 0)
{
ShowErrorSelectCorrect(label8.Text);
return;
}
if (cbbSat.SelectedIndex < 0)
{
ShowErrorSelectCorrect(label9.Text);
return;
}
string SunID = ((TCommonType)cbbSun.Items[cbbSun.SelectedIndex]).id;
string MonID = ((TCommonType)cbbMon.Items[cbbMon.SelectedIndex]).id;
string TueID = ((TCommonType)cbbTue.Items[cbbTue.SelectedIndex]).id;
string WedID = ((TCommonType)cbbWed.Items[cbbWed.SelectedIndex]).id;
string ThuID = ((TCommonType)cbbThu.Items[cbbThu.SelectedIndex]).id;
string FriID = ((TCommonType)cbbFri.Items[cbbFri.SelectedIndex]).id;
string SatID = ((TCommonType)cbbSat.Items[cbbSat.SelectedIndex]).id;
DataTableReader dr = null;
bool IsOk = false;
string sql = "";
try
{
if (SysID == "")
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003003, new string[] { "1004", id.ToString() }));
if (dr.Read())
{
txtID.Focus();
ShowErrorCannotRepeated(label1.Text);
}
else
{
sql = Pub.GetSQL(DBCode.DB_003003, new string[] { "1011", id.ToString(), name, SunID, MonID, TueID,
WedID, ThuID, FriID, SatID, Convert.ToByte(chkHoliday.Checked).ToString() });
db.ExecSQL(sql);
IsOk = true;
}
}
else
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003003, new string[] { "1005", SysID, id.ToString() }));
if (dr.Read())
{
txtID.Focus();
ShowErrorCannotRepeated(label1.Text);
}
else
{
sql = Pub.GetSQL(DBCode.DB_003003, new string[] { "1012", id.ToString(), name, SunID, MonID, TueID,
WedID, ThuID, FriID, SatID, Convert.ToByte(chkHoliday.Checked).ToString(), SysID });
db.ExecSQL(sql);
IsOk = true;
}
}
}
catch (Exception E)
{
Pub.ShowErrorMsg(E, sql);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
if (IsOk)
{
db.WriteSYLog(this.Text, CurrentOprt, sql);
Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
private void btnOk_Click(object sender, EventArgs e)
{
string name = txtName.Text.Trim();
if (name == "")
{
txtName.Focus();
ShowErrorEnterCorrect(label1.Text);
return;
}
if (!Pub.CheckTextMaxLength(label1.Text, name, txtName.MaxLength))
{
txtName.Focus();
return;
}
if (picMap.Image == null)
{
Pub.ShowErrorMsg(Pub.GetResText(formCode, "Error001", ""));
return;
}
DataTableReader dr = null;
bool IsOk = true;
List <string> sql = new List <string>();
try
{
if (!db.IsOpen)
{
db.Open(SystemInfo.ConnStr);
}
if (IsAdd)
{
if (!db.GetServerGUID(ref SysID))
{
return;
}
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003007, new string[] { "2", name }));
if (dr.Read())
{
txtName.Focus();
ShowErrorCannotRepeated(label1.Text);
IsOk = false;
}
sql.Add(Pub.GetSQL(DBCode.DB_003007, new string[] { "4", SysID, name }));
}
else
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003007, new string[] { "3", SysID, name }));
if (dr.Read())
{
txtName.Focus();
ShowErrorCannotRepeated(label1.Text);
IsOk = false;
}
sql.Add(Pub.GetSQL(DBCode.DB_003007, new string[] { "5", SysID, name }));
}
if (IsOk)
{
sql.Add(Pub.GetSQL(DBCode.DB_003007, new string[] { "9", SysID }));
for (int j = 0; j < picMap.Controls.Count; j++)
{
doorInfo = (TMapDoorInfo)picMap.Controls[j].Tag;
sql.Add(Pub.GetSQL(DBCode.DB_003007, new string[] { "10", SysID, doorInfo.DoorSysID,
picMap.Controls[j].Location.X.ToString(), picMap.Controls[j].Location.Y.ToString() }));
}
if (db.ExecSQL(sql) != 0)
{
IsOk = false;
}
}
if (IsOk)
{
byte[] buff = new byte[0];
MemoryStream ms = new MemoryStream();
Bitmap t = new Bitmap(picMap.Image);
t.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
buff = ms.ToArray();
db.UpdateByteData(Pub.GetSQL(DBCode.DB_003007, new string[] { "6", SysID }), "mapPic", buff);
}
}
catch (Exception E)
{
IsOk = false;
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
if (IsOk)
{
db.WriteSYLog(this.Text, CurrentOprt, sql);
Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
private void btnOk_Click(object sender, EventArgs e)
{
string DayoffNo = txtNo.Text.Trim();
string DayoffName = txtName.Text.Trim();
string IsGS = "N";
if (chkGS.Checked)
{
IsGS = "Y";
}
if (!Pub.CheckTextMaxLength(label1.Text, DayoffNo, txtNo.MaxLength))
{
return;
}
if (!Pub.CheckTextMaxLength(label2.Text, DayoffName, txtName.MaxLength))
{
return;
}
if (DayoffNo == "")
{
txtNo.Focus();
ShowErrorEnterCorrect(label1.Text);
return;
}
if (DayoffName == "")
{
txtName.Focus();
ShowErrorEnterCorrect(label2.Text);
return;
}
DataTableReader dr = null;
bool IsOk = true;
List <string> sql = new List <string>();
try
{
if (!db.IsOpen)
{
db.Open(SystemInfo.ConnStr);
}
if (SysID == "")
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_002002, new string[] { "105", DayoffNo }));
if (dr.Read())
{
IsOk = false;
txtNo.Focus();
ShowErrorCannotRepeated(label1.Text);
}
else
{
sql.Add(Pub.GetSQL(DBCode.DB_002002, new string[] { "101", DayoffNo, DayoffName, IsGS }));
}
}
else
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_002002, new string[] { "106", SysID, DayoffNo }));
if (dr.Read())
{
IsOk = false;
txtNo.Focus();
ShowErrorCannotRepeated(label1.Text);
}
else
{
sql.Add(Pub.GetSQL(DBCode.DB_002002, new string[] { "102", DayoffNo, DayoffName, IsGS, SysID }));
}
}
}
catch (Exception E)
{
IsOk = false;
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
if (!IsOk)
{
return;
}
if (db.ExecSQL(sql) != 0)
{
IsOk = false;
}
if (IsOk)
{
db.WriteSYLog(this.Text, CurrentOprt, sql);
Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
private void btnOk_Click(object sender, EventArgs e)
{
string ID = txtID.Text.Trim();
string Name = txtName.Text.Trim();
if (txtID.Enabled)
{
if (ID == "")
{
txtID.Focus();
ShowErrorEnterCorrect(label1.Text);
return;
}
if (!Pub.CheckTextMaxLength(label1.Text, ID, txtID.MaxLength))
{
txtID.Focus();
return;
}
}
if (Name == "")
{
txtName.Focus();
ShowErrorEnterCorrect(label2.Text);
return;
}
if (!Pub.CheckTextMaxLength(label2.Text, Name, txtName.MaxLength))
{
txtName.Focus();
return;
}
DataTableReader dr = null;
bool IsOk = false;
string sql = "";
try
{
if (!db.IsOpen)
{
db.Open(SystemInfo.ConnStr);
}
if (SysID == "")
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004001, new string[] { "2", ID }));
if (dr.Read())
{
txtID.Focus();
ShowErrorCannotRepeated(label1.Text);
}
else
{
sql = Pub.GetSQL(DBCode.DB_004001, new string[] { "6", ID, Name, ParentAddressGUID });
db.ExecSQL(sql);
IsOk = true;
}
}
else
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004001, new string[] { "5", SysID, ID }));
if (dr.Read())
{
txtID.Focus();
ShowErrorCannotRepeated(label1.Text);
}
else
{
sql = Pub.GetSQL(DBCode.DB_004001, new string[] { "7", ID, Name, ParentAddressGUID, SysID });
db.ExecSQL(sql);
IsOk = true;
}
}
}
catch (Exception E)
{
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
if (IsOk)
{
db.WriteSYLog(this.Text, CurrentOprt, sql);
Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
private void WriteCard()
{
if (!IsReadCard)
{
Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgCardReadFirst", ""));
return;
}
string EmpNo = txtEmpNo.Text.Trim();
string EmpName = txtEmpName.Text.Trim();
int CardTypeID = ((TCardType)cbbCardType.Items[cbbCardType.SelectedIndex]).id;
string CardSectorNo = txtCardSectorNo.Text.Trim();
DateTime CardStartDate = new DateTime();
DateTime CardEndDate = new DateTime();
string CardPWD = txtCardPWD.Text.Trim();
string CardPWDA = txtCardPWDA.Text.Trim();
if (EmpNo == "")
{
txtEmpNo.Focus();
ShowErrorEnterCorrect(label1.Text);
return;
}
if (!Pub.CheckTextMaxLength(label1.Text, EmpNo, txtEmpNo.MaxLength))
{
txtEmpNo.Focus();
return;
}
if (!Pub.CheckTextMaxLength(label2.Text, EmpName, txtEmpName.MaxLength))
{
txtEmpName.Focus();
return;
}
if (CardPWD == "")
{
CardPWD = "000000";
}
if (!Pub.IsNumeric(CardPWD))
{
txtCardPWD.Focus();
ShowErrorEnterCorrect(label16.Text);
return;
}
if (!Pub.CheckTextMaxLength(label16.Text, CardPWD, txtCardPWD.MaxLength))
{
txtCardPWD.Focus();
return;
}
CardPWD = Convert.ToInt32(CardPWD).ToString("000000");
if (CardPWD != CardPWDA)
{
Pub.MessageBoxShow(Pub.GetResText(formCode, "ErrorPasswordTwo", ""));
return;
}
if ((txtCardStartDate.Text.Trim() == "") || (!DateTime.TryParse(txtCardStartDate.Text.Trim(), out CardStartDate)))
{
txtCardStartDate.Focus();
ShowErrorEnterCorrect(label13.Text);
return;
}
if ((txtCardEndDate.Text.Trim() == "") || (!DateTime.TryParse(txtCardEndDate.Text.Trim(), out CardEndDate)))
{
txtCardEndDate.Focus();
ShowErrorEnterCorrect(label14.Text);
return;
}
DataTableReader dr = null;
bool IsOk = true;
try
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_001003, new string[] { "4", SysID, EmpNo }));
if (dr.Read())
{
txtEmpNo.Focus();
ShowErrorCannotRepeated(label1.Text);
IsOk = false;
}
}
catch (Exception E)
{
IsOk = false;
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
if (!IsOk)
{
return;
}
pubData.EmpNo = EmpNo;
pubData.EmpName = EmpName;
pubData.CardNo = CardSectorNo;
pubData.CardTypeID = Convert.ToByte(CardTypeID);
pubData.CardPWD = CardPWD;
pubData.CardBeginDate = CardStartDate;
pubData.CardEndDate = CardEndDate;
pubData.IsCheckOrder = Convert.ToByte(CardCheckOrder);
int cardRet = 0;
string CardNo10 = "";
string CardNoH = "";
string CardNo8 = "";
string msg = "[" + EmpNo + "]" + EmpName + ": " + CardSectorNo + "/" + txtDepartName.Text;
ContinuePub:
Application.DoEvents();
CardNo10 = "";
CardNoH = "";
CardNo8 = "";
if (!DeviceObject.objCPIC.GetCardData(ref CardNo10, ref CardNoH, ref CardNo8))
{
if (Pub.MessageBoxShowQuestion(Pub.GetResText(formCode, "ReadCardError3", "") + "\r\n\r\n" +
Pub.GetResText(formCode, "MsgContinue", "")))
{
return;
}
else
{
goto ContinuePub;
}
}
if (CardNo10 != CardData10)
{
if (OkContinue)
{
Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgCardSame", "") + "\r\n\r\n" +
Pub.GetResText(formCode, "MsgCardOkContinue", ""));
goto ContinuePub;
}
else
{
if (OkContinue)
{
Pub.MessageBoxShow(Pub.GetCardMsg(cardRet) + "\r\n\r\n" + Pub.GetResText(formCode, "MsgCardOkContinue", ""));
goto ContinuePub;
}
else
{
if (Pub.MessageBoxShowQuestion(Pub.GetResText(formCode, "MsgCardSame", "")))
{
return;
}
else
{
goto ContinuePub;
}
}
}
}
cardRet = Pub.WriteCardInfo(pubData);
if (cardRet != 0)
{
if (Pub.MessageBoxShowQuestion(Pub.GetCardMsg(cardRet) + Pub.GetResText(formCode, "MsgContinue", "")))
{
return;
}
else
{
goto ContinuePub;
}
}
ContinueData:
Application.DoEvents();
if (!db.EmpCardModify(this.Text, oprt, CardSectorNo, CardTypeID, CardPWD, Convert.ToDateTime(CardStartDate),
Convert.ToDateTime(CardEndDate), EmpNo, EmpName))
{
if (Pub.MessageBoxShowQuestion(Pub.GetResText(formCode, "ErrorCardDB", "")))
{
Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgCardModifyFailed", ""));
return;
}
else
{
goto ContinueData;
}
}
IsChgOk = true;
Pub.CardBuzzer();
db.WriteSYLog(this.Text, oprt, msg);
db.UpdateEmpRegisterData(SysID, 10, CardPWD);
Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgCardModifySuccess", ""), MessageBoxIcon.Information);
IsReadCard = false;
ResetForm();
}
private void btnOk_Click(object sender, EventArgs e)
{
string T0 = txtTitle0.Text;
string T1 = txtTitle1.Text;
string T2 = txtTitle2.Text;
string T3 = txtTitle3.Text;
string T4 = txtTitle4.Text;
int I0 = cbbOption0.SelectedIndex;
int I1 = cbbOption1.SelectedIndex;
int I2 = cbbOption2.SelectedIndex;
int I3 = cbbOption3.SelectedIndex;
int I4 = cbbOption4.SelectedIndex;
if (!Pub.CheckTextMaxLength(label1.Text, T0, txtTitle0.MaxLength))
{
return;
}
if (!Pub.CheckTextMaxLength(label2.Text, T1, txtTitle1.MaxLength))
{
return;
}
if (!Pub.CheckTextMaxLength(label3.Text, T2, txtTitle2.MaxLength))
{
return;
}
if (!Pub.CheckTextMaxLength(label4.Text, T3, txtTitle3.MaxLength))
{
return;
}
if (!Pub.CheckTextMaxLength(label5.Text, T4, txtTitle4.MaxLength))
{
return;
}
int PrintLine = 0;
int.TryParse(txtLine.Text.Trim(), out PrintLine);
if ((PrintLine < 0) || (PrintLine > 255))
{
string msg = string.Format(Pub.GetResText(formCode, "Error001", ""), 0, 255);
Pub.ShowErrorMsg(msg);
return;
}
string printStr = T0 + "@" + T1 + "@" + T2 + "@" + T3 + "@" + T4 + "@" + I0.ToString() + "@" + I1.ToString() +
"@" + I2.ToString() + "@" + I3.ToString() + "@" + I4.ToString() + "@" + PrintLine.ToString();
string sql = Pub.GetSQL(DBCode.DB_004004, new string[] { "120", printStr, SysID });
try
{
db.ExecSQL(sql);
byte[] buff = new byte[0];
if (picLogo.BackgroundImage != null)
{
MemoryStream ms = new MemoryStream();
picLogo.BackgroundImage.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp);
buff = ms.ToArray();
}
db.UpdateByteData(Pub.GetSQL(DBCode.DB_004004, new string[] { "122", SysID }), "PrintLogo", buff);
}
catch (Exception E)
{
Pub.ShowErrorMsg(E, sql);
return;
}
db.WriteSYLog(this.Text, CurrentOprt, sql);
Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
private bool CheckValue()
{
if (!Pub.CheckTextMaxLength(lblMacSN.Text, txtMacSN.Text, txtMacSN.MaxLength))
{
txtMacSN.Focus();
return(false);
}
if ((txtMacSN.Text == "") || !Pub.IsNumeric(txtMacSN.Text))
{
txtMacSN.Focus();
ShowErrorEnterCorrect(lblMacSN.Text);
return(false);
}
MacSN = txtMacSN.Text.Trim();
if (MacSN.Length != 7)
{
txtMacSN.Focus();
ShowErrorEnterCorrect(lblMacSN.Text);
return(false);
}
MacDoorType = Convert.ToByte(MacSN.Substring(1, 1));
if ((MacDoorType != 1) && (MacDoorType != 2) && (MacDoorType != 4))
{
txtMacSN.Focus();
ShowErrorEnterCorrect(lblMacSN.Text);
return(false);
}
MacConnType = MacConnTypeString.USB;
MacIPAddress = "";
MacPort = "";
MacConnPWD = "";
MacDesc = "";
if (rbComm.Checked)
{
MacConnType = MacConnTypeString.Comm;
MacPort = cbbCommPort.Text;
MacConnPWD = "19200";
if (MacPort == "")
{
ShowErrorSelectCorrect(lblCommPort.Text);
return(false);
}
}
else if (rbLAN.Checked)
{
MacConnType = MacConnTypeString.LAN;
MacIPAddress = txtLANIP.Text.Trim();
MacPort = txtLANPort.Text.Trim();
if (MacIPAddress == "")
{
txtLANIP.Focus();
Pub.ShowErrorMsg(Pub.GetResText(formCode, "ErrorMacIP", ""));
return(false);
}
if (!Pub.CheckTextMaxLength(lblLANIP.Text, MacIPAddress, txtLANIP.MaxLength))
{
txtLANIP.Focus();
return(false);
}
if (!Pub.IsNumeric(MacPort))
{
txtLANPort.Focus();
Pub.ShowErrorMsg(Pub.GetResText(formCode, "ErrorMacPort", ""));
return(false);
}
}
MacDesc = txtDesc.Text.Trim();
if (!Pub.CheckTextMaxLength(label1.Text, MacDesc, txtDesc.MaxLength))
{
txtDesc.Focus();
return(false);
}
return(true);
}
private bool CheckValue()
{
if (cbbMacType.Text == "")
{
MacSeriesTypeId = 0;
MacSeriesTypeName = "";
}
else
{
if (cbbMacType.Items.Count > 0)
{
MacSeriesTypeId = ((MacType)cbbMacType.SelectedItem).id;
MacSeriesTypeName = ((MacType)cbbMacType.SelectedItem).name;
}
else
{
MacSeriesTypeId = 0;
MacSeriesTypeName = "";
}
}
if (txtMacSN.Text.Trim() == "")
{
txtMacSN.Focus();
ShowErrorEnterCorrect(lblMacSN.Text);
return(false);
}
if (rbLAN.Checked)
{
IsGPRS = chkGPRS.Checked;
}
if (!IsGPRS && !Pub.IsNumeric(txtMacSN.Text.Trim()) && MacSeriesTypeId != 3)
{
txtMacSN.Focus();
ShowErrorEnterCorrect(lblMacSN.Text);
return(false);
}
if (IsGPRS || MacSeriesTypeId == 3)
{
MacSN_GPRS = txtMacSN.Text.Trim();
}
else
{
MacSN = Convert.ToInt32(txtMacSN.Text.Trim());
MacSN_GPRS = MacSN.ToString();
}
MacConnType = MacConnTypeString.USB;
MacIP = "";
MacPort = "";
MacConnPWD = "";
MacDesc = "";
MacParamStr = "";
if (rbLAN.Checked)
{
MacConnType = MacConnTypeString.LAN;
MacIP = txtLANIP.Text.Trim();
MacPort = txtLANPort.Text.Trim();
if (MacIP == "")
{
txtLANIP.Focus();
ShowErrorEnterCorrect(lblLANIP.Text);
return(false);
}
if (!Pub.CheckTextMaxLength(lblLANIP.Text, MacIP, txtLANIP.MaxLength))
{
txtLANIP.Focus();
return(false);
}
if (!Pub.IsNumeric(MacPort))
{
txtLANPort.Focus();
ShowErrorEnterCorrect(lblLANPort.Text);
return(false);
}
MacConnPWD = txtLANPWD.Text.Trim();
SeaSeriesPwd = txtLANPWD.Text.Trim();
if (MacSeriesTypeId != 2)
{
if (MacConnPWD != "" && !Pub.IsNumeric(MacConnPWD))
{
txtLANPWD.Focus();
ShowErrorEnterCorrect(label3.Text);
return(false);
}
}
IsGPRS = chkGPRS.Checked;
}
MacDesc = txtDesc.Text.Trim();
if (!Pub.CheckTextMaxLength(label1.Text, MacDesc, txtDesc.MaxLength))
{
txtDesc.Focus();
return(false);
}
MacModeID = cbbMacMode.SelectedIndex.ToString();
InOutMode = cbbInOutMode.SelectedIndex.ToString();
MacSeriesUserName = txtMacSeriesUserName.Text;
return(true);
}
private bool CheckValue()
{
int MaxSN = SystemInfo.IsBigMacAdd ? SystemInfo.MaxSN603Ex : SystemInfo.MaxSN603;
IsBigMac = SystemInfo.IsBigMacAdd ? (byte)1 : (byte)0;
if ((txtMacSN.Text == "") || !Pub.IsNumeric(txtMacSN.Text))
{
txtMacSN.Focus();
Pub.ShowErrorMsg(string.Format(Pub.GetResText(formCode, "ErrorMacSN603", ""), 1, MaxSN));
return(false);
}
if (cbbMacType.SelectedIndex == -1)
{
cbbMacType.Focus();
ShowErrorSelectCorrect(lblMacType.Text);
return(false);
}
MacSN = Convert.ToInt32(txtMacSN.Text);
if (((TCommonType)cbbMacType.SelectedItem).id != "132")
{
if ((MacSN < 1) || (MacSN > MaxSN))
{
txtMacSN.Focus();
Pub.ShowErrorMsg(string.Format(Pub.GetResText(formCode, "ErrorMacSN603", ""), 1, MaxSN));
return(false);
}
}
else
{
if ((MacSN < 301) || (MacSN > 600))
{
txtMacSN.Focus();
Pub.ShowErrorMsg(string.Format(Pub.GetResText(formCode, "ErrorMacSN603", ""), 301, 600));
return(false);
}
}
MacType = ((TCommonType)cbbMacType.Items[cbbMacType.SelectedIndex]).id;
MacConnType = MacConnTypeString.USB;
MacIPAddress = "";
MacPort = "";
MacConnPWD = "";
MacDesc = "";
MacPhysicsAddress = txtWANAddress.Text.Trim().ToUpper();
MacAddressSysID = "";
if (rbComm.Checked)
{
MacConnType = MacConnTypeString.Comm;
MacPort = cbbCommPort.Text;
MacConnPWD = cbbCommBaudRate.Text;
if (MacPort == "")
{
ShowErrorSelectCorrect(lblCommPort.Text);
return(false);
}
}
else if (rbLAN.Checked)
{
MacConnType = MacConnTypeString.LAN;
MacIPAddress = txtLANIP.Text.Trim();
MacPort = txtLANPort.Text.Trim();
if (MacIPAddress == "")
{
txtLANIP.Focus();
Pub.ShowErrorMsg(Pub.GetResText(formCode, "ErrorMacIP", ""));
return(false);
}
if (!Pub.CheckTextMaxLength(lblLANIP.Text, MacIPAddress, txtLANIP.MaxLength))
{
txtLANIP.Focus();
return(false);
}
if (!Pub.IsNumeric(MacPort))
{
txtLANPort.Focus();
Pub.ShowErrorMsg(Pub.GetResText(formCode, "ErrorMacPort", ""));
return(false);
}
}
else if (rbWAN.Checked)
{
MacConnType = MacConnTypeString.GPRS;
MacIPAddress = txtWANIP.Text.Trim();
MacPort = txtWANPort.Text.Trim();
if (MacIPAddress == "")
{
txtWANIP.Focus();
Pub.ShowErrorMsg(Pub.GetResText(formCode, "ErrorMacIP", ""));
return(false);
}
if (!Pub.CheckTextMaxLength(lblWANIP.Text, MacIPAddress, txtWANIP.MaxLength))
{
txtWANIP.Focus();
return(false);
}
if (!Pub.IsNumeric(MacPort))
{
txtWANPort.Focus();
Pub.ShowErrorMsg(Pub.GetResText(formCode, "ErrorMacPort", ""));
return(false);
}
if (MacPhysicsAddress == "")
{
txtWANAddress.Focus();
Pub.ShowErrorMsg(Pub.GetResText(formCode, "ErrorMacAddress", ""));
return(false);
}
if (!Pub.CheckTextMaxLength(lblWANAddress.Text, MacIPAddress, txtWANAddress.MaxLength))
{
txtWANAddress.Focus();
return(false);
}
}
if (txtMacAddress.Tag != null)
{
MacAddressSysID = txtMacAddress.Tag.ToString();
}
MacDesc = txtDesc.Text.Trim();
if (!Pub.CheckTextMaxLength(label1.Text, MacDesc, txtDesc.MaxLength))
{
txtDesc.Focus();
return(false);
}
return(true);
}
private void btnOk_Click(object sender, EventArgs e)
{
if (cbbCardType.SelectedIndex == -1)
{
cbbCardType.Focus();
ShowErrorSelectCorrect(label11.Text);
return;
}
string EmpNo = txtEmpNo.Text.Trim();
string EmpName = txtEmpName.Text.Trim();
string EmpSexSysID = "";
if (cbbEmpSex.SelectedIndex >= 0)
{
EmpSexSysID = ((TCardType)cbbEmpSex.Items[cbbEmpSex.SelectedIndex]).sysID;
}
string EmpHireDate = txtEmpHireDate.Text.Trim();
string DepartSysID = "";
if (txtDepartName.Tag != null)
{
DepartSysID = txtDepartName.Tag.ToString();
}
string CardTypeSysID = ((TCardType)cbbCardType.Items[cbbCardType.SelectedIndex]).sysID;
string EmpCertNo = txtEmpCertNo.Text.Trim();
string CardPWD = txtCardPWD.Text.Trim();
string CardSectorNo = txtCardSectorNo.Text.Trim();
string CardStartDate = txtCardStartDate.Text.Trim();
string CardEndDate = txtCardEndDate.Text.Trim();
string CardFingerNo = txtCardFingerNo.Text.Trim();
string FingerPrivilege = cbbFingerPrivilege.SelectedIndex.ToString();
string EmpPhoneNo = txtEmpPhoneNo.Text.Trim();
string EmpAddress = txtEmpAddress.Text.Trim();
string EmpZipNo = txtEmpZipNo.Text.Trim();
string EmpEmail = txtEmpEmail.Text.Trim();
string IsAttend = "N";
if (chkIsAttend.Checked)
{
IsAttend = "Y";
}
string OtherCardNo = txtOtherCardNo.Text.Trim();
if (txtEmpNo.Enabled)
{
if (EmpNo == "")
{
txtEmpNo.Focus();
ShowErrorEnterCorrect(label1.Text);
return;
}
if (!Pub.CheckTextMaxLength(label1.Text, EmpNo, txtEmpNo.MaxLength))
{
txtEmpNo.Focus();
return;
}
}
if (txtEmpName.Enabled)
{
if (!Pub.CheckTextMaxLength(label2.Text, EmpName, txtEmpName.MaxLength))
{
txtEmpName.Focus();
return;
}
}
if (DepartSysID == "")
{
txtDepartName.Focus();
ShowErrorSelectCorrect(label4.Text);
return;
}
DateTime d = new DateTime();
if ((EmpHireDate == "") || (!DateTime.TryParse(EmpHireDate, out d)))
{
txtEmpHireDate.Focus();
ShowErrorEnterCorrect(label5.Text);
return;
}
EmpHireDate = d.ToString(SystemInfo.SQLDateFMT);
if (!Pub.CheckTextMaxLength(label6.Text, EmpCertNo, txtEmpCertNo.MaxLength))
{
txtEmpCertNo.Focus();
return;
}
if (txtCardPWD.Enabled)
{
if (CardPWD == "")
{
CardPWD = "000000";
}
if (!Pub.IsNumeric(CardPWD))
{
txtCardPWD.Focus();
ShowErrorEnterCorrect(label16.Text);
return;
}
if (!Pub.CheckTextMaxLength(label16.Text, CardPWD, txtCardPWD.MaxLength))
{
txtCardPWD.Focus();
return;
}
CardPWD = Convert.ToInt32(CardPWD).ToString("000000");
}
if (txtCardSectorNo.Enabled)
{
if ((CardSectorNo != "") && (!Pub.IsNumeric(CardSectorNo)))
{
txtCardSectorNo.Focus();
ShowErrorEnterCorrect(label12.Text);
return;
}
if (!Pub.CheckTextMaxLength(label12.Text, CardSectorNo, txtCardSectorNo.MaxLength))
{
txtCardSectorNo.Focus();
return;
}
if (CardSectorNo != "")
{
CardSectorNo = Convert.ToUInt64(CardSectorNo).ToString("0000000000");
if ((Convert.ToUInt64(CardSectorNo) <= 0) || (Convert.ToUInt64(CardSectorNo) > SystemInfo.MaxCardID))
{
Pub.ShowErrorMsg(SystemInfo.MsgMaxCardID);
return;
}
}
}
if (txtOtherCardNo.Enabled)
{
if ((OtherCardNo != "") && (!Pub.IsNumeric(OtherCardNo)))
{
txtOtherCardNo.Focus();
ShowErrorEnterCorrect(label19.Text);
return;
}
if (!Pub.CheckTextMaxLength(label19.Text, OtherCardNo, txtOtherCardNo.MaxLength))
{
txtOtherCardNo.Focus();
return;
}
//if (OtherCardNo != "") OtherCardNo = Convert.ToUInt32(OtherCardNo).ToString("0000000000");
}
if (txtCardStartDate.Enabled)
{
if ((CardStartDate == "") || (!DateTime.TryParse(CardStartDate, out d)))
{
txtCardStartDate.Focus();
ShowErrorEnterCorrect(label13.Text);
return;
}
CardStartDate = d.ToString(SystemInfo.SQLDateFMT);
}
if (txtCardEndDate.Enabled)
{
if ((CardEndDate == "") || (!DateTime.TryParse(CardEndDate, out d)))
{
txtCardEndDate.Focus();
ShowErrorEnterCorrect(label14.Text);
return;
}
CardEndDate = d.ToString(SystemInfo.SQLDateFMT);
}
if (txtCardFingerNo.Enabled)
{
if ((CardFingerNo != "") && (!Pub.IsNumeric(CardFingerNo)))
{
txtCardFingerNo.Focus();
ShowErrorEnterCorrect(label15.Text);
return;
}
if (!Pub.CheckTextMaxLength(label15.Text, CardFingerNo, txtCardFingerNo.MaxLength))
{
txtCardFingerNo.Focus();
return;
}
}
if (!Pub.CheckTextMaxLength(label17.Text, EmpPhoneNo, txtEmpPhoneNo.MaxLength))
{
txtEmpPhoneNo.Focus();
return;
}
if (!Pub.CheckTextMaxLength(label7.Text, EmpAddress, txtEmpAddress.MaxLength))
{
txtEmpAddress.Focus();
return;
}
if (!Pub.CheckTextMaxLength(label8.Text, EmpZipNo, txtEmpZipNo.MaxLength))
{
txtEmpZipNo.Focus();
return;
}
if (!Pub.CheckTextMaxLength(label10.Text, EmpEmail, txtEmpEmail.MaxLength))
{
txtEmpEmail.Focus();
return;
}
CardStartDate = "'" + CardStartDate + "'";
CardEndDate = "'" + CardEndDate + "'";
DataTableReader dr = null;
bool IsOk = true;
List <string> sql = new List <string>();
string CardNoDays = "";
string msg = "";
try
{
if (!db.IsOpen)
{
db.Open(SystemInfo.ConnStr);
}
if (IsAdd)
{
if (!db.GetServerGUID(ref SysID))
{
return;
}
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_001003, new string[] { "2", EmpNo }));
if (dr.Read())
{
txtEmpNo.Focus();
ShowErrorCannotRepeated(label1.Text);
IsOk = false;
}
dr.Close();
if (IsOk && (CardSectorNo != ""))
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_001003, new string[] { "206", CardSectorNo }));
if (dr.Read())
{
txtCardSectorNo.Focus();
ShowErrorCannotRepeated(label12.Text);
IsOk = false;
}
if (IsOk & db.CardSectorNoIsExists(SysID, CardSectorNo, ref CardNoDays))
{
if (CardNoDays == " ")
{
msg = Pub.GetResText(formCode, "MsgCardExistsBlackAgainA", "");
}
else if (DateTime.TryParse(CardNoDays, out d))
{
msg = Pub.GetResText(formCode, "MsgCardExistsUseDaysAgainA", "");
}
else
{
msg = Pub.GetResText(formCode, "MsgCardExistsUseingAgainA", "");
}
msg = string.Format(msg, CardSectorNo, CardNoDays);
txtCardSectorNo.Focus();
Pub.ShowErrorMsg(msg);
IsOk = false;
}
}
dr.Close();
if (IsOk && (OtherCardNo != ""))
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_001003, new string[] { "109", OtherCardNo }));
if (dr.Read())
{
txtOtherCardNo.Focus();
ShowErrorCannotRepeated(label19.Text);
IsOk = false;
}
}
dr.Close();
if (IsOk && (CardFingerNo != ""))
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_001003, new string[] { "5", CardFingerNo }));
if (dr.Read())
{
txtCardFingerNo.Focus();
ShowErrorCannotRepeated(label15.Text);
IsOk = false;
}
}
dr.Close();
if (IsOk)
{
sql.Add(Pub.GetSQL(DBCode.DB_001003, new string[] { "8", SysID, EmpNo, EmpName, EmpSexSysID,
CardTypeSysID, DepartSysID, EmpHireDate, EmpCertNo, EmpAddress, EmpZipNo, EmpPhoneNo,
EmpEmail, IsAttend, OtherCardNo, FingerPrivilege }));
}
}
else
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_001003, new string[] { "4", SysID, EmpNo }));
if (dr.Read())
{
txtEmpNo.Focus();
ShowErrorCannotRepeated(label1.Text);
IsOk = false;
}
if (IsOk && (CardSectorNo != "") && txtCardSectorNo.Enabled)
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_001003, new string[] { "6", SysID, CardSectorNo }));
if (dr.Read())
{
txtCardSectorNo.Focus();
ShowErrorCannotRepeated(label12.Text);
IsOk = false;
}
if (IsOk && db.CardSectorNoIsExists(SysID, CardSectorNo, ref CardNoDays))
{
if (CardNoDays == " ")
{
msg = Pub.GetResText(formCode, "MsgCardExistsBlackAgainA", "");
}
else if (DateTime.TryParse(CardNoDays, out d))
{
msg = Pub.GetResText(formCode, "MsgCardExistsUseDaysAgainA", "");
}
else
{
msg = Pub.GetResText(formCode, "MsgCardExistsUseingAgainA", "");
}
msg = string.Format(msg, CardSectorNo, CardNoDays);
txtCardSectorNo.Focus();
Pub.ShowErrorMsg(msg);
IsOk = false;
}
}
dr.Close();
if (IsOk && (OtherCardNo != "") && txtOtherCardNo.Enabled)
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_001003, new string[] { "110", SysID, OtherCardNo }));
if (dr.Read())
{
txtOtherCardNo.Focus();
ShowErrorCannotRepeated(label19.Text);
IsOk = false;
}
}
dr.Close();
if (IsOk && (CardFingerNo != "") && txtCardFingerNo.Enabled)
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_001003, new string[] { "7", SysID, CardFingerNo }));
if (dr.Read())
{
txtCardFingerNo.Focus();
ShowErrorCannotRepeated(label15.Text);
IsOk = false;
}
}
dr.Close();
if (IsOk)
{
sql.Add(Pub.GetSQL(DBCode.DB_001003, new string[] { "9", EmpNo, EmpName, EmpSexSysID, CardTypeSysID,
DepartSysID, EmpHireDate, EmpCertNo, EmpAddress, EmpZipNo, EmpPhoneNo, EmpEmail, IsAttend,
OtherCardNo, FingerPrivilege, SysID }));
}
}
if (IsOk)
{
if (txtEmpNo.Enabled)
{
sql.Add(Pub.GetSQL(DBCode.DB_001003, new string[] { "232", CardSectorNo, CardPWD, CardStartDate,
CardEndDate, SysID, CardFingerNo }));
}
if (db.ExecSQL(sql) != 0)
{
IsOk = false;
}
}
if (IsOk)
{
byte[] buff = new byte[0];
if (picPhoto.BackgroundImage != null)
{
MemoryStream ms = new MemoryStream();
picPhoto.BackgroundImage = CustomSizeImage(picPhoto.BackgroundImage);
Bitmap t = new Bitmap(picPhoto.BackgroundImage);
t.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
buff = ms.ToArray();
}
db.UpdateByteData(Pub.GetSQL(DBCode.DB_001003, new string[] { "10", SysID }), "EmpPhotoImage", buff);
buff = new byte[0];
if (picDynPhoto.BackgroundImage != null)
{
MemoryStream ms = new MemoryStream();
picDynPhoto.BackgroundImage = CustomSizePhoto(picDynPhoto.BackgroundImage);
Bitmap t = new Bitmap(picDynPhoto.BackgroundImage);
t.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
buff = ms.ToArray();
}
if (dr != null)
{
dr.Close();
}
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_001003, new string[] { "34", SysID }));
if (!dr.Read())
{
db.ExecSQL(Pub.GetSQL(DBCode.DB_001003, new string[] { "35", SysID }));
}
db.UpdateByteData(Pub.GetSQL(DBCode.DB_001003, new string[] { "29", SysID }), "EmpPhotoImage", buff);
if (txtCardPWD.Enabled)
{
db.UpdateEmpRegisterData(SysID, 10, CardPWD);
}
// if (txtOtherCardNo.Enabled) db.UpdateEmpRegisterData(SysID, 11, OtherCardNo);
}
}
catch (Exception E)
{
IsOk = false;
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
if (IsOk)
{
db.WriteSYLog(this.Text, CurrentOprt, sql);
Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information);
IsAddNext = chkIsAdd.Checked;
this.DialogResult = DialogResult.OK;
this.Close();
}
}
