private void cmdClearData_Click(object sender, EventArgs e) { try { ProductService service = new ProductService(); bool delete = service.deteData(); if (delete) { lblresultdb.Visible = true; lblresultdb.Text = "ź���������º��������"; } else { lblresultdb.Visible = true; lblresultdb.Text = "�������öź�������� ���ͧ�ҡ "; } } catch (Exception ex) { lblresultdb.Visible = true; lblresultdb.Text = "�������öź�������� ���ͧ�ҡ "+ex.Message; } }
private void cmdbeginCheck_Click(object sender, EventArgs e) { DocCheckProduct docCheckProduct = null; if (ibarcode.Equals("")) { docCheckProduct = new DocCheckProduct(); }else { ProductService service = new ProductService(); docCheckProduct =service.getDocCheckProductByCode(ibarcode); txtPCode.Text = docCheckProduct.Code; txtWarehouse.Text = docCheckProduct.Warehouse; txtLocation.Text = docCheckProduct.Location; } if (!txtPCode.Text.Trim().Equals("")) { docCheckProduct.Code = txtPCode.Text.Trim(); } else { MessageBox.Show("��س����͡��͡�Ţ����͡��� !!! ", "����"); txtPCode.Focus(); return; } if (!txtWarehouse.Text.Trim().Equals("")) { docCheckProduct.Warehouse = txtWarehouse.Text.Trim(); } else { MessageBox.Show("��س����͡��͡��ѧ�Թ��� !!! ", "����"); txtWarehouse.Focus(); return; } if (!txtLocation.Text.Trim().Equals("")) { docCheckProduct.Location = txtLocation.Text.Trim(); } else { MessageBox.Show("��س����͡��͡ʶҹ��� !!! ", "����"); txtLocation.Focus(); return; } frmDocCheckP21 _frmDocCheckP21 = new frmDocCheckP21(docCheckProduct); _frmDocCheckP21.Show(); this.Hide(); }
private void cmdsearch_Click(object sender, EventArgs e) { try { ProductService service = new ProductService(); IList<DocCheckProduct> docCheckProducts = new List<DocCheckProduct>(); docCheckProducts = service.getDocCheckProductByDCode(this.txtSearch.Text.Trim()); DataTable table = new DataTable(); if (docCheckProducts != null && docCheckProducts.Count != 0) { table = GetTable(docCheckProducts); DataSet ds = new DataSet(); ds.Tables.Add(table); dataGrid1.DataSource = ds.Tables["DocCheckProduct"]; FormatDgvProduct(); label2.Visible = true; label2.Text = "�ӹǹ���鹾� :" + docCheckProducts.Count + " ��¡��"; } else { MessageBox.Show("��辺������ !!! ", "����"); IList<DocCheckProduct> docCheckProductsnull = new List<DocCheckProduct>(); table = GetTable(docCheckProductsnull); label2.Visible = false; label2.Text = "�ӹǹ���鹾� : 0 ��¡��"; DataSet ds = new DataSet(); ds.Tables.Add(table); dataGrid1.DataSource = ds.Tables["DocCheckProduct"]; FormatDgvProduct(); } } catch (Exception ex) { } }
private void frmNewCheckP2_Load(object sender, EventArgs e) { if (!ibarcode.Equals("")) { ProductService service = new ProductService(); DocCheckProduct docCheckProduct = service.getDocCheckProductByCode(ibarcode); txtPCode.Text = docCheckProduct.Code; txtPCode.Enabled = false; txtWarehouse.Text = docCheckProduct.Warehouse; txtWarehouse.Enabled = false; txtLocation.Text = docCheckProduct.Location; txtLocation.Enabled = false; } }
private void cmdimport_Click(object sender, EventArgs e) { txtmsg.Visible = true; string line; IList<Product> products = new List<Product>(); try { if (!txtpath.Text.Equals("")) { if (File.Exists(path)) { txtmsg.Text = "���ѧ�Ӣ�������� ........."; StreamReader file = null; try { file = new StreamReader(path, Encoding.GetEncoding("windows-874")); int i = 0; Product product = null; ProductService service = new ProductService(); int j = 1; int count = 0; int x = 0; while ((line = file.ReadLine()) != null) { if (i != 0) { string[] words = line.Split('\t'); product = new Product(); product.Code = words[0]; product.BarCode = words[1]; product.Name = words[2]; product.Unit = words[3]; product.Price1 = words[4]; product.Price3 = words[5]; product.Price4 = words[6]; if (words[7] != null && !words[7].Equals("")) { product.CreateDate = Convert.ToDateTime(words[7]); } this.pBar1.Visible = true; this.pBar1.Value = x; x += 10; if (x > 100) x = 0; Product _product = service.getByBarCode(product.BarCode); if (_product == null) { bool save = service.saveProduct(product); if (save) { Console.WriteLine("Save Compate :" + product.ID); txtmsg.Visible = true; txtmsg.Text = "�Ӣ�������� ���º���� �ӹǹ : " + j + " ��¡��"; j++; } else { Console.WriteLine("Save Not Compate :" + product.ID); } } else if (checkdate(_product.CreateDate, product.CreateDate) == false) { // update bool update = service.updateProduct(product); if (update) { Console.WriteLine("update Compate :" + product.ID); txtmsg.Visible = true; txtmsg.Text = "�Ӣ�������� ���º���� �ӹǹ : " + j + " ��¡��"; j++; } else { Console.WriteLine("update Not Compate :" + product.ID); } } count++; //products.Add(product); } Console.WriteLine(line); Console.WriteLine(i); i++; } // insert product //ProductService service = new ProductService(); //int j = 1; //int count = 0; //int x = 0; //foreach (Product p in products) //{ // this.pBar1.Visible = true; // this.pBar1.Value = x; // x += 10; // if (x > 100) x = 0; // Product _product = service.getByBarCode(p.BarCode); // if (_product == null ) // { // //DateTime cdate = _product.CreateDate; // bool save = service.saveProduct(p); // if (save) // { // Console.WriteLine("Save Compate :" + p.ID); // txtmsg.Visible = true; // txtmsg.Text = "�Ӣ�������� ���º���� �ӹǹ : " + j + " ��¡��"; // j++; // } // else // { // Console.WriteLine("Save Not Compate :" + p.ID); // } // } // else if (checkdate(_product.CreateDate, p.CreateDate) == false) { // // update // bool update = service.updateProduct(p); // if (update) // { // Console.WriteLine("update Compate :" + p.ID); // txtmsg.Visible = true; // txtmsg.Text = "�Ӣ�������� ���º���� �ӹǹ : " + j + " ��¡��"; // j++; // } // else // { // Console.WriteLine("update Not Compate :" + p.ID); // } // } // count++; //} if (count == products.Count) { this.pBar1.Value = 0; this.pBar1.Visible = false; } else if (count == 0) { this.pBar1.Value = 0; this.pBar1.Visible = false; } txtmsg.Text = "�Ӣ�������� ������ : " + (j - 1) + " ��¡��"; } finally { if (file != null) file.Close(); } } else { txtmsg.Text = "�к���辺�����س���͡!!!"; } } else { MessageBox.Show("��س����͡�������Ѻ�Ӣ�������� !!! ", "����"); } } catch (Exception ex) { txtmsg.Visible = true; txtmsg.Text = "�������ö�Ӣ���������� ���ͧ�ҡ " + ex.Message; } }
private void FormTest_Load(object sender, EventArgs e) { ProductService service = new ProductService(); docCheckProductDetails = service.getDocCheckProductDetailByDCode("1"); table = GetTable(docCheckProductDetails); DataSet ds = new DataSet(); ds.Tables.Add(table); dataGrid2.DataSource = ds.Tables["DocCheckProductDetails"]; //FormatDgvProduct2(); TotalRecord = docCheckProductDetails.Count; double tmpPageCount = (double)TotalRecord / PageSize; PageCount = Convert.ToInt32(Math.Ceiling(tmpPageCount)); tsRecordCount.Text = TotalRecord.ToString() + " ��¡��"; CurrentPage = 1; RecordToDisplay = 0; ShowRecord(CurrentPage); FormatDgvProduct(); }
private void cmdSave_Click(object sender, EventArgs e) { ProductService service = new ProductService(); Product product = null; DocCheckProductDetail docCheckProductDetail = new DocCheckProductDetail(); if (this.docCheckProduct != null) { docCheckProductDetail.DocCheckProduct = this.docCheckProduct; mc4.DocCheckProduct _docCheckProduct = new mc4.DocCheckProduct(); _docCheckProduct = new DocCheckProduct(); _docCheckProduct = service.getDocCheckProductByCode(this.docCheckProduct.Code); if (_docCheckProduct == null) { bool saveDocCheck = service.saveDocCheckProduct(this.docCheckProduct); if (saveDocCheck) { Console.WriteLine("Save Compate :"); } } } else { MessageBox.Show("��س����͡�Ţ����͡��� !!! ", "����"); return; } if (!(this.txtBarCode.Text.Trim().Equals(""))) { product = service.getByBarCode(this.txtBarCode.Text.Trim()); if (product != null) { docCheckProductDetail.Product = product; } } else { MessageBox.Show("��س����͡������ !!! ", "����"); txtBarCode.Focus(); return; } if (!(this.txtNumber.Text.Trim().Equals(""))) { docCheckProductDetail.DocCheckProduct = this.docCheckProduct; docCheckProductDetail.Product = product; docCheckProductDetail.NumProduct = Convert.ToInt32(this.txtNumber.Text.Trim()); bool save = service.saveDocCheckProductDetail(docCheckProductDetail); if (save) { //MessageBox.Show("�ѹ�֡���º���� !!! ", "����"); lblmsg.Visible = true; lblmsg.Text = "�ѹ�֡���º��������"; clearData(); Console.WriteLine("Save Compate :"); } } else { MessageBox.Show("��س����͡��͡�ӹǹ�Ѻ !!! ", "����"); txtNumber.Focus(); return; } }
private void textBox1_GotFocus(object sender, EventArgs e) { string x = textBox1.Text; if (x == "1") { string barcode = ""; if (!txtBarCode.Text.Trim().Equals("")) { barcode = txtBarCode.Text.Trim(); } ProductService service = new ProductService(); Product product = service.getByBarCode(barcode); if (product != null) { txtPName.Text = product.Name; lblUnit.Text = product.Unit; lblmsg.Visible = false; txtNumber.Focus(); } else { txtPName.Text =""; lblUnit.Text = ""; lblmsg.Visible = true; lblmsg.Text = "��辺������"; txtBarCode.Focus(); } } }
private void loadData() { try { ProductService service = new ProductService(); IList<DocCheckProduct> docCheckProducts = new List<DocCheckProduct>(); docCheckProducts = service.getDocCheckProductAll(); DataTable table = new DataTable(); if (docCheckProducts != null && docCheckProducts.Count != 0) { table = GetTable(docCheckProducts); DataSet ds = new DataSet(); ds.Tables.Add(table); dataGrid1.DataSource = ds.Tables["DocCheckProduct"]; FormatDgvProduct(); label2.Visible = true; label2.Text = "�ӹǹ���鹾� :" + docCheckProducts.Count + " ��¡��"; } else { IList<DocCheckProduct> docCheckProductsnull = new List<DocCheckProduct>(); table = GetTable(docCheckProductsnull); label2.Visible = false; label2.Text = "�ӹǹ���鹾� : 0 ��¡��"; DataSet ds = new DataSet(); ds.Tables.Add(table); dataGrid1.DataSource = ds.Tables["DocCheckProduct"]; FormatDgvProduct(); } } catch (Exception ex) { } }
private void dataGrid1_CurrentCellChanged(object sender, EventArgs e) { string dCode = string.Empty; int row = dataGrid1.CurrentRowIndex; int col = dataGrid1.CurrentCell.ColumnNumber; int iRow; int iCol; DataTable myTable; bool gotoback = false; myTable = (DataTable)dataGrid1.DataSource; for (iRow = 0; iRow < myTable.Rows.Count; iRow++) { if (row == iRow) { for (iCol = 0; iCol < myTable.Columns.Count; iCol++) { dCode = Convert.ToString(dataGrid1[iRow, 1]); break; } } } if (col == 2) { ProductService productService = new ProductService(); DocCheckProduct docCheckProduct = productService.getDocCheckProductByCode(dCode); IList<DocCheckProductDetail> docCheckProductDetail = productService.getDocCheckProductDetailByDCode(dCode); IList<ProductExport> productExports = new List<ProductExport>(); ProductExport productExport; /* productExport = new ProductExport(); productExport.DCode = "�Ţ����͡���"; productExport.PCode = "���ʺ�����"; productExport.PName = "�����Թ���"; productExport.WereHouse = "��ѧ�Թ���"; productExport.Location = "ʶҹ���"; productExport.Blank = "��ҧ"; productExport.Number = "�ӹǹ�Ѻ"; productExports.Add(productExport);*/ foreach (DocCheckProductDetail d in docCheckProductDetail) { productExport = new ProductExport(); productExport.WereHouse = docCheckProduct.Warehouse;// ��ѧ�Թ��� productExport.Location = docCheckProduct.Location; // ʶҹ��� productExport.DCode = docCheckProduct.Code; // �����͡���� if (d != null) { if (d.Product != null) { productExport.PCode = d.Product.BarCode; // ���ʺ����� productExport.PName = d.Product.Name; productExport.Blank = ""; productExport.Unit = d.Product.Unit;// ˹��¹Ѻ } productExport.Number = Convert.ToString(d.NumProduct); } productExports.Add(productExport); } string[] rowString = new string[docCheckProductDetail.Count + 1]; /* string path = Path.GetDirectoryName( Assembly.GetExecutingAssembly().GetName().CodeBase) + "\\exportdata\\" + productExports[row].DCode + ".txt";*/ configDoc.Load(DbConnect.pathconfig); XmlNode nod = configDoc.GetElementsByTagName("add")[2]; string filePath = nod.Attributes["value"].Value; string path = filePath + dCode + ".txt"; File.Delete(path); int i = 0; foreach (ProductExport p in productExports) { rowString[i] = p.DCode + "\t"; rowString[i] += p.PCode + "\t"; //rowString[i] += p.PName + "\t"; rowString[i] += p.WereHouse + "\t"; rowString[i] += p.Location + "\t"; rowString[i] += p.Unit + "\t"; rowString[i] += p.Number; using (StreamWriter writer = new StreamWriter(path, true)) { writer.WriteLine(rowString[i]); } i++; } if (productExports.Count == i) { MessageBox.Show("�Ӣ������͡���º�������� !!! ", "����"); } } }
private void frmTest3_Load(object sender, EventArgs e) { ProductService service = new ProductService(); docCheckProductDetails = service.getDocCheckProductDetailByDCode("1"); table = GetTable(docCheckProductDetails); DataSet ds = new DataSet(); ds.Tables.Add(table); dataGrid1.DataSource = ds.Tables["DocCheckProductDetails"]; FormatDgvProduct(); }
private void Form1_Load(object sender, EventArgs e) { //bool used = checkPermission(); bool used = true; if (used == false) { MessageBox.Show("��سҵ�Ǩ�ͺ�Է�ԡ�������������!!! ", "����"); Application.Exit(); } else { try { ProductService service = new ProductService(); checkPermission(); /* string pathconfig = Path.GetDirectoryName( Assembly.GetExecutingAssembly().GetName().CodeBase) + "\\Config.xml";*/ //lblconfig.Text = DbConnect.pathconfig; // Product product = service.getById(1); } catch (Exception ex) { //lblmsg.Text = "�������ö�Դ��Ͱҹ�������� ���ͧ�ҡ"+ex.Message; } } }
private void dataGrid1_CurrentCellChanged(object sender, EventArgs e) { try { int row = dataGrid1.CurrentRowIndex; int col = dataGrid1.CurrentCell.ColumnNumber; int iRow; int iCol; DataTable myTable; bool gotoback = false; string pname = ""; myTable = (DataTable)dataGrid1.DataSource; for (iRow = 0; iRow < myTable.Rows.Count; iRow++) { if (row == iRow) { for (iCol = 0; iCol < myTable.Columns.Count; iCol++) { dcode = Convert.ToString(dataGrid1[iRow, 2]); pcode = Convert.ToString(dataGrid1[iRow, 3]); num = Convert.ToInt32(dataGrid1[iRow, 1]); pname = Convert.ToString(dataGrid1[iRow, 0]); pid = Convert.ToString(dataGrid1[iRow, 6]); break; } } } if (col == 5) { if (MessageBox.Show("�س��ͧź�Թ���:" + pname + " ��������� ?", "����ѹ", MessageBoxButtons.YesNo, MessageBoxIcon.None, MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes) { ProductService service = new ProductService(); bool deleteDetail = service.deleteDocCheckProductDetail(pid,dcode, pcode); if (deleteDetail) { cmdsearch_Click(sender, e); MessageBox.Show("ź���������º�������� !!! ", "����"); } } } else { } checkgrid = true; txtNum.Text = Convert.ToString(this.num); } catch (Exception ex) { } /// }
private void cmdsave_Click(object sender, EventArgs e) { if (checkgrid == false) { return; } try { ProductService service = new ProductService(); bool savedit = service.editNumberCheckProduct(this.pid,this.dcode, this.pcode,Convert.ToInt32(txtNum.Text.Trim())); if (savedit) { //MessageBox.Show("������º���� !!! ", "����"); Console.WriteLine("Edit Sucsess"); cmdsearch_Click(sender, e); } CurrentPage = cpag; if (CurrentPage < 1) { CurrentPage = 1; RecordToDisplay = 0; } else { RecordToDisplay = (CurrentPage - 1) * PageSize; } ShowRecord(CurrentPage); } catch (Exception ex) { } }
private void dataGrid1_CurrentCellChanged(object sender, EventArgs e) { string barCode = string.Empty; int row = dataGrid1.CurrentRowIndex; int col = dataGrid1.CurrentCell.ColumnNumber; int iRow; int iCol; DataTable myTable; bool gotoback = false; myTable = (DataTable)dataGrid1.DataSource; for (iRow = 0; iRow < myTable.Rows.Count; iRow++) { if (row == iRow) { for (iCol = 0; iCol < myTable.Columns.Count; iCol++) { barCode = Convert.ToString(dataGrid1[iRow, 1]); break; } } } if (col == 2) { if (MessageBox.Show("�س��ͧ���ź�������Ţ��� :" + barCode + " ��������� ?", "����ѹ", MessageBoxButtons.YesNo, MessageBoxIcon.None, MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes) { ProductService service = new ProductService(); bool delete = service.deleteDocCheckProduct(barCode); if (delete) { MessageBox.Show("ź���������º�������� !!! ", "����"); Console.WriteLine(" Delete Sueess"); loadData(); return; } } else { return; } } }