public static void importTrade(Trade trade)
{
DataSet1.TradeDataTable tradeRows = GetTradeRows();
DataRow[] dataRows = tradeRows.Select();
int number = 0;
if (dataRows.Length > 0)
{
int size = dataRows.Length;
for (int i = 0; i < size; i++)
{
if ((int)dataRows[i][15] > number)
{
number = (int)dataRows[i][15];
}
}
number++;
}
DataRow dataRow = tradeRows.NewRow();
dataRow[0] = trade.category;
dataRow[1] = trade.transaction;
dataRow[2] = trade.deadline;
dataRow[3] = trade.orderer;
dataRow[4] = trade.demander;
dataRow[5] = trade.contents;
dataRow[6] = trade.product;
dataRow[7] = trade.OS;
dataRow[8] = trade.quantity;
dataRow[9] = trade.price;
dataRow[10] = trade.manager;
dataRow[11] = trade.inspection;
dataRow[12] = trade.bill;
dataRow[13] = trade.modify;
dataRow[14] = trade.registrar;
dataRow[15] = number;
tradeRows.Rows.Add(dataRow);
tradeRows.WriteXml(filepath + "trade_data.xml");
DirectoryInfo di = new DirectoryInfo(filepath + '/' + dataRow[15].ToString());
if (!di.Exists)
{
di.Create();
}
else
{
di.Delete(true);
di.Create();
}
return;
}
private void BtnUpload_Click(object sender, EventArgs e)
{
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = "Excel Files (*.xls)|*.xls";
DialogResult dialogResult = openFileDialog.ShowDialog();
if (dialogResult == DialogResult.OK)
{
string filepath = openFileDialog.FileName;
FileStream stream = File.Open(filepath, FileMode.Open, FileAccess.Read);
IExcelDataReader excelReader = ExcelReaderFactory.CreateReader(stream);
DataSet1.TradeDataTable tradeRows = SendClass.GetTradeRows();
DataSet result = excelReader.AsDataSet();
for (int i = 1; i < result.Tables[0].Rows.Count; i++)
{
DataRow dataRow = tradeRows.NewRow();
dataRow[0] = result.Tables[0].Rows[i][1];
string transaction = result.Tables[0].Rows[i][2].ToString();
dataRow[1] = new DateTime(int.Parse(transaction.Substring(0, 4)),
int.Parse(transaction.Substring(5, 2)), int.Parse(transaction.Substring(8, 2)));
string deadline = result.Tables[0].Rows[i][3].ToString();
dataRow[2] = new DateTime(int.Parse(deadline.Substring(0, 4)),
int.Parse(deadline.Substring(5, 2)), int.Parse(deadline.Substring(8, 2)));
dataRow[3] = result.Tables[0].Rows[i][5];
dataRow[4] = result.Tables[0].Rows[i][6];
dataRow[5] = result.Tables[0].Rows[i][7];
dataRow[6] = result.Tables[0].Rows[i][8];
dataRow[7] = result.Tables[0].Rows[i][9];
dataRow[8] = int.Parse(result.Tables[0].Rows[i][10].ToString());
dataRow[9] = int.Parse(result.Tables[0].Rows[i][11].ToString());
dataRow[10] = result.Tables[0].Rows[i][12];
string inspection = result.Tables[0].Rows[i][13].ToString();
if (inspection.Length > 0)
{
dataRow[11] = new DateTime(int.Parse(inspection.Substring(0, 4)),
int.Parse(inspection.Substring(5, 2)), int.Parse(inspection.Substring(8, 2)));
}
else
{
dataRow[11] = new DateTime();
}
string bill = result.Tables[0].Rows[i][14].ToString();
if (bill.Length > 0)
{
dataRow[12] = new DateTime(int.Parse(bill.Substring(0, 4)),
int.Parse(bill.Substring(5, 2)), int.Parse(bill.Substring(8, 2)));
}
else
{
dataRow[12] = new DateTime();
}
dataRow[13] = new DateTime();
dataRow[14] = result.Tables[0].Rows[i][15];
dataRow[15] = int.Parse(result.Tables[0].Rows[i][0].ToString());
tradeRows.Rows.Add(dataRow);
}
tradeRows.WriteXml(SendClass.filepath + "trade_data.xml");
}
}