private void btnLogs_Click(object sender, EventArgs e) { try { tc_MainStockDetail.SelectedTab = tab_LogDetail; //Search all logs stockLog.Search(new pts_stock_log { log_action = string.Empty, log_user_cd = string.Empty, stock_field = string.Empty, }, DateTime.Now, DateTime.Now, false); dgvLogDetail.DataSource = stockLog.listStockLog; for (int i = 0; i < dgvLogDetail.Rows.Count; i++) { dgvLogDetail.Rows[i].HeaderCell.Value = (i + 1).ToString(); } if (dgvLogDetail.Rows.Count > 0) { tsStockDetailRows.Text = dgvLogDetail.Rows.Count.ToString(); } } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } }
/// <summary> /// Clear all fields /// </summary> private void ClearFields() { try { txtItemCD.Clear(); txtInvoice.Clear(); txtOrderNo.Clear(); txtInCharge.Clear(); txtPackingCD.Clear(); txtPackingQty.Clear(); txtStockInQty.Clear(); txtSupplierCD.Clear(); itemData.listItems.Clear(); stockData.listStockItems.Clear(); lbInchagre.Text = "User Incharge"; lbInchagre.BackColor = Color.FromKnownColor(KnownColor.ActiveCaption); lbItemName.Text = "Item Name"; lbItemName.BackColor = Color.FromKnownColor(KnownColor.ActiveCaption); lbItemTypeName.Text = "Item Type Name"; lbItemTypeName.BackColor = Color.FromKnownColor(KnownColor.ActiveCaption); lbSupplierName.Text = "Supplier Name"; lbSupplierName.BackColor = Color.FromKnownColor(KnownColor.ActiveCaption); } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } }
private void txtBarcode_KeyDown(object sender, KeyEventArgs e) { try { //When scan barcode or press Enter key if (e.KeyCode == Keys.Enter) { string[] barcode = txtBarcode.Text.Split(';'); //Get item number txtNoPlanItemCD.Text = barcode[0]; //Get invoice txtNoPlanInvoice.Text = barcode[3]; txtBarcode.Clear(); //Update grid and search stock item UpdateNoPlanGrid(true); //Calculator W/H qty of current item txtNoPlanWHQty.Text = dgvNoPlan.Rows.Cast <DataGridViewRow>() .Sum(x => Convert.ToDouble(x.Cells["packing_qty"].Value)).ToString(); } } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } }
private void btnDeletebox_Click(object sender, EventArgs e) { try { if (dgvMain.SelectedRows.Count <= 0) { return; } if (IsBoxMode) { if (CustomMessageBox.Question("Are you sure delete this box?" + Environment.NewLine + "Bạn có muốn xóa hộp dữ liệu này?") == DialogResult.No) { return; } tbl_part_box boxData = dgvMain.SelectedRows[0].DataBoundItem as tbl_part_box; int n = boxData.Delete(boxData.part_box_id); CustomMessageBox.Notice("Deleted box " + txtBoxID.Text + " !" + Environment.NewLine + "Đã xóa hộp " + txtBoxID.Text + " !"); } else { if (CustomMessageBox.Question("Are you sure delete this inspect?" + Environment.NewLine + "Bạn có muốn xóa hạng mục này?") == DialogResult.No) { return; } } } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } }
private void btnOpenBox_Click(object sender, EventArgs e) { try { if (dgvMain.SelectedRows.Count < 0) { return; } //OpenBox(dgvMain.SelectedRows[0].Index); tbl_part_box boxData = dgvMain.Rows[dgvMain.SelectedRows[0].Index].DataBoundItem as tbl_part_box; txtModel.Text = boxData.model_cd; txtInvoice.Text = boxData.invoice; txtLot.Text = boxData.part_box_lot; txtVender.Text = boxData.vender_cd; txtBoxID.Text = boxData.part_box_cd; txtPartName.Text = boxData.part_name; txtPurpose.Text = boxData.purpose_cmt; txtPartNumber.Text = boxData.part_number; txtQty.Text = boxData.part_box_qty.ToString(); LockTextBox(tbpMain, true); UpdateGridBox(boxData.part_box_cd, true); } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } }
private void dgvData_SelectionChanged(object sender, EventArgs e) { if (dgvData.SelectedCells.Count <= 0) { return; } stockoutData = dgvData.Rows[dgvData.SelectedCells[0].RowIndex].DataBoundItem as pts_stockout_log; try { planData.listPlan.Clear(); noplanData.listNoPlan.Clear(); requestData.listRequestItem.Clear(); planData.Search(new pts_plan { plan_cd = stockoutData.process_cd }); noplanData.Search(new pts_noplan { noplan_cd = stockoutData.process_cd }); requestData.Search(new pts_request_log { request_cd = stockoutData.process_cd }, false, false, false); UpdateProcessGrid(); } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } }
private void btnRegister_Click(object sender, EventArgs e) { try { isSet = false; listOut.Clear(); listPlan.Clear(); listPrint.Clear(); listStock.Clear(); listNoplan.Clear(); listStockOut.Clear(); if (cmbIssue.SelectedValue.ToString() == "30" && string.IsNullOrEmpty(txtComment.Text)) { CustomMessageBox.Error("Please write comment when scrap item"); return; } if (cmbIssue.SelectedValue.ToString() == "20") { OpenSet(dgvMainStockOut.SelectedCells[0].RowIndex); } else { if (CustomMessageBox.Question("Do you want stock-out this item?") == DialogResult.No) { return; } CreateListNoSet(); } } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } }
private void btnManualPrint_Click(object sender, EventArgs e) { try { if (printItem.CheckPrinterIsOffline(SettingItem.printerSName)) { CustomMessageBox.Notice("Printer is offline"); return; } listPrintItem.Clear(); if (dgvPrintList.SelectedRows.Count == 0) { CustomMessageBox.Notice("Please choose item first!"); return; } foreach (DataGridViewRow dr in dgvPrintList.SelectedRows) { listPrintItem.Add(dr.DataBoundItem as PrintItem); dr.DefaultCellStyle.BackColor = Color.Yellow; } if (printItem.PrintItems(listPrintItem, true)) { CustomMessageBox.Notice("Print items are completed!"); } } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } }
/// <summary> /// Delete stock item /// </summary> private void DeleteStock() { try { listStockLog.Clear(); //Get all old data of fields in stock item for (int i = 0; i < oldStockData.GetType().GetProperties().Length; i++) { stockLog = new pts_stock_log { log_action = "Delete", log_user_cd = UserData.usercode, stock_id = oldStockData.stock_id.ToString(), stock_field = oldStockData.GetType().GetProperties()[i].Name, before_value = oldStockData.GetType().GetProperties()[i].GetValue(oldStockData).ToString(), after_value = "Deleted" }; //Add logs item into list listStockLog.Add(stockLog); } int id = oldStockData.stock_id; int n = stockLog.AddMultiLog(listStockLog); //Delete stock data oldStockData.DeleteItem(); CustomMessageBox.Notice("Deleted item : " + id + " Successful!" + Environment.NewLine + "Update " + n + " logs!"); } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } }
//Handle UnauthorizedAccessException public static void HandleUnauthorizedAccessException(UnauthorizedAccessException ex) { CustomMessageBox.Error( ex.Message.Contains("The process cannot access the file") ? LangProvider.GetLang("FileIsInUse") : LangProvider.GetLang("UnauthorizedAccess"), LangProvider.GetLang("ExceptionOccurred")); }
private void btnSearchPreInput_Click(object sender, EventArgs e) { try { this.Cursor = Cursors.WaitCursor; stopWatch.Restart(); //search premac item from SQL premacData.Search(new pre_649 { item_number = txtItemNum.Text, supplier_cd = txtSupplierCode.Text, supplier_invoice = txtSupplierInvoice.Text, order_number = txtOrderNo.Text, po_number = txtPONo.Text, incharge = txtIncharge.Text }, dtpFromDate.Value, dtpToDate.Value, cbCheckDate.Checked); dgvPreInput.ColumnHeadersVisible = false; dgvPreInput.DataSource = premacData.listPremacItem; dgvPreInput.ColumnHeadersVisible = true; stopWatch.Stop(); tsTime.Text = stopWatch.Elapsed.ToString("s\\.ff") + " s"; } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } this.Cursor = Cursors.Default; UpdatePremacGrid(true); }
private void btnAdd_Click(object sender, EventArgs e) { try { txtPlanCD.Text = "plan-" + DateTime.Now.ToString("yyyyMMdd-HHmmss"); planData.Add(new pts_plan { plan_cd = txtPlanCD.Text, plan_usercd = txtUserCD.Text, model_cd = txtModelCD.Text, set_number = txtSetNumber.Text, destination_cd = des_cd, plan_qty = double.Parse(txtPlanQty.Text), plan_date = dtpPlanDate.Value, delivery_date = dtpDeliveryDate.Value, comment = txtComment.Text, }); CustomMessageBox.Notice("Add new plan successed!"); } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } UpdateGrid(false); }
private void btnStockOutReg_Click(object sender, EventArgs e) { try { int n = 0; //Add no-plan item into DB if (listNoPlan.Count > 0) { n = noplanData.AddMultiItem(listNoPlan); CustomMessageBox.Notice("Add " + n + " No-Planned item successed!"); } //Add stock-out logs into DB if (listStockOut.Count > 0) { n = stockOutData.AddMultiItem(listStockOut); outData.ExportCSV(outData.listOutputItem); CustomMessageBox.Notice("Add " + n + " Stock-Out logs!"); } //Update packing qty of stock item in DB foreach (pts_stock item in listStock) { item.UpdateItem(item); } //Update stock qty itemData.ListStockOutUpdateValue(outData.listOutputItem); CustomMessageBox.Notice("Register completed!"); ClearInspection(); } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } }
private void btnPremacImport_Click(object sender, EventArgs e) { try { //Set wait cursor when search data this.Cursor = Cursors.WaitCursor; //Start stopwatch for catch searching time stopWatch.Restart(); //Get list data from premac 6-4-9 file listPremac = premacData.GetListPremacItem(SettingItem.premacFile); dgvPreInput.DataSource = listPremac; //Search data SearchPremacFile(); //Rename file after get data //File.Move(SettingItem.premacFile, Path.ChangeExtension(SettingItem.premacFile, DateTime.Now.ToString("yyyyMMddHHmmss"))); //Stop stopwatch and show time stopWatch.Stop(); tsTime.Text = stopWatch.Elapsed.ToString("s\\.ff") + " s"; } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } this.Cursor = Cursors.Default; UpdatePremacGrid(true); }
private void btnPrintAll_Click(object sender, EventArgs e) { try { listPrintItems.Clear(); if (dgvPrint.Rows.Count == 0) { CustomMessageBox.Notice("Don't have item to print!"); return; } if (listPrint[0].CheckPrinterIsOffline(SettingItem.printerSName)) { CustomMessageBox.Notice("Printer is offline"); return; } foreach (DataGridViewRow dr in dgvPrint.Rows) { listPrintItems.Add(dr.DataBoundItem as PrintItem); dr.DefaultCellStyle.BackColor = Color.FromKnownColor(KnownColor.ActiveCaption); } if (listPrint[0].PrintItems(listPrintItems, false)) { CustomMessageBox.Notice("Print items are completed!"); } } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } }
private void btnDelete_Click(object sender, EventArgs e) { try { if (CustomMessageBox.Warring("This action is not undo" + Environment.NewLine + "Are you sure delete this item?") == DialogResult.No) { return; } int n = 0; if (rbtnItemCode.Checked) { n = ptsItem.Delete(ptsItem.item_id); } if (rbtnItemType.Checked) { n = ptsItemType.Delete(ptsItemType.type_id); } ClearFields(); GetCmbData(); UpdateGrid(true); CustomMessageBox.Notice("Delete " + n + " Item"); } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } }
private void txtUserCD_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { string temp = txtUserCD.Text; if (temp.Contains(";")) { temp = temp.Split(';')[0].Trim(); } if (temp.Length > 6) { txtUserCD.Text = temp.Substring(temp.Length - 6); } else { txtUserCD.Text = temp; } try { m_mes_user mUser = new m_mes_user(); lbUserName.Text = mUser.GetUser(txtUserCD.Text).user_name; lbUserName.BackColor = Color.Lime; pnlInspection.Visible = true; txtBarcode.Focus(); } catch (Exception ex) { txtUserCD.Focus(); lbUserName.Text = "User Name"; lbUserName.BackColor = Color.FromKnownColor(KnownColor.ActiveCaption); CustomMessageBox.Error("Wrong User Code!" + Environment.NewLine + "(" + ex.Message + ")"); } } }
/// <summary> /// Search order number /// </summary> /// <param name="itemNumber"></param> private void SearchSet(string itemNumber, string setNumber) { try { pre_649_order orderData = new pre_649_order(); orderData.Search(new pre_649_order { item_number = itemNumber, order_number = setNumber }); dgvMainStockOut.DataSource = orderData.listOrderItem; dgvMainStockOut.Columns["item_number"].HeaderText = "Item Number"; dgvMainStockOut.Columns["order_number"].HeaderText = "Order Number"; dgvMainStockOut.Columns["order_qty"].HeaderText = "Order Qty"; dgvMainStockOut.Columns["order_date"].HeaderText = "Order Date"; dgvMainStockOut.Columns["supplier_cd"].HeaderText = "Supplier Code"; if (!dgvMainStockOut.Columns.Contains("btnOpenSet")) { DataGridViewButtonColumn col = new DataGridViewButtonColumn(); col.Name = "btnOpenSet"; col.HeaderText = "Open Set"; col.Text = "Open"; col.UseColumnTextForButtonValue = true; dgvMainStockOut.Columns.Insert(0, col); } } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } }
protected override bool ProcessCmdKey(ref Message msg, Keys keyData) { if (keyData == Keys.F2) { try { //Press F2 for add new supplier supplierItem.AddSupplier(new pts_supplier { supplier_cd = txtSupplierCD.Text, supplier_name = txtSupplierName.Text, registration_user_cd = UserData.usercode, }); CustomMessageBox.Notice("New supplier has been added with supplier code : " + txtSupplierCD.Text + Environment.NewLine + "NSX mới được thêm vào với mã: " + txtSupplierCD.Text); txtSupplierCD.Clear(); errorProvider.SetError(txtSupplierCD, null); } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } txtBarcode.Focus(); return(true); } return(base.ProcessCmdKey(ref msg, keyData)); }
private void btnManualPrint_Click(object sender, EventArgs e) { try { if (printItem.CheckPrinterIsOffline(SettingItem.printerSName)) { CustomMessageBox.Notice("Printer is offline" + Environment.NewLine + "Máy in chưa kết nối!"); return; } listPrintItem.Clear(); if (dgvPrintList.SelectedRows.Count == 0) { CustomMessageBox.Notice("Please choose item first!" + Environment.NewLine + "Vui lòng chọn tem muốn in!"); return; } foreach (DataGridViewRow dr in dgvPrintList.SelectedRows) { listPrintItem.Add(dr.DataBoundItem as PrintItem); dr.DefaultCellStyle.BackColor = Color.Yellow; } if (printItem.PrintItems(listPrintItem, int.Parse(txtPrintLabelQty.Text))) { CustomMessageBox.Notice("Print " + txtPrintLabelQty.Text + " items are completed!" + Environment.NewLine + "Đã in " + txtPrintLabelQty.Text + " tem!"); } txtPrintLabelQty.Text = "1"; } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } }
private void btnPrintAll_Click(object sender, EventArgs e) { try { if (printItem.CheckPrinterIsOffline(SettingItem.printerSName)) { CustomMessageBox.Notice("Printer is offline" + Environment.NewLine + "Máy in chưa kết nối!"); return; } listPrintItem.Clear(); if (dgvPrintList.Rows.Count == 0) { CustomMessageBox.Error("Don't have item to print!" + Environment.NewLine + "Không có tem để in!"); return; } foreach (DataGridViewRow dr in dgvPrintList.Rows) { listPrintItem.Add(dr.DataBoundItem as PrintItem); dr.DefaultCellStyle.BackColor = Color.Lime; } if (printItem.PrintItems(listPrintItem, false)) { CustomMessageBox.Notice("Print items are completed!" + Environment.NewLine + "In hoàn tất!"); } } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } }
/// <summary> /// Sub Program Update data /// </summary> private void UpdateGrid(bool isSearch) { try { if (isSearch) { ptsissuecode.listIssueCode.Clear(); if (string.IsNullOrEmpty(cmbIssueCode.Text)) { ptsissuecode.GetListIssueCode(); } else { ptsissuecode = ptsissuecode.GetIssueCode(int.Parse(cmbIssueCode.Text)); ptsissuecode.listIssueCode.Add(ptsissuecode); } dgvIssueCode.DataSource = ptsissuecode.listIssueCode; dgvIssueCode.Columns["issue_cd"].HeaderText = "Issue Code"; dgvIssueCode.Columns["issue_name"].HeaderText = "Issue Name"; dgvIssueCode.Columns["registration_user_cd"].HeaderText = "Registration User"; dgvIssueCode.Columns["registration_date_time"].HeaderText = "Registration Date"; dgvIssueCode.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.DisplayedCells); } } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } }
private void btnDelete_Click(object sender, EventArgs e) { try { foreach (DataGridViewCell dc in dgvInspection.SelectedCells) { if (CustomMessageBox.Warring("Are you sure delete this item?") == DialogResult.Yes) { //Search item want to delete stockItem = dgvInspection.Rows[dc.RowIndex].DataBoundItem as pts_stock; var tempItem = (from x in listInputPremac where x.item_number == stockItem.item_cd && x.supplier_cd == stockItem.supplier_cd && x.supplier_invoice == stockItem.invoice && x.delivery_date == stockItem.stockin_date && x.delivery_qty == stockItem.stockin_qty select x); //Delete item from list listInputPremac.Remove(tempItem.FirstOrDefault()); listStockItem.Remove(stockItem); } } dgvInspection.DataSource = listStockItem; } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } UpdateInspectionGrid(); txtBarcode.Focus(); }
/// <summary> /// Update No plan tab grid /// </summary> /// <param name="isSearch">true: search stock item</param> private void UpdateNoPlanGrid(bool isSearch) { if (isSearch) { bool result = false; if (txtNoPlanSetNumber.ReadOnly) { //Search stock item with item code and invoice result = stockData.SearchItem(new pts_stock { item_cd = txtNoPlanItemCD.Text }); } else { //Search stock item with set number pre649Data.Search(new pre_649 { order_number = txtNoPlanSetNumber.Text }); result = stockData.SearchItem(new pts_stock { item_cd = pre649Data.listPremacItem[0].item_number }); } if (!result) { CustomMessageBox.Error("This stock item is not exist! Please check and try again!"); ClearNoPlan(); } } dgvNoPlan.DataSource = stockData.listStockItems; if (dgvNoPlan.Columns.Contains("order_no")) { dgvNoPlan.Columns.Remove("order_no"); } dgvNoPlan.Columns["stock_id"].HeaderText = "Stock ID"; dgvNoPlan.Columns["packing_cd"].HeaderText = "Packing Code"; dgvNoPlan.Columns["item_cd"].HeaderText = "Item Code"; dgvNoPlan.Columns["supplier_cd"].HeaderText = "Supplier Code"; //dgvNoPlan.Columns["order_no"].HeaderText = "Order Number"; dgvNoPlan.Columns["invoice"].HeaderText = "Invoice"; dgvNoPlan.Columns["stockin_date"].HeaderText = "Stock In Date"; dgvNoPlan.Columns["stockin_user_cd"].HeaderText = "Incharge"; dgvNoPlan.Columns["stockin_qty"].HeaderText = "Stock In Qty"; dgvNoPlan.Columns["packing_qty"].HeaderText = "Packing Qty"; dgvNoPlan.Columns["registration_user_cd"].HeaderText = "Reg User"; dgvNoPlan.Columns["registration_date_time"].HeaderText = "Reg Date"; if (dgvNoPlan.Rows.Count > 0) { //Calculator W/H qty of current item txtNoPlanWHQty.Text = dgvNoPlan.Rows.Cast <DataGridViewRow>() .Sum(x => Convert.ToDouble(x.Cells["packing_qty"].Value)).ToString(); tsRows.Text = dgvNoPlan.Rows.Count.ToString(); } else { tsRows.Text = "None"; txtNoPlanWHQty.Text = "0"; } }
private void btnLogsBack_Click(object sender, EventArgs e) { try { tc_MainStockDetail.SelectedTab = tab_StockDetail; } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } }
private void MainFrm_Load(object sender, EventArgs e) { try { btnDeletebox.Enabled = UserData.isadmin; } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } }
private void btnSearch_Click(object sender, EventArgs e) { try { UpdateGridSearch(true); } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } }
private void btnOK_Click_1(object sender, EventArgs e) { try { int n = 0; string messstring = string.Empty; #region Add And Update Supplier { if (editMode) { //CALL FUNTION UPDATE SUPPLIER n = ptssupllier.UpdateSuplier(new pts_supplier { supplier_cd = cmbSupplierCode.Text, supplier_name = txtSupplierName.Text, supplier_tel = txtSupplierTelephone.Text, supplier_fax = txtFaxNumber.Text, supplier_address = txtSupplierAddress.Text, registration_user_cd = UserData.usercode }); } else { //CALL FUNCTION ADD NEW SUPPLIER n = ptssupllier.AddSupplier(new pts_supplier { supplier_cd = cmbSupplierCode.Text, supplier_name = txtSupplierName.Text, supplier_tel = txtSupplierTelephone.Text, supplier_fax = txtFaxNumber.Text, supplier_address = txtSupplierAddress.Text, registration_user_cd = UserData.usercode }); } } #endregion ClearOK(); Getcmbdata(); UpdateGrid(true); cmbSupplierCode.Text = null; if (editMode) { messstring = "Update "; } else { messstring = "Add "; } CustomMessageBox.Notice(messstring + n + " Supplier Complete!"); } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } UnlockFields(false); }
private void btnClear_Click(object sender, EventArgs e) { try { ClearFields(); } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } }
private void MeasurementFrm_Load(object sender, EventArgs e) { try { GetCmb(); UpdateGrid(true); } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } }