/// <summary>
/// 获取更新数据的存储过程参数列表
/// </summary>
/// <param name="baseFilter"></param>
/// <returns></returns>
protected override IDictionary <string, object> GetUpdateSpInParams(BaseFilter baseFilter)
{
TimeLineUpdateFilter filter = baseFilter as TimeLineUpdateFilter;
if (filter == null)
{
return(null);
}
IDictionary <string, object> inPutParam = new Dictionary <string, object>();
inPutParam.Add("@CompanyKey", filter.CompanyKey);
inPutParam.Add("@UserId", filter.UserId);
inPutParam.Add("@CurrentMonthString", filter.CurrentMonthString);
inPutParam.Add("@CurrentMonthFirst", filter.CurrentMonthFirst);
inPutParam.Add("@CurrentMonthSecond", filter.CurrentMonthSecond);
inPutParam.Add("@CurrentMonthThird", filter.CurrentMonthThird);
inPutParam.Add("@NextMonthString", filter.NextMonthString);
inPutParam.Add("@NextMonthFirst", filter.NextMonthFirst);
inPutParam.Add("@NextMonthSecond", filter.NextMonthSecond);
inPutParam.Add("@NextMonthThird", filter.NextMonthThird);
inPutParam.Add("@MonthAfterNextString", filter.MonthAfterNextString);
inPutParam.Add("@MonthAfterNextFirst", filter.MonthAfterNextFirst);
inPutParam.Add("@MonthAfterNextSecond", filter.MonthAfterNextSecond);
inPutParam.Add("@MonthAfterNextThird", filter.MonthAfterNextThird);
inPutParam.Add("@LastMonthString", filter.LastMonthString);
inPutParam.Add("@LastMonthFirst", filter.LastMonthFirst);
inPutParam.Add("@LastMonthSecond", filter.LastMonthSecond);
inPutParam.Add("@LastMonthThird", filter.LastMonthThird);
return(inPutParam);
}
/// <summary>
/// 程序执行主入口
/// </summary>
/// <param name="requestEntity"></param>
/// <param name="responseEntity"></param>
protected override void DoExecute(RequestEntity requestEntity, ResponseEntity responseEntity)
{
// 定义接收客户端参数的变量
TimeLineUpdateFilter filter
= ServiceUtility.ConvertToFilterFromDict <TimeLineUpdateFilter>(requestEntity.Parameters);
filter.UserId = responseEntity.UserId;
List <string> companyKeys = new List <string>();
if (!string.IsNullOrEmpty(filter.CompanyKeys))
{
companyKeys = filter.CompanyKeys.Split(WebServiceConst.Separater_Comma.ToArray()).ToList();
}
//List<int> companyIds = Singleton<CompanyCache>.Instance.CompanyIds(requestEntity.UserId);
if (companyKeys == null || companyKeys.Count == 0)
{
responseEntity.ResponseStatus = (int)EnumResponseState.Others;
responseEntity.ResponseMessage = "当前账户下无子公司Id";
return;
}
string companyKey = companyKeys[0];
filter.CompanyKey = companyKey;
// 时间轴设置更新序列
Singleton <BaseUpdateBLL <TimeLineUpdateSeqDAL> > .Instance.UpdateData(filter, responseEntity);
}
/// <summary>
/// 程序执行主入口
/// </summary>
/// <param name="requestEntity"></param>
/// <param name="responseEntity"></param>
protected override void DoExecute(RequestEntity requestEntity, ResponseEntity responseEntity)
{
// 定义接收客户端参数的变量
TimeLineUpdateFilter filter
= ServiceUtility.ConvertToFilterFromDict <TimeLineUpdateFilter>(requestEntity.Parameters);
filter.UserId = responseEntity.UserId;
// 时间轴设置更新关帐日
Singleton <BaseUpdateBLL <TimeLineUpdateCloseDayDAL> > .Instance.UpdateData(filter, responseEntity);
}
/// <summary>
/// 获取检索数据的存储过程名
/// </summary>
/// <param name="baseFilter"></param>
/// <returns></returns>
protected override string GetUpdateSpName(BaseFilter baseFilter)
{
TimeLineUpdateFilter filter = baseFilter as TimeLineUpdateFilter;
if (filter == null)
{
return("");
}
return("proc_FinanceManage_UpdateTimeLineSeq");
}
/// <summary>
/// 获取检索数据的存储过程名
/// </summary>
/// <param name="baseFilter"></param>
/// <returns></returns>
protected override string GetUpdateSql(BaseFilter baseFilter)
{
TimeLineUpdateFilter filter = baseFilter as TimeLineUpdateFilter;
if (filter == null)
{
return("");
}
StringBuilder sb = new StringBuilder();
sb.Append(" UPDATE [dbo].[CloseBillDay] ");
sb.Append(" SET OriginalTime = '{0}' ");
sb.Append(" , LatestTime = '{1}' ");
sb.Append(" , CreateTime = GETDATE()");
sb.Append(" , OperatorID = {2} ");
//sb.Append(" , Updatetime = GETDATE() ");
sb.Append(" WHERE CloseBillDayID = {3} ");
return(sb.ToString().StringFormat(filter.OriginalTime
, filter.LatestTime, filter.UserId, filter.CloseBillDayID));
}
