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);
}
}
