private void InitData() { Task.Factory.StartNew(() => { QueryParameter = new SalesRebateQueryParameterModel() { SettleDateEnd1 = DateTime.Now.AddYears(-1).Date, SettleDateEnd2 = DateTime.Now.Date }; BatchParameter = new SalesRebateBatchParameterModel() { SettleDateBegin = DateTime.Now.AddMonths(-1).Date, SettleDateEnd = DateTime.Now.Date }; var enums = CommonService.GetEnumLists(); RebateClassLists = enums.Where(x => x.GroupSeq == 6); OrganizationLists = ComboBoxSearchService.GetOrganizationLists(); HostConfig = CommonService.GetHostConfig(DataGridId, HostName, User.ID) ?? new HostConfigModel() { TypeId = DataGridId, Host = HostName, UserId = User.ID, TypeDesciption = "客户案子销售返利" }; Token = K3ApiXService.GetToken(); UIExecute.RunAsync(() => { QueryBaseCommand.Execute(null); }); }); }
public SalesRebateRecentParameterView(SalesRebateBatchParameterModel model) { InitializeComponent(); this.DataContext = new SalesRebateRecentParameterViewModel(model); this.WindowStartupLocation = WindowStartupLocation.CenterScreen; CommandBindings.Add(new CommandBinding(ApplicationCommands.Help, (send, e) => { if (this.WindowState == WindowState.Normal) { this.WindowState = WindowState.Maximized; } else if (WindowState == WindowState.Maximized) { this.WindowState = WindowState.Normal; } })); this.MouseLeftButtonDown += (sender, e) => { if (e.LeftButton == MouseButtonState.Pressed) { this.DragMove(); } }; this.MouseLeftButtonDown += (sender, e) => { if (e.LeftButton == MouseButtonState.Pressed) { this.DragMove(); } }; }
/// <summary> /// 选定客户在该区间是否有数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool IfExistsOrgICSaleBill(SalesRebateBatchParameterModel model) { string sql = @" select top 1 1 as r from ICSale a join ICSaleEntry b on a.FInterID = b.FInterID where a.FDate >= @SettleDateBegin and a.FDate <= @SettleDateEnd AND a.FTranType = 80 AND a.FCancellation = 0 and FCustID = @OrgId and b.FItemID<>14331"; using (var connection = SqlDb.UpdateConnection) { return(!string.IsNullOrEmpty(Convert.ToString(connection.ExecuteScalar(sql, new { model.SettleDateBegin, model.SettleDateEnd, OrgId = model.OrganizationSearchedItem.Id })))); } }
/// <summary> /// 新开页面根据类别计算当前参数 /// </summary> /// <param name="model"></param> public void InsertCurrentOrgRebateClassParameter(SalesRebateBatchParameterModel model) { DynamicParameters dp = new DynamicParameters(); dp.Add("@SettleDateBegin", model.SettleDateBegin, DbType.Date, ParameterDirection.Input); dp.Add("@SettleDateEnd", model.SettleDateEnd, DbType.Date, ParameterDirection.Input); dp.Add("@OrgId", model.OrganizationSearchedItem.Id, DbType.Int32, ParameterDirection.Input); dp.Add("@RebateClass", model.RebateClassSeletedItem.ItemSeq, DbType.Int32, ParameterDirection.Input); using (var connection = SqlDb.UpdateConnection) { connection.Execute("SJSalesRebateInsertCurrentOrgRebateClassParameterProc", dp, null, null, CommandType.StoredProcedure); } }
public SalesRebateRecentParameterViewModel(SalesRebateBatchParameterModel batchParameter) { BatchParameter = batchParameter; QueryParameter = new SalesRebateRecentQueryParameterModel() { OrgId = BatchParameter.OrganizationSearchedItem.Id, RebateClass = BatchParameter.RebateClassSeletedItem.ItemSeq }; QueryParameter1 = new SalesRebateRecentQueryParameterModel { RebateClass = BatchParameter.RebateClassSeletedItem.ItemSeq }; InitData(); InitCommand(); }
/// <summary> /// 关闭参数界面自动计算 /// </summary> /// <param name="model"></param> /// <returns></returns> public void CalculateAmount(SalesRebateBatchParameterModel model, int userId, bool isconfig) { DynamicParameters dp = new DynamicParameters(); dp.Add("@SettleDateBegin", model.SettleDateBegin, DbType.Date, ParameterDirection.Input); dp.Add("@SettleDateEnd", model.SettleDateEnd, DbType.Date, ParameterDirection.Input); dp.Add("@OrgId", model.OrganizationSearchedItem.Id, DbType.Int32, ParameterDirection.Input); dp.Add("@RebateClass", model.RebateClassSeletedItem.ItemSeq, DbType.Int32, ParameterDirection.Input); dp.Add("@UserId", userId, DbType.Int32, ParameterDirection.Input); dp.Add("@IsConfig", isconfig, DbType.Boolean, ParameterDirection.Input); using (var connection = SqlDb.UpdateConnection) { connection.Execute("SJSalesRebateCalculateAmountProc", dp, null, null, CommandType.StoredProcedure); } }