//绑定数据到下方界面 根据选中选中选项卡取得数据
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;
}
}
