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