/// <summary> /// 查询到货信息 /// </summary> private void SearchReceiveData() { //获取查询条件 UserInfo usr = new UserInfo(); usr.AreaId = base.CurrentUserSingleRegionId; usr.OrgId = base.CurrentUserRegOrgId; //string startDate = ComUtil.formatDate(this.dtStartDate.Text); //string endDate = ComUtil.formatDate(this.dtEndDate.Value.AddDays(1).ToString()); string startDate = ComUtil.formatDate(this.dtStartDate.Text); string endDate = ComUtil.formatDate(this.dtEndDate.Text); string medicalName = this.txtmedicalName.Text.Trim(); string salerName = this.txtSalerName.Text.Trim(); //获取查询数据集 //dtReceive = OutOrderReceiveDao.GetInstance().GetOrderReceive(usr, startDate, endDate, medicalName, salerName); dtReceive = OutOrderReceiveDao.GetInstance().GetOrderReceive(usr); InitFromCacheByData(dtReceive); this.cachedDataView.Sort = " ID desc "; this.bindingSource1.DataSource = dtReceive.DefaultView; }
private void btnAllExport_Click(object sender, EventArgs e) { bool flag = true; if (this.gridView3.RowCount == 0) { XtraMessageBox.Show("无可操作记录!", Constant.MsgTitle, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } string strCurrentDB = FileOperation.GetNodeValue(FileOperation.GetNodeObject(EmedFunc.GetLocalPersonCfgPath() + @"/HisOrderReceive.xml", "Config/DestDB"), "DBType"); if (strCurrentDB.Equals("EXCEL")) { //选择导出文件 string ExpFilePath = this.SelectExportFile(); if (ExpFilePath.Length == 0) { return; } try { //dttmp = (DataTable)(this.bindingSource1.List[0]); DataRow[] drArray = dtReceive.DefaultView.Table.Select(dtReceive.DefaultView.RowFilter, dtReceive.DefaultView.Sort, dtReceive.DefaultView.RowStateFilter); dttmp = dtReceive.DefaultView.Table.Clone(); foreach (DataRow dr in drArray) { dttmp.Rows.Add(dr.ItemArray); } //原代码全导出无法查询导出 //flag = OutOrderReceiveDao.GetInstance().ExportReceive(ExpFilePath, dtReceive); //修改后 flag = OutOrderReceiveDao.GetInstance().ExportReceive(ExpFilePath, dttmp); if (flag) { XtraMessageBox.Show("导出到货信息文件成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { XtraMessageBox.Show("导出到货信息文件失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } } catch (Exception ex) { XtraMessageBox.Show("导出到货信息文件出错!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } } string receiveIdstr = string.Empty; string receiveHisIdstr = string.Empty; foreach (DataRow dr in dtReceive.Rows) { if (dr["TYPE"].ToString().Equals("1")) { receiveIdstr += "'" + dr["ID"].ToString() + "',"; } else { receiveHisIdstr += "'" + dr["ID"].ToString() + "',"; } } //OutOrderReceiveDao.GetInstance().UpdateOrderReceive(receiveIdstr, receiveHisIdstr); }