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