/// <summary>
/// 添加活动统计数据
/// </summary>
/// <param name="model">统计数据</param>
/// <returns></returns>
private int AddSubjectStatisticData(SWfsSubjectStatisticsDataTemp model)
{
int result = 0;
StringBuilder sql = new StringBuilder();
sql.Append("INSERT INTO SWfsSubjectStatisticsDataTemp([SubjectNo],[StatisticsDataXML]) VALUES(@SubjectNo,@StatisticsDataXML)");
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@SubjectNo", model.SubjectNo),
new SqlParameter("@StatisticsDataXML", model.StatisticsDataXML)
};
try
{
using (SqlConnection conn = new SqlConnection(WfsConnString))
{
result = SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql.ToString(), param);
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
/// <summary>
/// 修改活动统计数据
/// </summary>
/// <param name="model">统计数据</param>
/// <returns></returns>
private int EditSubjectStatisticData(SWfsSubjectStatisticsDataTemp model)
{
int result = 0;
StringBuilder sql = new StringBuilder();
sql.Append("UPDATE SWfsSubjectStatisticsDataTemp SET StatisticsDataXML=@StatisticsDataXML,DateCreate=@DateCreate WHERE SubjectNo=@SubjectNo");
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@SubjectNo", model.SubjectNo),
new SqlParameter("@StatisticsDataXML", model.StatisticsDataXML),
new SqlParameter("@DateCreate", DateTime.Now)
};
try
{
using (SqlConnection conn = new SqlConnection(WfsConnString))
{
result = SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql.ToString(), param);
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
/// <summary>
/// 导入活动统计数据
/// </summary>
/// <param name="list"></param>
/// <param name="type">类型 1今日新开 2进行中 3已结束</param>
public void SubjectStatisticDataMain(List <SubjectSaleVisitStatisticsDataModel> list, int type)
{
if (list != null && list.Count() > 0)
{
foreach (SubjectSaleVisitStatisticsDataModel item in list)
{
if (item != null && !string.IsNullOrEmpty(item.SaleStatistic.SubjectNo))
{
SWfsSubjectStatisticsDataTemp model = new SWfsSubjectStatisticsDataTemp();
model.SubjectNo = item.SubjectNo;
model.StatisticsDataXML = StatisticsDataXMLAppend(item);
if (!IsExists(item.SaleStatistic.SubjectNo))
{
AddSubjectStatisticData(model); //添加到临时表
}
else
{
model.DateCreate = DateTime.Now;
EditSubjectStatisticData(model); //修改
}
}
}
}
}
