/// <summary> /// 初始化数据 /// </summary> public void InitializeData() { using (SqlCRUD sqlCRUD = new SqlCRUD(SqlHelper.MyConnectionString)) { OrdersData = sqlCRUD.SelectData("Orders", new string[] { "ID", "Money", "Time" },"DATEDIFF(day, Time, '"+DateTime.Now.ToShortDateString()+"')<="+this.FilterDay.ToString()); } OrderSelectIndex = 0; }
/// <summary> /// Button(提交按钮)相关Command /// </summary> /// <param name="obj"></param> public void PostOrdersProc(object obj) { string info = string.Empty; if (String.IsNullOrEmpty(this.Remark)) { info = OrderList.GetOrderInfoString(); } else { info = OrderList.GetOrderInfoString() + "\n\n备注信息:\n" + this.Remark; } if (ModernDialog.ShowMessage(info, "订单信息", MessageBoxButton.OKCancel) == MessageBoxResult.OK) { SqlHelper sqlH=null; try { using (sqlH = new SqlHelper(SqlHelper.MyConnectionString)) { SqlCRUD sqlCRUD = new SqlCRUD(SqlHelper.MyConnectionString); sqlCRUD.InsertData("Orders", new string[] { "Info", "Money", "Time" }, new string[] { info, OrderList.TotalMoney.ToString(), DateTime.Now.ToString() }); } this.Remark = string.Empty; OrdersInfoPageViewModel OrdersInfoVM = ViewModelsManager.GetViewModelFromResources<OrdersInfoPageViewModel>(); OrdersInfoVM.InitializeData(); } finally { if (sqlH != null) { sqlH.Dispose(); } } } }