public static void ExcelSpreadOperation()
{
ExcelOperation excelOperation = new ExcelOperation();
string path = @"C:\Users\Pratap\Desktop\EIGS_Sample3.xlsx";
excelOperation.OpenExcelBook(path);
excelOperation.SetWorksheet("Sheet1");
//excelOperation.DoSomeOperation();
//excelOperation.DoSomeOperationFour();
//excelOperation.DoSomeOperationTwo();
//excelOperation.SetWorksheet("Sheet2");
// excelOperation.DoSomeOperationThree();
//excelOperation.ProtectUnprotectSheet(null);
// excelOperation.MergeAreaCheck(null);
// excelOperation.GetAddrCheck();
DateTimeCheck();
}
private void onClickExportExcel(object sender, RoutedEventArgs e)
{
if (ItemNow == null)
{
DialogWindow.Show("Ви не вибрал статистику.", "Відмова", DialogButtons.Ok, DialogStyle.Error);
return;
}
var DirectoryDialog = new FolderBrowserDialog();
if (DirectoryDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
string Directory = DirectoryDialog.SelectedPath;
if (!ExcelOperation.IsValidTemplate(ExcelTemplate.Rent))
{
DialogWindow.Show("Статистика про оренду тарнспортнів не буде експортована. Шаблон не було знайдено.", "Відмова", DialogButtons.Ok, DialogStyle.Error);
}
if (!ExcelOperation.IsValidTemplate(ExcelTemplate.Balance))
{
DialogWindow.Show("Статистика про операцій з рахунком не буде експортована. Шаблон не було знайдено.", "Відмова", DialogButtons.Ok, DialogStyle.Error);
}
ExcelOperation.Export(ItemNow, Directory);
DialogWindow.Show("Ви успішно експортували статистику.", "Успішно", DialogButtons.Ok, DialogStyle.Information);
}
}
protected void btnExport_Click(object sender, EventArgs e)
{
try
{
if (gdFormularName.Rows.Count == 0)
{
MessageBoxShow("导出没有数据！");
return;
}
Hashtable ht = new Hashtable();
if (ddlgoupLibrary.SelectedValue == "-1")
{
ht.Add("Dictlabdeptid", null);
}
else
{
ht.Add("Dictlabdeptid", ddlgoupLibrary.SelectedValue);
}
ht.Add("strKey", TextUtility.ReplaceText(ttbSearch.Text.Trim()) == "" ? null : TextUtility.ReplaceText(ttbSearch.Text.Trim()));
List <Dictruleformular> ruleformularlist = loginservice.GetLoginDictruleformularresultList();
String sheetname = DateTime.Now.ToString("yyyy-MM-dd");
String filename = DateTime.Now.ToString("yyyyMMdd_hhmmss");
SortedList sortlist = new SortedList(new MySort());
sortlist.Add("Dictrulecode", "规则代码");
sortlist.Add("Formularname", "公式名称");
ExcelOperation <Dictruleformular> .ExportListToExcel(ruleformularlist, sortlist, filename, sheetname);
}
catch (Exception)
{
MessageBoxShow("导出出错，请联系管理员！");
}
}
private void MaterialCreatetForm_DragDrop(object sender, DragEventArgs e)
{
string[] s = (string[])e.Data.GetData(DataFormats.FileDrop, false);
int i;
for (i = 0; i < s.Length; i++)
{
string str = s[i];
if (File.Exists(str))
{
DataTable table;
this.Cursor = Cursors.WaitCursor;
if (!ExcelOperation.ReadTemplate(startRow, startCol, str, out table))
{
MessageBox.Show("文件导入失败");
}
else
{
ExcelOperation.RemoveEmpty(ref table);
myDataGridView1.DataSource = null;
myDataGridView1.DataSource = table;
}
this.Cursor = Cursors.Default;
}
}
}
protected void btnExport_Click(object sender, EventArgs e)
{
try
{
if (gdDiagnosis.Rows.Count == 0)
{
MessageBoxShow("导出没有数据！");
return;
}
Hashtable ht1 = new Hashtable();
ht1.Add("strKey", TextUtility.ReplaceText(ttbSearch.Text.Trim()) == "" ? null : TextUtility.ReplaceText(ttbSearch.Text.Trim()));
List <Dictdiagnosis> newslist = diagnosisservice.GetDictdiagnosisLst(ht1);
String sheetname = DateTime.Now.ToString("yyyy-MM-dd");
String filename = DateTime.Now.ToString("yyyyMMdd_hhmmss");
SortedList sortlist = new SortedList(new MySort());
sortlist.Add("Diagnosisname", "诊断名称");
ExcelOperation <Dictdiagnosis> .ExportListToExcel(newslist, sortlist, filename, sheetname);
}
catch (Exception)
{
MessageBoxShow("导出出错，请联系管理员！");
}
}
/// <summary>
/// Initializes a new instance of the <see cref="Credentials"/> class
/// </summary>
public Credentials()
{
ExcelOperation.PopulateInCollection(@"C:\Users\sidth\Desktop\DataDriven\Hybrid.xlsx");
userName = ExcelOperation.ReadData(1, "userName");
pass = ExcelOperation.ReadData(1, "password");
ePass = ExcelOperation.ReadData(1, "emailPass");
}
private void 确定ToolStripMenuItem_Click(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
DataForm form2 = new DataForm(sqlProcessor, toolStripTextBox1.Text, toolStripComboBox1.Text, toolStripComboBox2.Text, 0.65);
if (form2.ShowDialog() == DialogResult.OK)
{
DataRow row = form2._row;
DataTable dt = (DataTable)myDataGridView1.DataSource;
DataRow dr = dt.NewRow();
foreach (Map map in param.Maps)
{
if (map.Value != "")
{
try
{
if (dr.Table.Columns.Contains(map.Value))
{
dr[map.Value] = row[map.Value].ToString();
}
}
catch (Exception e1)
{
MessageBox.Show(e1.Message);
}
}
}
dt.Rows.Add(dr);
ExcelOperation.RemoveEmpty(ref dt);
}
this.Cursor = Cursors.Default;
}
public void FillPayrollDetails()
{
string payrollId = GenericHelper.RandomPayRollNo();
ExcelOperation.AddData("TestData4", payrollId, "TC4_AddingThePackageToTheEmployee");
PayRollID.SendKeys(payrollId);
var eleImg = driver.FindElement(By.XPath(".//*[@id='ddmPayCycleID_trMain']/td[2]/img"));
IJavaScriptExecutor executor = (IJavaScriptExecutor)driver;
executor.ExecuteScript("var eleImg=arguments[0];setTimeout(function(){eleImg.click();},100)", eleImg);
// Selects first item fromn Pay Cycle Description drop down
var eleDropDown = driver.FindElement(By.XPath(".//*[@id='divMenuddmPayCycleID']/table/tbody/tr[2]/td[1]"));
IJavaScriptExecutor executor1 = (IJavaScriptExecutor)driver;
executor1.ExecuteScript("var eleDropDown=arguments[0];setTimeout(function(){eleDropDown.click();},100)", eleDropDown);
driver.Manage().Timeouts().ImplicitWait = TimeSpan.FromSeconds(30);
Thread.Sleep(2000);
//Click on the AddButton
var eleAddButton = driver.FindElement(By.XPath(".//*[@id='wucButtons_cmdAddEnabled']"));
IJavaScriptExecutor executorAddButton = (IJavaScriptExecutor)driver;
executorAddButton.ExecuteScript("var eleAddButton=arguments[0];setTimeout(function(){eleAddButton.click();},100)", eleAddButton);
driver.Manage().Timeouts().ImplicitWait = TimeSpan.FromSeconds(30);
Thread.Sleep(2000);
// Clicks on Save button
GenericHelper.AllScreenShot(driver);
var eleSaveButton = driver.FindElement(By.Id("wucButtons_cmdSaveEnabled"));
IJavaScriptExecutor executorSaveButton = (IJavaScriptExecutor)driver;
executorSaveButton.ExecuteScript("var eleSaveButton=arguments[0];setTimeout(function(){eleSaveButton.click();},100)", eleSaveButton);
}
protected void btnExcel_Click(object sender, EventArgs e)
{
try
{
if (gvList.Rows.Count == 0)
{
MessageBoxShow("没有导出的数据", MessageBoxIcon.Information);
return;
}
Hashtable ht = new Hashtable();
ht.Add("DictlabId", dictlabId);
ht.Add("strKey", TextUtility.ReplaceText(btSearch.Text.Trim()) == "" ? null : TextUtility.ReplaceText(btSearch.Text.Trim()));
ht.Add("IsActive", chkActive.Checked ? "1" : "0");
List <Dictlabandtest> dictlabandtestIList = new DictlabandtestService().GetDictlabandtestByDictlabId(ht);
if (dictlabandtestIList.Count > 0)
{
String sheetname = DateTime.Now.ToString("yyyy-MM-dd");
String filename = DateTime.Now.ToString("yyyyMMdd_hhmmss");
SortedList sortlist = new SortedList(new MySort());
sortlist.Add("Labname", "分点名称");
sortlist.Add("Testname", "套餐名称");
sortlist.Add("Createdate", "创建时间");
sortlist.Add("Issendouttest", "是否外包");
sortlist.Add("Isactive", "是否可用");
List <Dictlabandtest> dictlabandtestIListTo = new List <Dictlabandtest>();
for (int i = 0; i < dictlabandtestIList.Count; i++)
{
Dictlabandtest dictlaband = new DictlabandtestService().GetDictDictlabandtestById(Convert.ToDouble(dictlabandtestIList[i].Dictlabandtestid));
if (dictlaband.BoolIsactive == true)
{
dictlaband.Isactive = "是";
}
else
{
dictlaband.Isactive = "否";
}
if (dictlaband.BoolIssendouttest == true)
{
dictlaband.Issendouttest = "是";
}
else
{
dictlaband.Issendouttest = "否";
}
dictlaband.Labname = dictlabandtestIList[i].Labname;
dictlaband.Testname = dictlabandtestIList[i].Testname;
dictlabandtestIListTo.Add(dictlaband);
}
ExcelOperation <Dictlabandtest> .ExportListToExcel(dictlabandtestIListTo, sortlist, filename, sheetname);
}
else
{
MessageBoxShow("没有导出的数据", MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBoxShow(ex.Message, MessageBoxIcon.Error);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
ExcelOperation mExcelOperation = new ExcelOperation();
if (mExcelOperation.colsCount == 42)
{
bool bool_ExcelImpoert = mExcelOperation.ExcelImportWithLayoutCheck(this.Application["filePath"].ToString(), "Sheet1");
if (bool_ExcelImpoert)
{
mExcelOperation.TraceFromExcel(DropDownList1.SelectedItem.Value);
lbl_DateInfo.Text = this.Application["filePath"].ToString().Substring(0, 8);
}
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "setECharts2", "setECharts2('" +
Data2Trace.values_ECharts1_1 + "','"
+ Data2Trace.values_ECharts1_2 + "','"
+ Data2Trace.values_ECharts1_3 + "','"
+ Data2Trace.values_ECharts1_4 + "','"
+ Data2Trace.values_ECharts2_1 + "','"
+ Data2Trace.values_ECharts2_2 + "','"
+ Data2Trace.values_ECharts2_3 + "','"
+ Data2Trace.values_ECharts2_4 + "','"
+ Data2Trace.values_ECharts3_1 + "','"
+ Data2Trace.values_ECharts3_2 + "','"
+ Data2Trace.values_ECharts3_3 + "','"
+ Data2Trace.values_ECharts3_4 + "')", true);
Label1.Text = this.Application["filePath"].ToString() + DropDownList1.SelectedItem.Value;
}
}
//账单头信息导出
protected void btnExcel_Click(object sender, EventArgs e)
{
try
{
if (gvList.Rows.Count <= 0 || gvList.SelectedRowIndexArray.Length <= 0)
{
return;
}
//获取选中项
string ids = GetGridViewIDs();
Hashtable ht = new Hashtable();
ht["status"] = (int)ParamStatus.BillheadStatus.PrepareOut;
ht["billheadids"] = ids;
List <Billhead> list = billheadService.SelectBillheadExcel(ht).ToList();
//设置导出文件列头信息
SortedList sortedList = new SortedList(new MySort());
sortedList.Add("Billheadid", "账单号");
sortedList.Add("Customername", "客户");
sortedList.Add("Createdate", "出账时间");
sortedList.Add("Totalstandardprice", "标准收费");
sortedList.Add("Totalfinalprice", "实际收费");
sortedList.Add("Salename", "业务员");
string filename = "已出账账单信息" + DateTime.Now.Date.ToString("yyyyMMdd");
ExcelOperation <Billhead> .ExportListToExcel(list, sortedList, filename, "sheet1");
}
catch (Exception ex)
{
MessageBoxShow(ex.Message, MessageBoxIcon.Error);
}
}
//导出
protected void btnExcel_Click(object sender, EventArgs e)
{
try
{
if (gvList.Rows.Count <= 0 || gvList.SelectedRowIndexArray.Length <= 0)
{
return;
}
string ordernums = GetGridViewIds();
//获得选中的账单头表记录
List <Billhead> list = headService.SelectBillHeadListByids(ordernums).ToList <Billhead>();
//设置导出文件列头信息
SortedList sortedList = new SortedList(new MySort());
sortedList.Add("Billheadid", "账单号");
sortedList.Add("Realname", "姓名");
sortedList.Add("Duedate", "收费日期");
sortedList.Add("Ordernum", "体检流水号");
sortedList.Add("Testname", "体检项目");
sortedList.Add("Testcount", "项目数量");
sortedList.Add("Totalstandardprice", "标准收费");
sortedList.Add("Totalgrouprprice", "分点收费");
sortedList.Add("Totalcontractprice", "应收金额");
sortedList.Add("Totalfinalprice", "实收金额");
sortedList.Add("Status", "账单状态");
sortedList.Add("Selfremark", "财务说明");
sortedList.Add("Remark", "财务备注");
if (list.Count > 0)
{
for (int i = 0; i < list.Count; i++)
{
if (list[i].Status == "1")
{
list[i].Status = "已接收";
}
else if (list[i].Status == "0")
{
list[i].Status = "预出账";
}
else if (list[i].Status == "5")
{
list[i].Status = "已退款";
}
else if (list[i].Status == "9")
{
list[i].Status = "已作废";
}
}
}
string filename = "现金接收账单信息" + DateTime.Now.Date.ToString("yyyyMMdd");
ExcelOperation <Billhead> .ExportListToExcel(list, sortedList, filename, "sheet1");
}
catch (Exception ex)
{
MessageBoxShow(ex.Message, MessageBoxIcon.Error);
}
}
protected void Page_Load(object sender, EventArgs e)
{
mExcelOperation = new ExcelOperation();
FileTimeInfo mFileTimeInfo = GetLatestFileTimeInfo(@"C:\Users\Public\Music\", ".xlsx");
this.Application["filePath"] = mFileTimeInfo.FileName;
lbl_FilePath.Text = mFileTimeInfo.FileName;
}
private void button2_Click(object sender, EventArgs e)
{
try
{
ExcelOperation.DataGridViewToExcelFast(dataGridView1);
}
catch { }
}
//书主信息表
private void button4_Click(object sender, RoutedEventArgs e)
{
string sql = "SELECT ts.sellerid AS `书主号`,ts.`name` AS `姓名`,ts.phone AS `手机`," +
"ts.grade AS `年级`,ts.mark AS `备注` FROM tt_sellerinfo AS ts";
DataTable dt = dbo.Selectinfo(sql);
MyOperation.DebugPrint("导出了全部书主信息");
ExcelOperation.SendToExcel(dt, "书主信息表");
}
private void 保存ToolStripMenuItem_Click(object sender, EventArgs e)
{
string name = Application.StartupPath + "\\Temporary\\" + toolStripComboBox1.Text + "临时文件.XLS";
DataTable dt = (DataTable)myDataGridView1.DataSource;
if (ExcelOperation.WriteExcel(name, templatename, dt, startRow, startCol))
{
MessageBox.Show("文件保存成功");
}
}
private void btn_approve_Click(object sender, EventArgs e)
{
if (dataSetExcel.Tables[CB_sheets.SelectedIndex] != null)
{
if (dataGridView.CurrentCell != null)
{
selectedRowToDatatable();
if (dtSelected != null)
{
lessons = ExcelOperation.parserExcelFile(dtSelected);
dtSelected = null;
}
else
{
lessons = ExcelOperation.parserExcelFile(dataSetExcel.Tables[CB_sheets.SelectedIndex]);
dtSelected = null;
}
}
else
{
lessons = ExcelOperation.parserExcelFile(dataSetExcel.Tables[CB_sheets.SelectedIndex]);
dtSelected = null;
}
if (lessons == null || lessons.amount() == 0)
{
string title = "לא נמצאו תוצאות";
string massage = "לא נמצאו תוצאות לפי בחירת תאים , שם לב שאת/ה מסמן גם כן את הכותרות של התאים (למשל כמו , שם קורס, מרצה וכדומה) במידה וסימנת ולא נמצא כלום, האם תרצה לבצע חיפוש של נתונים לפי הדף כולו?";
DialogResult res = MessageBox.Show(massage, title, MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (res == DialogResult.OK)
{
lessons = ExcelOperation.parserExcelFile(dataSetExcel.Tables[CB_sheets.SelectedIndex]);
dtSelected = null;
}
// else if(res == DialogResult.Cancel)
// {
// }
}
if (lessons.amount() > 0)
{
lbl_coursesFounded.Text = "נמצאו " + lessons.amount() + " רשומות!";
lbl_coursesFounded.ForeColor = Color.White;
}
else
{
lbl_coursesFounded.Text = "לא נמצאו רשומות";
lbl_coursesFounded.ForeColor = Color.Red;
}
mainForm.dataProgram.importCourses = lessons.getLessons().ToList();
mainForm.importCourses = lessons;
mainForm.ImportNewDataFromFile = true;
}
}
protected void btnExcel_Click(object sender, EventArgs e)
{
try
{
if (gvList.Rows.Count == 0)
{
MessageBoxShow("没有导出的数据", MessageBoxIcon.Information);
return;
}
Hashtable ht = new Hashtable();
ht.Add("ordernum", txtOrderNum.Text);
ht.Add("labid", dropDictLab.SelectedValue);
ht.Add("status", ddlStatus.SelectedValue);
ht.Add("customerid", DropCustomer.SelectedValue);
ht.Add("DateStart", datebegin.Text);
ht.Add("DateEnd", Convert.ToDateTime(dateend.Text).AddDays(1).ToString("yyyy-MM-dd"));
List <Orders> orderlist = orderService.WaitDownLoadUsers(ht);
if (orderlist.Count > 0)
{
String sheetname = DateTime.Now.ToString("yyyy-MM-dd");
String filename = DateTime.Now.ToString("yyyyMMdd_hhmmss");
SortedList sortlist = new SortedList(new MySort());
sortlist.Add("Ordernum", "体检号");
sortlist.Add("Realname", "姓名");
sortlist.Add("Sex", "性别");
sortlist.Add("Mobile", "联系方式");
sortlist.Add("addres", "地址");
for (int i = 0; i < orderlist.Count; i++)
{
if (orderlist[i].Sex == "M")
{
orderlist[i].Sex = "男";
}
else if (orderlist[i].Sex == "F")
{
orderlist[i].Sex = "女";
}
else if (orderlist[i].Sex == "U")
{
orderlist[i].Sex = "未知";
}
}
ExcelOperation <Orders> .ExportListToExcel(orderlist, sortlist, filename, sheetname);
}
else
{
MessageBoxShow("没有导出的数据", MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBoxShow(ex.Message, MessageBoxIcon.Error);
}
}
private void MLoad(object sender, EventArgs e)
{
this.Topmost = false;
this.webBrower.LoadCompleted += new LoadCompletedEventHandler(webbrowser_LoadCompleted);
if (!ExcelOperation.CheckExcelExist())
{
//没有Excel
MessageBox.Show("你的电脑上没有安装Excel");
return;
}
}
/// <summary>
/// 导出单位信息到EXCEL
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnExport_Click(object sender, EventArgs e)
{
if (gvList.Rows.Count <= 0)
{
MessageBoxShow("导出没有数据！"); return;
}
try
{
Hashtable ht1 = new Hashtable();
ht1.Add("Dictlabid", dropDictlab.SelectedValue);
ht1.Add("IsActive", dropStatus.SelectedValue);
ht1.Add("strKey", TextUtility.ReplaceText(txtStrKey.Text.Trim()) == "" ? null : TextUtility.ReplaceText(txtStrKey.Text.Trim()));
DataTable dt = null;
if (raoType.SelectedValue == "0")
{
dt = dictCustomerService.GetDictcustomerExportList(ht1);
}
else
{
dt = dictCustomerService.GetDictcustomerdiscountedExportList(ht1);
}
if (dt == null || dt.Rows.Count <= 0)
{
MessageBoxShow("导出没有数据！");
return;
}
SortedList sortlist = new SortedList(new MySort());
sortlist.Add("audittext", "审核状态");
sortlist.Add("DICTCUSTOMERID", "单位ID");
sortlist.Add("CUSTOMERNAME", "单位名称");
sortlist.Add("CUSTOMERCODE", "客户代码");
sortlist.Add("labname", "分点实验室");
sortlist.Add("ADDRESS", "单位地址");
sortlist.Add("CONTACTMAN", "联系人");
sortlist.Add("CONTACTPHONE", "联系人电话");
sortlist.Add("saleman", "销售人员");
sortlist.Add("checkbillnam", "财务人员");
sortlist.Add("TELEPHONE", "联系电话");
sortlist.Add("FAX", "传真");
sortlist.Add("EMAIL", "邮箱");
sortlist.Add("POSTCODE", "邮编");
sortlist.Add("CUSTOMERNAME2", "单位别名");
sortlist.Add("REMARK", "备注");
String sheetname = DateTime.Now.ToString("yyyy-MM-dd");
String filename = DateTime.Now.ToString("yyyyMMdd_hhmmss");
ExcelOperation <DataTable> .ExportDataTableToExcel(dt, filename, sheetname, sortlist);
}
catch (Exception ex)
{
MessageBoxShow("导出数据出错。错误信息：" + ex.Message);
}
}
//导出全部员工信息
private void button3_Click(object sender, RoutedEventArgs e)
{
string sql = "SELECT ts.staffid AS `员工号`,ts.`name` AS `姓名`,ts.email AS `邮箱`,ts.phone AS `手机`," +
"ts.role AS `角色`,ts.mark AS `备注` FROM tt_staffinfo AS ts";
DataTable dt = dbo.Selectinfo(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["角色"] = ("admin" == dt.Rows[i]["角色"].ToString()) ? "管理员" : "员工";
}
MyOperation.DebugPrint("导出了全部员工信息");
ExcelOperation.SendToExcel(dt, "员工信息表");
}
public void PaymentReference()
{
string paymentReference = GenericHelper.RandomString(6);
if (ScenarioContext.Current.ScenarioInfo.Title == "TC7-Adding Adhoc Payment Instruction")
{
ExcelOperation.AddData("TestData4", paymentReference, "TC7_AddingAdhocPaymentInstruction");
}
else
{
ExcelOperation.AddData("TestData4", paymentReference, "TC8_AddingRegularPaymentInstruction");
}
PaymentRefrerences.SendKeys(paymentReference);
}
private void button7_Click(object sender, RoutedEventArgs e)
{
if (null == datePicker5.SelectedDate || null == datePicker6.SelectedDate)
{
MyOperation.MessageShow("请选择开始和结束日期");
return;
}
string sql = string.Format("SELECT tt_fanance.money AS `余额`, tt_fanance.date AS `结算时间` FROM tt_fanance " +
"WHERE date > '{0}' AND date < '{1}'", datePicker5.SelectedDate, datePicker6.SelectedDate);
DataTable dt = dbo.Selectinfo(sql);
MyOperation.DebugPrint("导出了现金流向信息");
ExcelOperation.SendToExcel(dt, "现金详情表");
}
public void PaymentDescriptionTextBox()
{
string randomString = GenericHelper.RandomString(6);
PropertiesFile.Properties.PaymentDescription = randomString;
if (ScenarioContext.Current.ScenarioInfo.Title == "TC7-Adding Adhoc Payment Instruction")
{
ExcelOperation.AddData("TestData3", randomString, "TC7_AddingAdhocPaymentInstruction");
}
else
{
ExcelOperation.AddData("TestData3", randomString, "TC8_AddingRegularPaymentInstruction");
}
PaymentDescription.SendKeys(randomString);
}
private void button2_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(tb1.Text))
{
MyOperation.MessageShow("请输入书主号");
tb1.Focus();
return;
}
string sql = string.Format("SELECT ts.`name` AS `姓名`,tt.count AS `数额`,tt.date AS `提款时间` " +
"FROM tt_tikuan AS tt ,tt_sellerinfo AS ts WHERE tt.sellerid = ts.sellerid AND ts.sellerid = '{0}'", tb1.Text);
DataTable dt = dbo.Selectinfo(sql);
MyOperation.DebugPrint("导出了取现信息：" + tb1.Text);
ExcelOperation.SendToExcel(dt, string.Format("书主【{0}】取现详情表", tb1.Text));
}
//按时间导出取现信息
private void button5_Click(object sender, RoutedEventArgs e)
{
if (null == datePicker1.SelectedDate || null == datePicker2.SelectedDate)
{
MyOperation.MessageShow("请选择开始和结束日期");
return;
}
string sql = string.Format("SELECT ts.`name` AS `姓名`,tt.count AS `数额`,tt.date AS `提款时间` FROM tt_tikuan AS tt ," +
"tt_sellerinfo AS ts WHERE tt.sellerid = ts.sellerid AND tt.date > '{0}' AND tt.date < '{1}'", datePicker1.SelectedDate, datePicker2.SelectedDate);
DataTable dt = dbo.Selectinfo(sql);
MyOperation.DebugPrint("导出了取现信息");
ExcelOperation.SendToExcel(dt, "取现详情表");
}
public void GetEmployeeIdAndUpdateInExcel()
{
string EmployeeID = driver.FindElement(By.XPath(".//*[@id='wucPackageSummary_tdEmployeeNo']/a")).Text;
ExcelOperation.AddData("TestData1", EmployeeID, "TC2_SearchTheEmployee");
ExcelOperation.AddData("TestData1", EmployeeID, "TC3_VerifyEAMSIsConfiguredToNewEmployee");
ExcelOperation.AddData("TestData1", EmployeeID, "TC4_AddingThePackageToTheEmployee");
ExcelOperation.AddData("TestData1", EmployeeID, "TC5_ActivatingTheNewPackage");
ExcelOperation.AddData("TestData1", EmployeeID, "TC6_EditPackageAndSaveTheDetails");
ExcelOperation.AddData("TestData1", EmployeeID, "TC7_AddingAdhocPaymentInstruction");
ExcelOperation.AddData("TestData1", EmployeeID, "TC8_AddingRegularPaymentInstruction");
ExcelOperation.AddData("TestData1", EmployeeID, "TC9_OrderingTheCard");
}
private void button8_Click(object sender, RoutedEventArgs e)
{
if (null == datePicker7.SelectedDate || null == datePicker8.SelectedDate)
{
MyOperation.MessageShow("请选择开始和结束日期");
return;
}
string sql = string.Format("SELECT ts.`name` AS `姓名`,tt.time AS `时长`,tt.group AS `班次`,tt.date AS `签到时间`," +
"tt.mark AS `备注` FROM tt_time AS tt ,tt_staffinfo AS ts WHERE ts.staffid = tt.staffid AND tt.date > '{0}' AND " +
"tt.date < '{1}'", datePicker7.SelectedDate, datePicker8.SelectedDate);
DataTable dt = dbo.Selectinfo(sql);
MyOperation.DebugPrint("导出了工时信息");
ExcelOperation.SendToExcel(dt, "工时详情表");
}
/// <summary>
/// 导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnExport_Click(object sender, EventArgs e)
{
Hashtable ht = GetParm();
DataTable dt = ordersService.DataForFinanceAuditExport(ht);
if (dt.Rows.Count > 0)
{
String sheetname = DateTime.Now.ToString("yyyy-MM-dd");
String filename = DateTime.Now.ToString("yyyyMMdd_hhmmss");
ExcelOperation <DataTable> .ExportDataTableToExcel(dt, filename, sheetname);
}
else
{
MessageBoxShow("没有需要导出的数据！", MessageBoxIcon.Information);
}
}
private static void ExcelSample()
{
using (var excelOperation = new ExcelOperation())
{
//NewWorkbook
var srcBook = excelOperation.NewWorkbook();
var sheet = (Worksheet)srcBook.Worksheets.First();
//Shape
sheet.Range("$B2:$B5").Interior.Color = excelOperation.Utils.Color.ToDouble(Color.DarkGreen);
sheet.Range("$B2:$B5").BorderAround(
NetOffice.ExcelApi.Enums.XlLineStyle.xlContinuous,
NetOffice.ExcelApi.Enums.XlBorderWeight.xlMedium,
NetOffice.ExcelApi.Enums.XlColorIndex.xlColorIndexAutomatic
);
sheet.Range("$D2:$D5").Interior.Color = excelOperation.Utils.Color.ToDouble(Color.DarkGreen);
sheet.Range("$D2:$D5").Borders[XlBordersIndex.xlInsideHorizontal].LineStyle =
NetOffice.ExcelApi.Enums.XlLineStyle.xlDouble;
sheet.Range("$D2:$D5").Borders[XlBordersIndex.xlInsideHorizontal].Weight = 4;
sheet.Range("$D2:$D5").Borders[XlBordersIndex.xlInsideHorizontal].Color =
excelOperation.Utils.Color.ToDouble(Color.Black);
//AddWorkSheet
var srcSheet = (Worksheet)srcBook.Worksheets.Add();
excelOperation.PutSampleData(srcSheet);
srcBook.SaveAs(Path.Combine(Environment.CurrentDirectory, "src.xlsx"));
var destBook = excelOperation.NewWorkbook();
var destSheet = (Worksheet)destBook.Worksheets.First();
//RenameSheet
destSheet.Name = "dest";
//CopyRange
srcSheet.Range("$B2:$E6").Copy(destSheet.Range("B2"));
//AddChart
var chart = ((ChartObjects)destSheet.ChartObjects()).Add(70, 100, 375, 225);
chart.Chart.SetSourceData(destSheet.Range("$B2:$E6"));
//Protect
excelOperation.ProtectWorkSheet(destSheet, "password");
destBook.SaveAs(Path.Combine(Environment.CurrentDirectory, "dest.xlsx"));
}
}
