private void workerTM_DoWork(object sender, DoWorkEventArgs e) { foreach (DataRow row in uploadTable.Rows) { string chaseno = row.ItemArray[0].ToString(); if (chaseno.StartsWith("CM")) { string instockdate = ImportXls2007Util.ParseDateTime(row.ItemArray[3].ToString()).ToString("yyyy/MM/dd"); string query = string.Format("update tb_betamould set tm_instockdate = '{0}', tm_st_code = 'S' where tm_chaseno = '{1}'", instockdate, chaseno); DataService.GetInstance().ExecuteNonQuery(query); } else { string checkdate = row.ItemArray[1].ToString(); string instockremarks = row.ItemArray[2].ToString(); string instockdate = row.ItemArray[3].ToString(); string datetime = DateTime.Today.ToString("yyyy/MM/dd"); checkdate = ImportXlsUtil.ParseDateTime(checkdate).ToString("yyyy/MM/dd"); if (checkdate == "0001/01/01") { checkdate = ""; } instockdate = ImportXlsUtil.ParseDateTime(instockdate).ToString("yyyy/MM/dd"); if (instockdate == "0001/01/01") { instockdate = ""; } string query = string.Format("update tb_betamould set tm_instockdate = '{0}', tm_st_code = 'S', tm_checkdate = '{1}', tm_instockremarks = '{2}', tm_moulditemviewer = 'Yes' where tm_chaseno = '{3}'", instockdate, checkdate, instockremarks, chaseno); DataService.GetInstance().ExecuteNonQuery(query); } } }
private void btnUploadTM_Click(object sender, EventArgs e) { OpenFileDialog ofd = new OpenFileDialog() { Filter = "Excel Files |*.xls;*.xlsx" }; if (ofd.ShowDialog() == DialogResult.OK) { filename = ofd.FileName; uploadTable = new DataTable(); uploadTable = ofd.FileName.EndsWith(".xls") ? ImportXlsUtil.TranslateToTable(ofd.FileName) : ImportXls2007Util.TranslateToTable(ofd.FileName); DataTable tmptable = new DataTable(); tmptable.Columns.Add("Chase No."); tmptable.Columns.Add("Check Date"); tmptable.Columns.Add("In Stock Remarks"); tmptable.Columns.Add("In Stock Date"); foreach (DataRow row in uploadTable.Rows) { string chaseno = row.ItemArray[0].ToString(); if (chaseno.StartsWith("CM")) { string instockdate = ImportXls2007Util.ParseDateTime(row.ItemArray[3].ToString()).ToString("yyyy/MM/dd"); tmptable.Rows.Add(new object[] { chaseno, "", "", instockdate }); } else { string checkdate = ImportXlsUtil.ParseDateTime(row.ItemArray[1].ToString()).ToString("yyyy/MM/dd"); if (checkdate == "0001/01/01") { checkdate = ""; } string instockremarks = row.ItemArray[2].ToString(); string instockdate = ImportXlsUtil.ParseDateTime(row.ItemArray[3].ToString()).ToString("yyyy/MM/dd"); tmptable.Rows.Add(new object[] { chaseno, checkdate, instockremarks, instockdate }); } } frmUploadConfirm form = new frmUploadConfirm(tmptable); form.ShowDialog(); if (form.DialogResult == DialogResult.OK) { if (!workerTM.IsBusy) { this.Cursor = Cursors.WaitCursor; dgvPreview.Cursor = Cursors.WaitCursor; dgvResult.Cursor = Cursors.WaitCursor; workerTM.RunWorkerAsync(); } else { MessageBox.Show("Using by other process"); } } } }