/// <summary>
/// 添加记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpLoadGetAdvertUsage(Model.AMS_AdvertUsage model)
{
try
{
StringBuilder strWhere = new StringBuilder();
strWhere.Append(" [Type]='" + (int)model.AdvertType + "' and Number='" + model.SchoolNum + "' and Num='" + model.AdvertNum + "'");
DataSet ds = dal_advertUageView.GetList(strWhere.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
Model.AMS_AdvertUsage sameModel = DataRowToAMS_AdvertUsage(ds.Tables[0].Rows[0]);
sameModel.AdvertUsage = Model.AMS_AdvertUsage.ToXml(model);
sameModel.LastUpdateTime = model.LastUpdateTime;
return(dal_advertUsage.Update(sameModel));
}
else
{
Model.AMS_AdvertisementSchoolCopy advert = GetSchholAdvertByNum(model.AdvertNum, model.SchoolNum, model.AdvertType);
if (advert == null)
{
return(true);
}
model.SchoolID = advert.SchoolID;
model.AdvertID = advert.ID;
return(dal_advertUsage.Add(model) > 0 ? true : false);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool SendUsage()
{
try
{
//获取使用情况
List <SeatManage.ClassModel.AMS_AdvertUsage> usageList = SeatManage.Bll.AdvertisementOperation.GetAdvertUsageList();
//创建使用记录
List <AMS.Model.AMS_AdvertUsage> modelList = new List <Model.AMS_AdvertUsage>();
foreach (SeatManage.ClassModel.AMS_AdvertUsage item in usageList)
{
AMS.Model.AMS_AdvertUsage model = new Model.AMS_AdvertUsage();
model = AMS.Model.AMS_AdvertUsage.ToModel(item.AdvertUsage);
model.AdvertNum = item.AdvertNum;
model.AdvertType = (AMS.Model.Enum.AdType)System.Enum.Parse(typeof(AMS.Model.Enum.AdType), item.AdvertType.ToString());
model.AdvertUsage = item.AdvertUsage;
model.LastUpdateTime = item.LastUpdateTime;
model.SchoolNum = ServiceSet.SchoolNums;
if (!AMS.ServiceProxy.AdvertisementOperationService.UpLoadGetAdvertUsage(model))
{
return(false);
}
}
return(true);
}
catch
{
throw;
}
}
private Model.AMS_AdvertUsage DataRowToAMS_AdvertUsage(DataRow dr)
{
//[AdvertID],[ID],[AdvertUsage],[LastUpdateTime],[SchoolID],[CustomerID],[OriginalID],[UserName],[Type]
//,[AdContent],[IsNew],[OperatorName],[EndDate],[EffectDate],[Name],[Num],[SchoolName],
//[Number],[CompanyName],[CustomerNo],[OriginalNum],[OriginaName],[OriginaEffectDate],[OriginaEndDate],[OriginaContent]
Model.AMS_AdvertUsage model = new Model.AMS_AdvertUsage();
model = Model.AMS_AdvertUsage.ToModel(dr["AdvertUsage"].ToString());
model.ID = int.Parse(dr["ID"].ToString());
model.AdvertID = int.Parse(dr["AdvertID"].ToString());
model.AdvertNum = dr["Num"].ToString();
model.AdvertType = (AMS.Model.Enum.AdType) int.Parse(dr["Type"].ToString());
model.AdvertUsage = dr["AdvertUsage"].ToString();
model.LastUpdateTime = DateTime.Parse(dr["LastUpdateTime"].ToString());
model.SchoolID = int.Parse(dr["SchoolID"].ToString());
model.SchoolName = dr["SchoolName"].ToString();
model.SchoolNum = dr["Number"].ToString();
return(model);
}
/// <summary>
/// 添加使用记录
/// </summary>
/// <param name="model"></param>
public static bool UpLoadGetAdvertUsage(Model.AMS_AdvertUsage model)
{
AMS.IBllService.IAdvertManageBllService bllService = AMS.ServiceConnectChannel.AdvertManageBllServiceChannel.CreateServiceChannel();
try
{
return(bllService.UpLoadGetAdvertUsage(model));
}
catch (EndpointNotFoundException ex)
{
throw new AMS.Model.CustomerException("连接服务器失败");
}
catch (CommunicationException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
finally
{
ICommunicationObject ICommObjectService = bllService as ICommunicationObject;
try
{
if (ICommObjectService.State == CommunicationState.Faulted)
{
ICommObjectService.Abort();
}
else
{
ICommObjectService.Close();
}
}
catch
{
ICommObjectService.Abort();
}
}
}
public void GetDataList()
{
AMS.Model.AMS_AdvertUsage all = new Model.AMS_AdvertUsage();
all.SchoolID = -1;
all.SchoolName = "总计";
SchoolUsageList.Add(new ViewModel_AdvertUsageItem()
{
UsageModel = all
});
List <AMS.Model.AMS_AdvertUsage> usagelist = AMS.ServiceProxy.AdvertisementOperationService.GetAdvertUsage(-1, _AdvertID);
foreach (AMS.Model.AMS_AdvertUsage u in usagelist)
{
SchoolUsageList[0].UsageModel.PlayCount += u.PlayCount;
SchoolUsageList[0].UsageModel.PrintCount += u.PrintCount;
SchoolUsageList[0].UsageModel.WatchCount += u.WatchCount;
foreach (KeyValuePair <string, AMS.Model.AdvertisementUsage> item in u.ItemUsage)
{
if (SchoolUsageList[0].UsageModel.ItemUsage.ContainsKey(item.Key))
{
SchoolUsageList[0].UsageModel.ItemUsage[item.Key].PlayCount += item.Value.PlayCount;
SchoolUsageList[0].UsageModel.ItemUsage[item.Key].PrintCount += item.Value.PrintCount;
SchoolUsageList[0].UsageModel.ItemUsage[item.Key].WatchCount += item.Value.WatchCount;
}
else
{
SchoolUsageList[0].UsageModel.ItemUsage.Add(item.Key, item.Value);
}
}
SchoolUsageList.Add(new ViewModel_AdvertUsageItem()
{
UsageModel = u
});
}
SelectedUsage = SchoolUsageList[0];
}
