protected override void ExecItemTAG1() { DateTime StartTime = DateTime.Now; contextMenu.Close(); string msg = Pub.GetResText(formCode, "Msg001", ""); RefreshMsg(msg); List <string> sql = new List <string>(); int RecNo = Report.DetailGrid.Recordset.RecordNo; while (!Report.DetailGrid.Recordset.Eof()) { if (Report.FieldByName("Checked").AsInteger == (int)GRSystemImage.grsi3DChecked) { sql.Add(Pub.GetSQL(DBCode.DB_001003, new string[] { "704", GetSysID() })); } Report.DetailGrid.Recordset.Next(); } Report.DetailGrid.Recordset.MoveTo(RecNo); if (sql.Count == 0) { RefreshMsg(""); Pub.ShowErrorMsg(Pub.GetResText(formCode, "Error001", "")); return; } if (db.ExecSQL(sql) != 0) { return; } db.WriteSYLog(this.Text, CurrentTool, msg); ExecItemRefresh(); msg = string.Format(Pub.GetResText(formCode, "Msg002", ""), sql.Count); RefreshMsg(msg + Pub.GetDateDiffTimes(StartTime, DateTime.Now, true), true); }
private void ExportGridReport(GridppReport report, GRExportType exportType, string Title, string FileName) { DateTime StartTime = DateTime.Now; string msg = Pub.GetResText("", "MsgExportingData", ""); msg = string.Format(msg, Title); if (File.Exists(FileName)) { File.Delete(FileName); } if (report.DetailGrid != null) { if (report.ColumnByName("CheckBox") != null) { report.ColumnByName("CheckBox").Visible = false; } } bool ret = report.ExportDirect(exportType, FileName, true, false); if (report.DetailGrid != null) { if (report.ColumnByName("CheckBox") != null) { report.ColumnByName("CheckBox").Visible = true; } } if (!ret) { return; } msg = Pub.GetResText("", "MsgExportSuccess", ""); msg = string.Format(msg, Title); RefreshMsg(msg + Pub.GetDateDiffTimes(StartTime, DateTime.Now, true), true); Pub.MessageBoxShow(msg, MessageBoxIcon.Information); }
protected void ExecMacOprt(byte flag, bool IsMac) { currOprt = CurrentTool; bool state; string msg = ""; string MacMsg = ""; if (!InitMacList(IsMac)) { return; } IsExec = true; string tmp = ""; RefreshForm(false); DateTime start = new DateTime(); start = DateTime.Now; string ExecTimes = ""; txtMag.Text = ""; for (int i = 0; i < connList.Count; i++) { TConnInfoFinger conn = connList[i]; RefreshMsg(currOprt + "[" + conn.MacSN.ToString() + "]......"); DeviceObject.objFK623.InitConn(conn); state = ExecMacCommand(flag, conn.MacSN, conn.MacType, ref MacMsg); ExecTimes = " " + Pub.GetDateDiffTimes(start, DateTime.Now); if (IsMac) { if (MacMsg != "") { MacMsg = "[" + MacMsg + "]"; } tmp = DeviceObject.objFK623.ErrMsg; SetMacResult(conn.MacSN, state, MacMsg + tmp + ExecTimes); msg = msg + GetMacMsg(conn.MacSN) + ":" + MacMsg + DeviceObject.objFK623.ErrMsg + ";"; } else if (state) { SetMacResult(conn.MacSN, state, Pub.GetResText(formCode, "MsgSaveSucceed", "") + ExecTimes); msg = msg + GetMacMsg(conn.MacSN) + ":" + Pub.GetResText(formCode, "MsgSaveSucceed", "") + MacMsg + ";"; } else { SetMacResult(conn.MacSN, state, Pub.GetResText(formCode, "MsgSaveFailed", "") + ExecTimes); msg = msg + GetMacMsg(conn.MacSN) + ":" + Pub.GetResText(formCode, "MsgSaveFailed", "") + MacMsg + ";"; } Application.DoEvents(); start = DateTime.Now; if (!IsExec) { break; } } db.WriteSYLog(this.Text, currOprt, msg); IsExec = false; RefreshForm(true); RefreshMsg(""); }
protected override void ExecItemRefresh() { DateTime StartTime = DateTime.Now; QuerySQL = Pub.GetSQL(DBCode.DB_000207, new string[] { "0", DepartID, dtpYM.Value.Year.ToString(), dtpYM.Value.Month.ToString() }); RefreshMsg(StrReading); DataTable dt = null; if (QuerySQL != "") { try { dt = SystemInfo.db.GetDataTable(QuerySQL); } catch (Exception E) { Pub.ShowErrorMsg(E, QuerySQL); } } ComboBox cbb; for (int i = 1; i <= 31; i++) { cbb = (ComboBox)pnlRight.Controls["cbbDay" + i.ToString("00")]; if (cbb.Items.Count > 0) { cbb.SelectedIndex = 0; } } if (dt != null) { DateTime d = new DateTime(dtpYM.Value.Year, dtpYM.Value.Month, 1); for (int i = 1; i <= 31; i++) { cbb = (ComboBox)pnlRight.Controls["cbbDay" + i.ToString("00")]; for (int j = 0; j < dt.Rows.Count; j++) { if (dt.Rows[j]["DepShiftDate"].ToString() == d.AddDays(i - 1).ToString()) { for (int k = 0; k < cbb.Items.Count; k++) { if (((TIDAndName)cbb.Items[k]).id == dt.Rows[j]["ShiftNo"].ToString()) { cbb.SelectedIndex = k; break; } } break; } } } } dt.Clear(); dt.Reset(); RefreshMsg(StrReadEnd + Pub.GetDateDiffTimes(StartTime, DateTime.Now, true), true); }
private void CalcRecords(string EmpTag, string EmpNo, string DepartTag, string DepartID, string DepartList, string ResultYM) { progBar.ProgressType = DevComponents.DotNetBar.eProgressItemType.Standard; progBar.Value = 0; string msg = Pub.GetResText(formCode, "Msg001", ""); int empCount = 0; bool IsError = false; DateTime StartTime = DateTime.Now; List <string> sql = new List <string>(); DataTable dt = null; try { dt = SystemInfo.db.GetDataTable(Pub.GetSQL(DBCode.DB_000404, new string[] { "5", EmpTag, EmpNo, DepartTag, DepartID, DepartList })); for (int i = 0; i < dt.Rows.Count; i++) { lblMsg.Text = msg + string.Format("{0}/{1}", i + 1, dt.Rows.Count) + " [" + dt.Rows[i]["DepartID"].ToString() + "]" + dt.Rows[i]["DepartName"].ToString() + " - [" + dt.Rows[i]["EmpNo"].ToString() + "]" + dt.Rows[i]["EmpName"].ToString() + " " + Pub.GetDateDiffTimes(StartTime, DateTime.Now, true); Application.DoEvents(); if (!CalcRecordsData(dt.Rows[i]["EmpNo"].ToString(), dt.Rows[i]["EmpName"].ToString(), dt.Rows[i]["DepartID"].ToString(), dt.Rows[i]["DepartName"].ToString(), ResultYM)) { IsError = true; break; } empCount += 1; progBar.Value = (i + 1) * 100 / dt.Rows.Count; Application.DoEvents(); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dt != null) { dt.Clear(); dt.Reset(); } dt = null; } if (IsError) { msg = Pub.GetResText(formCode, "Msg003", ""); } else { msg = Pub.GetResText(formCode, "Msg002", ""); } RefreshMsg(string.Format(msg, empCount, Pub.GetDateDiffTimes(StartTime, DateTime.Now, true))); }
private void ExecMacOprt() { bool state; string msg = ""; string MacMsg = ""; if (!InitMacList()) { return; } IsWorking = true; RefresButton(); DateTime start = new DateTime(); start = DateTime.Now; string ExecTimes = ""; TDIConnInfo conn; for (int i = 0; i < connList.Count; i++) { conn = connList[i]; RefreshMsg(oprt + "[" + conn.MacSN_GPRS.ToString() + "]......", i); RefreshMacMsg(oprt + "[" + conn.MacSN_GPRS.ToString() + "]......"); DeviceObject.objFK623.InitConn(conn); if (!DeviceObject.objFK623.IsOpen) { DeviceObject.objFK623.Open(); } DeviceObject.objFK623.EnableDevice(0); state = DeviceObject.objFK623.IsOpen; if (state) { state = ExecMacCommand(conn.MacSN_GPRS, ref MacMsg); } ExecTimes = " " + Pub.GetDateDiffTimes(start, DateTime.Now); if (MacMsg != "") { MacMsg = "[" + MacMsg + "]"; } UpdateMacMsg(MacMsg + DeviceObject.objFK623.ErrMsg + ExecTimes, state); msg = msg + conn.MacSN_GPRS.ToString() + ":" + MacMsg + DeviceObject.objFK623.ErrMsg + ";"; DeviceObject.objFK623.EnableDevice(1); DeviceObject.objFK623.Close(); Application.DoEvents(); start = DateTime.Now; if (!IsWorking) { break; } } SystemInfo.db.WriteSYLog(this.Text, oprt, msg); IsWorking = false; RefresButton(); RefreshMsg("", 0); }
protected override void ExecItemRefresh() { DateTime StartTime = DateTime.Now; contextMenu.Close(); int row = -1; RefreshMsg(StrReading); if (QuerySQL != "") { try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } row = dispView.SelRowNo; //dispView.Report.DetailGrid.Recordset.QuerySQL = QuerySQL; dispView.Stop(); dispView.Start(); //dispView.Refresh(); Application.DoEvents(); } catch (Exception E) { Pub.ShowErrorMsg(E, QuerySQL); } finally { if (row < dispView.RowCount) { dispView.SelRowNo = row; } else if (dispView.RowCount > 0) { dispView.SelRowNo = dispView.RowCount - 1; } } } string s = this.Text; if (s == "") { s = Pub.GetResText("Main", "mnu" + formCode, ""); } SetReportTitle(dispView, s); RefreshForm(true); RefreshMsg(StrReadEnd + Pub.GetDateDiffTimes(StartTime, DateTime.Now, true), true); }
protected virtual void ExecItemRefresh() { if ((db == null) || (SystemInfo.ConnStr == "")) { return; } DateTime StartTime = DateTime.Now; int row = -1; RefreshMsg(StrReading); if (QuerySQL != "") { try { if (bindingSource.DataSource != null) { row = bindingSource.Position; } bindingSource.DataSource = null; if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } bindingSource.DataSource = db.GetDataTable(QuerySQL); } catch (Exception E) { Pub.ShowErrorMsg(E, QuerySQL); } finally { if ((bindingSource.DataSource != null) && (row >= 0)) { if (row < bindingSource.Count) { bindingSource.Position = row; } else if (bindingSource.Count > 0) { bindingSource.Position = bindingSource.Count - 1; } } } } RefreshForm(true); RefreshMsg(StrReadEnd + Pub.GetDateDiffTimes(StartTime, DateTime.Now, true), true); }
private void btnOk_Click(object sender, EventArgs e) { List <string> sysField = new List <string>(); List <string> srcField = new List <string>(); for (int i = 0; i < impGrid.RowCount; i++) { if ((impGrid[0, i].Value != null) && Pub.ValueToBool(impGrid[0, i].Value)) { sysField.Add(impGrid[2, i].Value.ToString()); if (impGrid[3, i].Value.ToString() == "" || impGrid[3, i].Value == null) { Pub.MessageBoxShow(Pub.GetResText(formCode, "Error003", "")); return; } srcField.Add(impGrid[3, i].Value.ToString()); } } if (sysField.Count == 0) { impGrid.Focus(); Pub.MessageBoxShow(Pub.GetResText(formCode, "Error003", "")); return; } IsImporting = true; DateTime StartTime = DateTime.Now; RefreshForm(); string DepartUpID = ""; if (txtDepart.Tag != null) { DepartUpID = txtDepart.Tag.ToString(); } if (DepartUpID == "") { DepartUpID = SystemInfo.CommanyID; } int RecordCount = dtIn.Rows.Count; int RecordFact = 0; string FileName = SystemInfo.AppPath + "FormDataIn\\" + DateTime.Now.Date.ToString(SystemInfo.DateFormatLog) + ".txt"; string Msg = string.Format(Pub.GetResText(formCode, "Msg001", ""), Title); progBar.Value = 0; label7.Text = RecordCountString + RecordCount.ToString(); label8.Text = RecordIndexString + "0"; label9.Text = RecordFactString + RecordFact.ToString(); Pub.WriteTextFile(FileName, Msg); string ErrorMsg = ""; string NoStr = Pub.GetResText(formCode, "Msg003", ""); Application.DoEvents(); for (int i = 0; i < dtIn.Rows.Count; i++) { if (!IsImporting) { break; } if (prcImportData(dtIn.Rows[i], sysField, srcField, DepartUpID, ref ErrorMsg)) { RecordFact = RecordFact + 1; } progBar.Value = (i + 1) * 100 / RecordCount; label7.Text = RecordCountString + RecordCount.ToString(); label8.Text = RecordIndexString + (i + 1).ToString(); label9.Text = RecordFactString + RecordFact.ToString(); if (ErrorMsg != "") { Msg = string.Format(NoStr, i + 1) + ErrorMsg; Pub.WriteTextFile(FileName, Msg); } Application.DoEvents(); } IsImporting = false; RefreshForm(); Msg = string.Format(Pub.GetResText(formCode, "Msg002", ""), Title, label7.Text, label8.Text, label9.Text); string ss = Pub.GetDateDiffTimes(StartTime, DateTime.Now); Pub.WriteTextFile(FileName, Msg + " " + ss); Pub.MessageBoxShow(Msg + "\r\n\r\n" + ss, MessageBoxIcon.Information); this.DialogResult = DialogResult.OK; this.Close(); }
private void ExecMacOprt() { bool state; string msg = ""; string MacMsg = ""; if (!InitMacList()) { return; } IsWorking = true; RefresButton(); DateTime start = new DateTime(); start = DateTime.Now; string ExecTimes = ""; string url = ""; TDIConnInfo conn; for (int i = 0; i < connList.Count; i++) { conn = connList[i]; RefreshMsg(oprt + "[" + conn.MacSN.ToString() + "]......", i); RefreshMacMsg(oprt + "[" + conn.MacSN.ToString() + "]......"); SystemInfo.MacSeriesTypeId = 2; url = "http://" + conn.NetHost + "/"; string body = ""; string urlTestConnt = "http://" + conn.NetHost + "/action/GetSysParam"; bool ret = DeviceObject.objFK623.POST_GetResponse(urlTestConnt, conn.MacSeriesUserName, conn.SeaSeries_Pwd, ref body); if (ret) { state = ExecMacCommand(conn.MacSN, url, conn.MacSeriesUserName, conn.SeaSeries_Pwd, ref MacMsg); } else { state = false; } ExecTimes = " " + Pub.GetDateDiffTimes(start, DateTime.Now); if (MacMsg != "") { MacMsg = "[" + MacMsg + "]"; } UpdateMacMsg(MacMsg + DeviceObject.objFK623.SeaBodyStr() + ExecTimes, state); msg = msg + conn.MacSN.ToString() + ":" + MacMsg + DeviceObject.objFK623.SeaBodyStr() + ";"; Application.DoEvents(); start = DateTime.Now; if (!IsWorking) { break; } } SystemInfo.db.WriteSYLog(this.Text, oprt, msg); IsWorking = false; RefresButton(); RefreshMsg("", 0); }
private void btnOk_Click(object sender, EventArgs e) { List <string> sysField = new List <string>(); List <string> srcField = new List <string>(); for (int i = 0; i < impGrid.RowCount; i++) { if ((impGrid[0, i].Value != null) && Pub.ValueToBool(impGrid[0, i].Value)) { sysField.Add(impGrid[2, i].Value.ToString()); srcField.Add(impGrid[3, i].Value.ToString()); } } if (sysField.Count == 0) { impGrid.Focus(); Pub.ShowErrorMsg(Pub.GetResText(formCode, "Error003", "")); return; } IsImporting = true; DateTime StartTime = DateTime.Now; RefreshForm(); string DepartUpSysID = ""; if (txtDepart.Tag != null) { DepartUpSysID = txtDepart.Tag.ToString(); } if (DepartUpSysID == "") { DepartUpSysID = SystemInfo.CommanySysID; } int RecordCount = dtIn.Rows.Count; int RecordFact = 0; double SumMoney = 0; string FileName = SystemInfo.AppPath + "FormDataIn\\" + DateTime.Now.Date.ToString(SystemInfo.DateFormatLog) + ".txt"; string Msg = string.Format(Pub.GetResText(formCode, "Msg001", ""), Title); progBar.Value = 0; label7.Text = RecordCountString + RecordCount.ToString(); label8.Text = RecordIndexString + "0"; label9.Text = RecordFactString + RecordFact.ToString(); if (IsShowCount) { label9.Text = label9.Text + "(" + SumMoney.ToString(SystemInfo.CurrencySymbol + "0.00") + ")"; } Pub.WriteTextFile(FileName, Msg); string ErrorMsg = ""; string NoStr = Pub.GetResText(formCode, "Msg003", ""); Application.DoEvents(); /*if (dtIn.Rows.Count > 0) * { * try * { * string s = dtIn.Rows[0]["AllowanceFlag"].ToString(); * DateTime dFlag = new DateTime(); * if (DateTime.TryParse(s, out dFlag)) * { * DateTime dt = new DateTime(); * byte retCheck = db.CheckAllowanceFlag("", dFlag, ref dt); * if (retCheck == 1) * { * Pub.MessageBoxShow(string.Format(Pub.GetResText("SFAllowanceAdd", "Error101", ""), dt.ToShortDateString())); * return; * } * else if (retCheck == 2) * { * Pub.MessageBoxShow(string.Format(Pub.GetResText("SFAllowanceAdd", "Error102", ""), dt.ToShortDateString())); * return; * } * } * } * catch * { * } * }*/ for (int i = 0; i < dtIn.Rows.Count; i++) { if (!IsImporting) { break; } if (prcImportData(dtIn.Rows[i], sysField, srcField, DepartUpSysID, ref ErrorMsg, ref SumMoney)) { RecordFact = RecordFact + 1; } progBar.Value = (i + 1) * 100 / RecordCount; label7.Text = RecordCountString + RecordCount.ToString(); label8.Text = RecordIndexString + (i + 1).ToString(); label9.Text = RecordFactString + RecordFact.ToString(); if (IsShowCount) { label9.Text = label9.Text + "(" + SumMoney.ToString(SystemInfo.CurrencySymbol + "0.00") + ")"; } if (ErrorMsg != "") { Msg = string.Format(NoStr, i + 1) + ErrorMsg; Pub.WriteTextFile(FileName, Msg); } Application.DoEvents(); } IsImporting = false; RefreshForm(); Msg = string.Format(Pub.GetResText(formCode, "Msg002", ""), Title, label7.Text, label8.Text, label9.Text); string ss = Pub.GetDateDiffTimes(StartTime, DateTime.Now); Pub.WriteTextFile(FileName, Msg + " " + ss); Pub.MessageBoxShow(Msg + "\r\n\r\n" + ss, MessageBoxIcon.Information); this.DialogResult = DialogResult.OK; this.Close(); }
private void button1_Click(object sender, EventArgs e) { if (dtpStart.Value > dtpEnd.Value) { dtpStart.Focus(); Pub.MessageBoxShow(Pub.GetResText(formCode, "ErrorStartDateBegreater", "")); return; } int week = 0; long days = Pub.DateDiff(DateInterval.Day, dtpStart.Value.Date, dtpEnd.Value.Date) + 1; if (days > 31) { Pub.MessageBoxShow(string.Format(Pub.GetResText(formCode, "Error001", ""), 31)); return; } if (cbWeek.Checked) { week = 1; if (days > 7) { Pub.MessageBoxShow(string.Format(Pub.GetResText(formCode, "Error001", ""), 7)); return; } } if (rbEmp.Checked && (cardGrid.RowCount == 0)) { Pub.MessageBoxShow(Pub.GetResText(formCode, "ErrorSelectEmp", "")); return; } IsWorking = true; RefreshControl(); string msg = Pub.GetResText(formCode, "Msg001", ""); bool IsError = false; DateTime StartTime = DateTime.Now; DataTable dt = null; label3.Text = msg; progBar.Value = 0; string EmpNo; DateTime StartDate = dtpStart.Value.Date; DateTime EndDate = dtpEnd.Value.Date; int empCount = 0; try { if (SystemInfo.DBType == 0) { SystemInfo.objACKQ.PKQ_Temp_KQ_KQData(StartDate, EndDate); } SystemInfo.db.WriteConfig("KQ", "AllowAdjust", true); if (rbAll.Checked) { dt = SystemInfo.db.GetDataTable(Pub.GetSQL(DBCode.DB_000213, new string[] { "0" })); for (int i = 0; i < dt.Rows.Count; i++) { label3.Text = msg + string.Format("{0}/{1}", i + 1, dt.Rows.Count) + " [" + dt.Rows[i]["DepartID"].ToString() + "]" + dt.Rows[i]["DepartName"].ToString() + " - [" + dt.Rows[i]["EmpNo"].ToString() + "]" + dt.Rows[i]["EmpName"].ToString() + " " + Pub.GetDateDiffTimes(StartTime, DateTime.Now, true); EmpNo = dt.Rows[i]["EmpNo"].ToString(); if (!CalcEmpData(EmpNo, StartDate, EndDate, week)) { IsError = true; break; } empCount += 1; progBar.Value = (i + 1) * 100 / dt.Rows.Count; if (!IsWorking) { break; } Application.DoEvents(); } } else { DataTable dtGrid = (DataTable)cardGrid.DataSource; for (int i = 0; i < dtGrid.Rows.Count; i++) { label3.Text = msg + string.Format("{0}/{1}", i + 1, cardGrid.RowCount) + " [" + dtGrid.Rows[i]["DepartID"].ToString() + "]" + dtGrid.Rows[i]["DepartName"].ToString() + " - [" + dtGrid.Rows[i]["EmpNo"].ToString() + "]" + dtGrid.Rows[i]["EmpName"].ToString() + " " + Pub.GetDateDiffTimes(StartTime, DateTime.Now, true); EmpNo = dtGrid.Rows[i]["EmpNo"].ToString(); if (!CalcEmpData(EmpNo, StartDate, EndDate, week)) { IsError = true; break; } empCount += 1; progBar.Value = (i + 1) * 100 / cardGrid.RowCount; if (!IsWorking) { break; } Application.DoEvents(); } } SystemInfo.db.DeleteConfig("KQ", "AllowAdjust"); } catch (Exception E) { IsError = true; Pub.ShowErrorMsg(E); } finally { if (dt != null) { dt.Clear(); dt.Reset(); } dt = null; } IsWorking = false; RefreshControl(); if (IsError) { msg = Pub.GetResText(formCode, "Msg003", ""); } else { msg = Pub.GetResText(formCode, "Msg002", ""); } label3.Text = string.Format(msg, empCount, Pub.GetDateDiffTimes(StartTime, DateTime.Now, true)); }
protected override void ExecItemRefresh() { DateTime StartTime = DateTime.Now; string StartDate = dtpStart.Value.ToString(SystemInfo.SQLDateFMT); string EndDate = dtpEnd.Value.ToString(SystemInfo.SQLDateFMT); string EmpTag = "0"; string EmpNo = ""; string DepartTag = "0"; string DepartID = ""; string DepartList = ""; if ((txtEmp.Text.Trim() != "") && (txtEmp.Tag != null)) { EmpNo = txtEmp.Tag.ToString(); EmpTag = "1"; } else if (txtEmp.Text.Trim() != "") { EmpNo = txtEmp.Text.Trim(); } if ((txtDepart.Text.Trim() != "") && (txtDepart.Tag != null)) { DepartID = txtDepart.Tag.ToString(); DepartTag = "1"; } else if (txtDepart.Text.Trim() != "") { DepartID = txtDepart.Text.Trim(); } ReadingShift = true; RefreshForm(true); if (DepartTag == "1") { if (DepartID != "") { DepartList = db.GetDepartChildID(DepartID); } if (DepartList == "") { DepartList = "''"; } } contextMenu.Close(); RefreshMsg(StrReading); if (button1.Checked) { DataTable dt = null; string sql = ""; try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } dt = db.GetDataTable(Pub.GetSQL(DBCode.DB_002007, new string[] { "0", OprtInfo.DepartPower, EmpTag, EmpNo, DepartTag, DepartID, DepartList })); for (int i = 0; i < dt.Rows.Count; i++) { sql = Pub.GetSQL(DBCode.DB_002007, new string[] { "1", dt.Rows[i]["EmpSysID"].ToString(), StartDate, EndDate }); db.ExecSQL(sql); RefreshMsg(StrReading + string.Format(" {0}/{1}", i + 1, dt.Rows.Count)); Application.DoEvents(); } } catch (Exception E) { RefreshMsg(StrReading); Pub.ShowErrorMsg(E); } finally { if (dt != null) { dt.Reset(); dt.Clear(); } } } RefreshMsg(StrReading); SetReportDate(dispView, label4.Text + ": " + dtpStart.Value.ToShortDateString() + " - " + dtpStart.Value.ToShortDateString()); QuerySQL = ""; string NormalRest = Pub.GetResText(formCode, "NormalRest", ""); string TurnsoffRest = Pub.GetResText(formCode, "TurnsoffRest", ""); if (button1.Checked) { QuerySQL = Pub.GetSQL(DBCode.DB_002007, new string[] { "2", StartDate, EndDate, EmpTag, EmpNo, DepartTag, DepartID, DepartList, OprtInfo.DepartPower }); } else if (button2.Checked) { QuerySQL = Pub.GetSQL(DBCode.DB_002007, new string[] { "3", StartDate, EndDate, EmpTag, EmpNo, DepartTag, DepartID, DepartList, OprtInfo.DepartPower }); } else if (button4.Checked) { QuerySQL = Pub.GetSQL(DBCode.DB_002007, new string[] { "4", StartDate, EndDate, DepartTag, DepartID, DepartList, OprtInfo.DepartPower }); } else if (button6.Checked) { QuerySQL = Pub.GetSQL(DBCode.DB_002007, new string[] { "5", NormalRest, TurnsoffRest, EmpTag, EmpNo, DepartTag, DepartID, DepartList, OprtInfo.DepartPower }); } else if (button8.Checked) { QuerySQL = Pub.GetSQL(DBCode.DB_002007, new string[] { "6", NormalRest, TurnsoffRest, DepartTag, DepartID, DepartList, OprtInfo.DepartPower }); } int row = -1; if (QuerySQL != "") { dispView.Report.DetailGrid.Recordset.QuerySQL = QuerySQL; try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } row = dispView.SelRowNo; dispView.Refresh(); Application.DoEvents(); } catch (Exception E) { Pub.ShowErrorMsg(E, QuerySQL); } finally { if (row < dispView.RowCount) { dispView.SelRowNo = row; } else if (dispView.RowCount > 0) { dispView.SelRowNo = dispView.RowCount - 1; } } } RefreshMsg(StrReadEnd + Pub.GetDateDiffTimes(StartTime, DateTime.Now, true), true); ReadingShift = false; RefreshForm(true); }
/// <summary> /// 写入信息 /// </summary> protected override void ExecItemTAG3() { base.ExecItemTAG3(); refreshForm(false); DateTime StartTime = DateTime.Now; RefreshMsg(ItemTAG5.Text); byte[] sendData = new byte[0]; string info = ""; string Category = "01"; string CardNo = ""; string Varieties = "01"; string Money = "0.00"; string CategoryName = "01"; string VarietiesName = "01"; isStop = false; infoIndex = 0; try { if (serialPort.IsOpen) { string cmdStr = "D1 89 31 06 36 56"; sendData = HexStringToByteArray(cmdStr); Thread.Sleep(300); serialPort.Write(sendData, 0, sendData.Length); isHand = true; CardList.Clear(); post_GetInfo(false); } else { Pub.MessageBoxShow(Pub.GetResText(formCode, "Error01", ""), MessageBoxIcon.Error); } if (CardList.Count <= 0) { Pub.MessageBoxShow(Pub.GetResText(formCode, "Error08", ""), MessageBoxIcon.Error); } dtReal.Rows.Clear(); for (int a = 0; a < CardList.Count; a++) { if (isStop) { break; } if (serialPort.IsOpen) { writeReadData = ""; CardNo = CardList[a].ToString(); Varieties = cbbVarieties.Tag.ToString(); double d = 0; double.TryParse(cbbMoney.Text.Trim(), out d); Money = d.ToString("#0.00"); Category = cbbCategory.Tag.ToString(); CategoryName = cbbCategory.Text.Trim(); VarietiesName = cbbVarieties.Text.Trim(); for (int i = 1; i < 3; i++) { if (isStop) { break; } string UID = getUID(getCardNo(CardNo)); string blockNumber = i.ToString("X2"); string data = ""; switch (i) { case (int)CardSector.SectorOne: data = Convert.ToInt32(Varieties).ToString("X8"); break; case (int)CardSector.SectorTwo: data = Convert.ToInt32(Category).ToString("X8"); break; case (int)CardSector.SectorTree: data = 0.ToString("X2") + ((int)(Convert.ToDouble(Money) * 100)).ToString("X6"); break; } data = getUID(data); Cmd cmd_buffer = new Cmd(); cmd_buffer.Command1 = "06"; cmd_buffer.Data1 = getData("23 21 " + UID + " " + blockNumber + " " + data); string tmp = cmd_buffer.Data1.Replace(" ", ""); cmd_buffer.Datalen1 = (tmp.Length / 2).ToString("X2"); cmd_buffer.Checksum1 = Check_sum(cmd_buffer.Header1.Trim() + " " + cmd_buffer.Command1.Trim() + " " + cmd_buffer.Datalen1.Trim()); cmd_buffer.Data_checksum1 = DataCheck_sum(cmd_buffer.Data1.Trim()); string mag = cmd_buffer.Buf(); sendData = HexStringToByteArray(mag); Thread.Sleep(300); serialPort.Write(sendData, 0, sendData.Length); } } else { Pub.MessageBoxShow(Pub.GetResText(formCode, "Error01", ""), MessageBoxIcon.Error);; } progBar.Value = (a + 1) * 100 / CardList.Count; lblMsg.Text = ItemTAG5.Text + " " + (a + 1).ToString() + " / " + CardList.Count + " " + CardNo + "[" + CategoryName + "]" + "[" + VarietiesName + "]"; Application.DoEvents(); } post_DataReceived(false); } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { RefreshMsg(Pub.GetDateDiffTimes(StartTime, DateTime.Now, true), true); refreshForm(true); } ExecItemTAG2(); if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } db.WriteSYLog(this.Text, CurrentTool, info); }
protected void ExecMacOprt(byte flag, byte dataFlag) { currOprt = CurrentTool; TConnInfoNewMJ conn; bool state; string msg = ""; string MacMsg = ""; string SysID = ""; bool IsError = false; if (!InitMacList()) { return; } IsExec = true; if (dataFlag == 1) { upDoorInfo.Clear(); DataTableReader dr = null; try { TMJUpDoorInfo doorInfo; AccessV2API.TYPE_DoorBasic upInfo; byte DoorID; string DoorPassword = ""; for (int i = 0; i < connList.Count; i++) { conn = connList[i]; SysID = GetMacSysID(conn.MacSN.ToString()); dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003001, new string[] { "7", SysID })); while (dr.Read()) { doorInfo = new TMJUpDoorInfo(); doorInfo.MacSN = conn.MacSN; byte.TryParse(dr["MacDoorID"].ToString(), out DoorID); doorInfo.DoorID = DoorID; upInfo = new AccessV2API.TYPE_DoorBasic(); UInt32.TryParse(dr["MacDoorDelay"].ToString(), out upInfo.LockedDelay); UInt32.TryParse(dr["MacDoorInterval"].ToString(), out upInfo.Interval); DoorPassword = dr["MacDoorPassword"].ToString(); if (DoorPassword.Length >= 16) { upInfo.PasswordA = DoorPassword.Substring(0, 8); upInfo.PasswordB = DoorPassword.Substring(8, 8); } else { upInfo.PasswordA = "00000000"; upInfo.PasswordB = "00000000"; } doorInfo.DoorInfo = upInfo; upDoorInfo.Add(doorInfo); } } } catch (Exception E) { IsError = true; Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } } if (IsError) { return; } RefreshForm(false); DateTime start = new DateTime(); start = DateTime.Now; string ExecTimes = ""; for (int i = 0; i < connList.Count; i++) { conn = connList[i]; RefreshMsg(currOprt + "[" + conn.MacSN.ToString() + "]......"); DeviceObject.objMJNew.NewDevice(conn); state = ExecMacCommand(flag, conn.MacSN.ToString(), ref MacMsg); ExecTimes = " " + Pub.GetDateDiffTimes(start, DateTime.Now); if (MacMsg != "") { MacMsg = "[" + MacMsg + "]"; } SetMacResult(conn.MacSN.ToString(), state, MacMsg + GetErrMsg(state) + ExecTimes); msg = msg + GetMacMsg(conn.MacSN.ToString()) + ":" + MacMsg + GetErrMsg(state) + ";"; Application.DoEvents(); start = DateTime.Now; if (!IsExec) { break; } } db.WriteSYLog(this.Text, currOprt, msg); IsExec = false; RefreshForm(true); RefreshMsg(""); }
protected void ExecMacOprt(byte flag, bool IsMac) { currOprt = CurrentTool; QHKS.TConnInfo conn; SystemInfo.GetDataCount = 0; bool state; string msg = ""; string MacMsg = ""; if (!InitMacList(IsMac)) { return; } IsExec = true; string MacVer = ""; string tmp = ""; RefreshForm(false); DateTime start = new DateTime(); start = DateTime.Now; string ExecTimes = ""; for (int i = 0; i < connList.Count; i++) { conn = connList[i]; RefreshMsg(currOprt + "[" + connList[i].MacSN.ToString() + "]......"); DeviceObject.objKS.Init(ref conn); state = true; if (IsMac) { state = DeviceObject.objKS.SysDeviceInfoGet(ref MacVer); if (MacVer == null) { MacVer = ""; } if (state) { DeviceObject.objKS.InitMacVer(MacVer); SyncTime(); UpdateIsSupportAirCZ(conn.MacSN, conn.ConnType); } } if (state) { state = ExecMacCommand(flag, connList[i].MacSN, ref MacMsg); } ExecTimes = " " + Pub.GetDateDiffTimes(start, DateTime.Now); if (IsMac) { if (MacMsg != "") { MacMsg = "[" + MacMsg + "]"; } tmp = MacVer == "" ? "" : "(" + MacVer + ")"; SetMacResult(conn.MacSN, state, MacMsg + DeviceObject.objKS.ErrMsg + tmp + ExecTimes); msg = msg + GetMacMsg(conn.MacSN) + ":" + MacMsg + DeviceObject.objKS.ErrMsg + ";"; if (state) { SystemInfo.GetDataCount = SystemInfo.GetDataCount + 1; } } else if (state) { SetMacResult(conn.MacSN, state, Pub.GetResText(formCode, "MsgSaveSucceed", "") + ExecTimes); msg = msg + GetMacMsg(conn.MacSN) + ":" + Pub.GetResText(formCode, "MsgSaveSucceed", "") + MacMsg + ";"; } else { SetMacResult(conn.MacSN, state, Pub.GetResText(formCode, "MsgSaveFailed", "") + ExecTimes); msg = msg + GetMacMsg(conn.MacSN) + ":" + Pub.GetResText(formCode, "MsgSaveFailed", "") + MacMsg + ";"; } start = DateTime.Now; Application.DoEvents(); if (!IsExec) { break; } } if (SystemInfo.GetDataCount == connList.Count) { SystemInfo.IsGetData = true; } db.WriteSYLog(this.Text, currOprt, msg); IsExec = false; RefreshForm(true); RefreshMsg(""); }
protected override void ExecItemRefresh() { DateTime StartTime = DateTime.Now; contextMenu.Close(); int row = -1; RefreshMsg(StrReading); if (tabControl1.SelectedIndex == 0) { if (QuerySQL != "") { dispView.Report.DetailGrid.Recordset.QuerySQL = QuerySQL; try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } row = dispView.SelRowNo; dispView.Stop(); dispView.Start(); Application.DoEvents(); } catch (Exception E) { Pub.ShowErrorMsg(E, QuerySQL); } finally { if (row < dispView.RowCount) { dispView.SelRowNo = row; } else if (dispView.RowCount > 0) { dispView.SelRowNo = dispView.RowCount - 1; } } } SetReportTitle(dispView, tabPage1.Text); } else { if (QuerySQL1 != "") { dispView1.Report.DetailGrid.Recordset.QuerySQL = QuerySQL1; try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } row = dispView1.SelRowNo; //dispView1.Refresh(); dispView1.Stop(); dispView1.Start(); Application.DoEvents(); } catch (Exception E) { Pub.ShowErrorMsg(E, QuerySQL1); } finally { if (row < dispView1.RowCount) { dispView1.SelRowNo = row; } else if (dispView1.RowCount > 0) { dispView1.SelRowNo = dispView1.RowCount - 1; } } } SetReportTitle(dispView1, tabPage2.Text); } RefreshForm(true); RefreshMsg(StrReadEnd + Pub.GetDateDiffTimes(StartTime, DateTime.Now, true), true); }
protected void ExecMacDoorOprt(byte flag, byte dataFlag) { currOprt = CurrentTool; TMJDoorInfo doorInfo; QHKS.TMJConnInfo connInfo; bool state; string msg = ""; string MacMsg = ""; if (!InitMacDoorList()) { return; } IsExec = true; RefreshForm(false); DateTime start = new DateTime(); start = DateTime.Now; string ExecTimes = ""; DataTableReader dr = null; bool IsError = false; int index = 0; for (int i = 0; i < doorList.Count; i++) { doorInfo = doorList[i]; connInfo = doorInfo.ConnInfo; RefreshMsg(currOprt + "[" + connInfo.MacSN + " " + doorInfo.DoorID + ":" + doorInfo.DoorName + "]......"); if (dataFlag == 1) { doorPasswordList.Clear(); try { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003001, new string[] { "104", connInfo.MacSN })); index = 0; while (dr.Read()) { string[] pass = dr["MacDoorPassword"].ToString().Split(' '); if (pass.Length == 2) { doorPasswordList.Add(pass[0]); doorPasswordList.Add(pass[1]); } else { doorPasswordList.Add("000000"); doorPasswordList.Add("000000"); } index += 2; } } catch (Exception E) { IsError = true; Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } } if (IsError) { break; } DeviceObject.objMJ.Init(ref connInfo); state = ExecMacDoorCommand(flag, doorInfo, ref MacMsg); ExecTimes = " " + Pub.GetDateDiffTimes(start, DateTime.Now); if (MacMsg != "") { MacMsg = "[" + MacMsg + "]"; } SetMacDoorResult(doorInfo.DoorSysID, state, MacMsg + DeviceObject.objMJ.ErrMsg + ExecTimes); msg = msg + GetMacDoorMsg(doorInfo) + ":" + MacMsg + DeviceObject.objMJ.ErrMsg + ";"; Application.DoEvents(); start = DateTime.Now; if (!IsExec) { break; } } db.WriteSYLog(this.Text, currOprt, msg); IsExec = false; RefreshForm(true); RefreshMsg(""); }
protected override void ExecItemRefresh() { DateTime StartTime = DateTime.Now; RefreshMsg(StrReading); while (tabControl1.TabPages.Count > 0) { while (tabControl1.TabPages[0].Controls.Count > 0) { tabControl1.TabPages[0].Controls[0].Dispose(); } tabControl1.TabPages[0].Dispose(); } tabControl1.TabPages.Clear(); DataTableReader dr = null; DataTableReader dr1 = null; TabPage page; PictureBox pic; MemoryStream ms; int w; int h; int x = 0; int y = 0; try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003007, new string[] { "0" })); while (dr.Read()) { page = new TabPage(); page.Text = dr["MapName"].ToString(); page.Tag = dr["MapSysID"].ToString(); page.AutoScroll = true; page.Name = "tabPage" + tabControl1.TabPages.Count.ToString(); pic = new PictureBox(); pic.Name = "pic" + tabControl1.TabPages.Count.ToString(); pic.SizeMode = PictureBoxSizeMode.AutoSize; byte[] buff = (byte[])(dr["mapPic"]); if (buff.Length > 0) { ms = new MemoryStream(buff); pic.Image = Image.FromStream(ms); ms.Dispose(); } w = pic.Width; h = pic.Height; pic.SizeMode = PictureBoxSizeMode.Zoom; pic.Width = w; pic.Height = h; page.Controls.Add(pic); pic.Left = 0; pic.Top = 0; tabControl1.TabPages.Add(page); dr1 = db.GetDataReader(Pub.GetSQL(DBCode.DB_003007, new string[] { "8", page.Tag.ToString() })); while (dr1.Read()) { doorInfo = new TMapDoorInfo(dr1["MacDoorSysID"].ToString(), dr1["MacSN"].ToString(), dr1["MacDoorID"].ToString(), dr1["MacDoorName"].ToString()); int.TryParse(dr1["LocationX"].ToString(), out x); int.TryParse(dr1["LocationY"].ToString(), out y); doorInfo.X = x; doorInfo.Y = y; doorInfo.MacConnType = dr1["MacConnType"].ToString(); doorInfo.MacIPAddress = dr1["MacIPAddress"].ToString(); doorInfo.MacPort = dr1["MacPort"].ToString(); doorInfo.MacConnPWD = dr1["MacConnPWD"].ToString(); DrawMapDot(pic, x, y); } dr1.Close(); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; if (dr1 != null) { dr1.Close(); } dr1 = null; } RefreshForm(true); RefreshMsg(StrReadEnd + Pub.GetDateDiffTimes(StartTime, DateTime.Now, true), true); picW = new int[tabControl1.TabPages.Count]; picH = new int[tabControl1.TabPages.Count]; zoom = new double[tabControl1.TabPages.Count]; for (int i = 0; i < zoom.Length; i++) { picW[i] = tabControl1.TabPages[i].Controls[0].Width; picH[i] = tabControl1.TabPages[i].Controls[0].Height; zoom[i] = 1; } }
protected void ExecMacOprt(byte flag, bool IsMac) { currOprt = CurrentTool; bool state; string msg = ""; string MacMsg = ""; if (!InitMacList(IsMac)) { return; } IsExec = true; string tmp = ""; RefreshForm(false); DateTime start = new DateTime(); start = DateTime.Now; string ExecTimes = ""; txtMag.Text = ""; string url = ""; for (int i = 0; i < connList.Count; i++) { TConnInfoSEA conn = connList[i]; if (RegisterInfo.IsValid || RegisterInfo.IsTest) { if (RegisterInfo.EndDate < DateTime.Now) { MacMsg = RegisterInfo.StateText; break; } } url = "http://" + conn.NetIP + "/"; string body = ""; string urlTestConnt = "http://" + conn.NetIP + "/action/GetSysParam"; bool ret = DeviceObject.objFK623.POST_GetResponse(urlTestConnt, conn.NetName, conn.NetPassword, ref body); if (ret) { state = ExecMacCommand(flag, Convert.ToInt32(conn.MacSN), url, conn.NetName, conn.NetPassword, ref MacMsg); } else { state = false; } ExecTimes = " " + Pub.GetDateDiffTimes(start, DateTime.Now); if (IsMac) { if (MacMsg != "") { MacMsg = "[" + MacMsg + "]"; } tmp = DeviceObject.objFK623.SeaBodyStr(); SetMacResult(Convert.ToInt32(conn.MacSN), state, MacMsg + tmp + ExecTimes); msg = msg + GetMacMsg(Convert.ToInt32(conn.MacSN)) + ":" + MacMsg + DeviceObject.objFK623.SeaBodyStr() + ";"; } else if (state) { SetMacResult(Convert.ToInt32(conn.MacSN), state, Pub.GetResText(formCode, "MsgSaveSucceed", "") + ExecTimes); msg = msg + GetMacMsg(Convert.ToInt32(conn.MacSN)) + ":" + Pub.GetResText(formCode, "MsgSaveSucceed", "") + MacMsg + ";"; } else { SetMacResult(Convert.ToInt32(conn.MacSN), state, Pub.GetResText(formCode, "MsgSaveFailed", "") + ExecTimes); msg = msg + GetMacMsg(Convert.ToInt32(conn.MacSN)) + ":" + Pub.GetResText(formCode, "MsgSaveFailed", "") + MacMsg + ";"; } Application.DoEvents(); start = DateTime.Now; if (!IsExec) { break; } } db.WriteSYLog(this.Text, currOprt, msg); IsExec = false; RefreshForm(true); RefreshMsg(""); }