//绑定数据到下方界面 根据选中选中选项卡取得数据 private void SetTradeDetailMessage(Alading.Entity.Trade trade) { if (trade == null) { return; } switch (tabsDetailMessage.SelectedTabPageIndex) { case 0: LoadPrintPreview(trade); break; case 1: break; case 2: //调用存储过程获得数据 gcOrdersDetail.DataSource = TradeOrderService.GetView_TradeDetailItemsDataSet(trade.CustomTid).Tables[0]; break; case 3: detailGCFlowMessage.DataSource = TradeInfoService.GetTradeInfo(p => p.CustomTid == trade.CustomTid); break; } }
private void simpleButton1_Click(object sender, EventArgs e) { DateTime time = System.DateTime.Now; DataTable table = creatData(); if (TradeInfoService.AddTradeInfoSqlBulkCopy(table) == ReturnType.Success) { XtraMessageBox.Show("success!"); } DateTime time1 = System.DateTime.Now; MessageBox.Show("I am not cache & use time:" + (time1 - time).ToString()); }
/// <summary> /// 创建一条订单流水操作信息到数据库,操作时间默认为当前时间 /// </summary> /// <param name="trade">交易实体</param> /// <param name="title">操作主题</param> /// <param name="contents">操作内容</param> /// <param name="department">操作部分</param> public static void CreateFlowMessage(string customTid, string title, string content, string department) { Alading.Entity.TradeInfo tradeInfo = new Alading.Entity.TradeInfo(); tradeInfo.TradeInfoCode = Guid.NewGuid().ToString(); tradeInfo.CustomTid = customTid; tradeInfo.Title = title; tradeInfo.AppendUserName = User.nick; //tradeInfo.AppendUserName = oprator; tradeInfo.AppendTime = DateTime.Now; tradeInfo.AppendUserCode = string.Empty; tradeInfo.AppendDepartment = department; tradeInfo.Content = content; TradeInfoService.AddTradeInfo(tradeInfo); }
private void confirm_Click(object sender, EventArgs e) { if (TestErrorInput() == false) { return; } TradeInfo info = new TradeInfo(); info.TradeInfoCode = Guid.NewGuid().ToString(); info.Title = txtTitle.Text; info.AppendUserName = txtOperaterName.Text; info.Content = txtContent.Text; info.CustomTid = _customTid; info.AppendDepartment = txtDepartment.SelectedItem.ToString(); info.AppendTime = DateTime.Now; info.AppendUserCode = "testLogin";//系统账号 TradeInfoService.AddTradeInfo(info); this.Close(); }
private void importIn_Click(object sender, EventArgs e) { DataTable table = new DataTable("TradeInfo"); table.Columns.Add("TradeInfoCode", typeof(string)); table.Columns.Add("CustomTid", typeof(string)); table.Columns.Add("Title", typeof(string)); table.Columns.Add("Content", typeof(string)); table.Columns.Add("AppendUserCode", typeof(string)); table.Columns.Add("AppendUserName", typeof(string)); table.Columns.Add("AppendDepartment", typeof(string)); table.Columns.Add("time", typeof(string)); table = ExecleDs("D:\\a.xls"); TradeInfoService.AddTradeInfoSqlBulkCopy(table); if (TradeInfoService.AddTradeInfoSqlBulkCopy(table) == ReturnType.Success) { XtraMessageBox.Show("success!"); } }
//绑定数据到下方界面 根据选中选中选项卡取得数据 private void SetTradeDetailMessage(Alading.Entity.Trade trade) { if (trade == null) { gcOrdersDetail.DataSource = null; detailGCFlowMessage.DataSource = null; return; } switch (tabsDetail.SelectedTabPageIndex) { case 0: gcOrdersDetail.DataSource = TradeOrderService.GetView_TradeDetailItemsDataSet(_focusedTrade.CustomTid).Tables[0]; break; case 1: detailGCFlowMessage.DataSource = TradeInfoService.GetTradeInfo(p => p.CustomTid == trade.CustomTid); break; } }
private void testXtra_SelectedPageChanged(object sender, DevExpress.XtraTab.TabPageChangedEventArgs e) { if (testXtra.SelectedTabPage == tradeInfor) { DateTime time1 = System.DateTime.Now; List <Alading.Entity.TradeInfo> tradeInfoList = TradeInfoService.GetAllTradeInfo().ToList(); TradeInfo.DataSource = tradeInfoList; DateTime time2 = System.DateTime.Now; MessageBox.Show("I am not cache & use time:" + (time2 - time1).ToString()); } if (testXtra.SelectedTabPage == trade2) { DateTime time1 = System.DateTime.Now; List <Alading.Entity.TradeInfo> tradeInfoList = test.TradeInfoList; gridControl2.DataSource = tradeInfoList; DateTime time2 = System.DateTime.Now; MessageBox.Show("I am cache & use time:" + (time2 - time1).ToString()); } }
//根据选中Tab来设定界面值 动态加载 private void SetTradeDetailMessages(DataRow currentRow) { try { //发票显示 detailTicketMessage.PageVisible = Convert.ToBoolean(currentRow["HasInvoice"].ToString()); string customTid = currentRow["CustomTid"].ToString(); switch (tabsTradeDetail.SelectedTabPageIndex) { /*收货信息填写*/ case 0: ReceiverGoodsDetail(customTid); break; /*买家信息填写*/ case 1: BuyerInforDetail(customTid); break; /*TODO 绑定Trade的流水信息到处理流程Tab 暂时TradeInfo里面没数据*/ case 2: detailGCFlowMessage.DataSource = TradeInfoService.GetTradeInfo(p => p.CustomTid == customTid); break; case 3: break; case 4: break; case 5: gcAssembleDetail.DataSource = View_TradeAssembleStockService.GetViewTradeAssembleDataSet(_currentOrderRow["TradeOrderCode"].ToString()).Tables[0]; break; } } catch (System.Exception ex) { throw ex; } }