/// <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); //修改 } } } } }