/// <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; } }