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