/// <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 bool DeleteAdvertisementCopy(Model.AMS_AdvertisementSchoolCopy model)
{
try
{
return(dal_advertisementcopy.Delete(model.ID));
}
catch (Exception ex)
{
throw ex;
}
}
public bool AddAdvertisementCopy(Model.AMS_AdvertisementSchoolCopy model)
{
try
{
return(dal_advertisementcopy.Add(model) > 0 ? true : false);
}
catch (Exception ex)
{
throw ex;
}
}
private AMS.Model.AMS_AdvertisementSchoolCopy DataRowToAMS_AdvertisementCopy(DataRow dr)
{
//[[SchoolID],[CustomerID],[OriginalID],[UserName],[IsNew],[Type],[AdContent],[OperatorName],[EndDate],[EffectDate],[Name],[Num],[ID],[SchoolName],[Number],[CompanyName],[CustomerNo]
AMS.Model.AMS_AdvertisementSchoolCopy model = new Model.AMS_AdvertisementSchoolCopy();
model.AdContent = dr["AdContent"].ToString();
model.CustomerID = int.Parse(dr["CustomerID"].ToString());
model.EffectDate = DateTime.Parse(dr["EffectDate"].ToString());
model.EndDate = DateTime.Parse(dr["EndDate"].ToString());
model.ID = int.Parse(dr["ID"].ToString());
model.Name = dr["Name"].ToString();
model.Num = dr["Num"].ToString();
model.OperatorID = int.Parse(dr["OperatorName"].ToString());
model.OperatorName = dr["UserName"].ToString();
model.Type = (AMS.Model.Enum.AdType) int.Parse(dr["Type"].ToString());
model.IsNew = bool.Parse(dr["IsNew"].ToString());
model.OriginalID = int.Parse(dr["OriginalID"].ToString());
model.SchoolID = int.Parse(dr["SchoolID"].ToString());
model.SchoolName = dr["SchoolName"].ToString();
return(model);
}
public Model.AMS_AdvertisementSchoolCopy GetSchholAdvertByNum(string AdNum, string schoolNum, Model.Enum.AdType adType)
{
try
{
Model.AMS_AdvertisementSchoolCopy model = new Model.AMS_AdvertisementSchoolCopy();
StringBuilder strWhere = new StringBuilder();
strWhere.Append(" Number='" + schoolNum + "' and Num='" + AdNum + "' and [Type]='" + (int)adType + "'");
DataSet ds = dal_advertisementcopyView.GetList(strWhere.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToAMS_AdvertisementCopy(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw ex;
}
}
public Model.AMS_AdvertisementSchoolCopy GetSameSchoolAdvert(int SchoolID, int OriginalID)
{
try
{
Model.AMS_AdvertisementSchoolCopy model = new Model.AMS_AdvertisementSchoolCopy();
StringBuilder strWhere = new StringBuilder();
strWhere.Append(" SchoolID='" + SchoolID + "' and OriginalID='" + OriginalID + "'");
DataSet ds = dal_advertisementcopyView.GetList(strWhere.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToAMS_AdvertisementCopy(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 删除广告副本
/// </summary>
/// <returns></returns>
public static bool DeleteAdvertisementCopy(Model.AMS_AdvertisementSchoolCopy model)
{
AMS.IBllService.IAdvertManageBllService bllService = AMS.ServiceConnectChannel.AdvertManageBllServiceChannel.CreateServiceChannel();
try
{
return(bllService.DeleteAdvertisementCopy(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();
}
}
}
/// <summary>
/// 添加命令
/// </summary>
/// <param name="command"></param>
/// <param name="schoolIDList"></param>
/// <returns></returns>
public bool AddCommand(AMS.Model.AMS_IssureList command, List <int> schoolIDList)
{
try
{
command.SubmitTime = DateTime.Now;
if (command.CommandType == Model.Enum.IsureCommandType.Advertisement)
{
AMS.Model.AMS_Advertisement adModel = GetSingleAdvertisement(command.CommandID);
{
if (adModel != null)
{
foreach (int school in schoolIDList)
{
AMS.Model.AMS_AdvertisementSchoolCopy copy = new Model.AMS_AdvertisementSchoolCopy();
copy.AdContent = adModel.AdContent;
copy.CustomerID = adModel.CustomerID;
copy.EffectDate = adModel.EffectDate;
copy.EndDate = adModel.EndDate;
copy.Name = adModel.Name;
copy.Num = adModel.Num;
copy.OperatorID = adModel.OperatorID;
copy.OriginalID = adModel.ID;
copy.SchoolID = school;
copy.Type = adModel.Type;
AMS.Model.AMS_AdvertisementSchoolCopy sameCopy = GetSameSchoolAdvert(school, adModel.ID);
int copyID = 0;
if (sameCopy != null)
{
copy.ID = sameCopy.ID;
copyID = sameCopy.ID;
if (!dal_advertisementcopy.Update(copy))
{
return(false);
}
}
else
{
copyID = dal_advertisementcopy.Add(copy);
}
if (copyID < 1)
{
return(false);
}
else
{
command.SchoolID = school;
command.CommandID = copyID;
if (dal_issurelist.Add(command) < 1)
{
return(false);
}
}
}
}
}
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
