private AMS.Model.AMS_TitleAd DataRowToAMS_TitleAd(DataRow dr) { AMS.Model.AMS_TitleAd model = new Model.AMS_TitleAd(); model.Id = int.Parse(dr["Id"].ToString()); model.Name = dr["Name"].ToString(); model.EffectDate = Convert.ToDateTime(dr["EffectDate"]); model.EndDate = Convert.ToDateTime(dr["EndDate"]); model.AdContent = dr["AdContent"].ToString(); model.Num = dr["Num"].ToString(); model.CustomerId = Convert.ToInt32(dr["CustomerId"]); return(model); }
public string DeleteTitleAd(Model.AMS_TitleAd model) { try { if (!Dal_TitleAd.Delete(model.Id)) { return("删除冠名失败!"); } return(""); } catch (Exception ex) { return(ex.Message); } }
public Model.AMS_TitleAd GetTitleAdByNum(int Num) { try { AMS.Model.AMS_TitleAd modellist = new Model.AMS_TitleAd(); string sql = string.Format(" ID={0}", Num); DataSet ds = Dal_TitleAd.GetList(sql); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { modellist = DataRowToAMS_TitleAd(ds.Tables[0].Rows[i]); } return(modellist); } catch (Exception ex) { throw ex; } }
/// <summary> /// 更新冠名广告 /// </summary> /// <param name="id"></param> /// <returns></returns> public static bool GetTitleAd(int Num) { try { Model.AMS_TitleAd advertTitle = AMS.ServiceProxy.ITitleAdService.GetTitleAdByNum(Num); if (advertTitle != null) { SeatManage.ClassModel.TitleAdvertInfo model = SeatManage.Bll.AMS_TitleAd.GetTitleModel(advertTitle.Num); SeatManage.ClassModel.TitleAdvertInfo seatTitle = new SeatManage.ClassModel.TitleAdvertInfo(); seatTitle.EffectDate = Convert.ToDateTime(advertTitle.EffectDate); seatTitle.EndDate = Convert.ToDateTime(advertTitle.EndDate); seatTitle.TitleAdvert = advertTitle.AdContent; seatTitle.TitleAdvertNo = advertTitle.Num; if (model == null) { if (SeatManage.Bll.AMS_TitleAd.AddTitleAdvert(seatTitle) == SeatManage.EnumType.HandleResult.Successed) { return (true); } return(false); } else { if (SeatManage.Bll.AMS_TitleAd.UpdateTitleAdvert(seatTitle) == SeatManage.EnumType.HandleResult.Successed) { return (true); } return(false); } } else { return(true); } } catch (Exception ex) { throw ex; } }
/// <summary> /// 修改冠名广告 /// </summary> /// <param name="model"></param> /// <returns></returns> public string UpdateTitleAd(Model.AMS_TitleAd model) { try { Model.AMS_TitleAd Admodel = Dal_TitleAd.GetModel(model.Name); if (Admodel != null && model.Id != Admodel.Id) { return("该冠名已存在!"); } if (!Dal_TitleAd.Update(model)) { return("更新失败!"); } return(""); } catch (Exception ex) { return(ex.Message); } }
/// <summary> /// 添加冠名广告 /// </summary> /// <param name="model"></param> /// <returns></returns> public string AddNewTitleAd(Model.AMS_TitleAd model) { try { Model.AMS_TitleAd Admodel = Dal_TitleAd.GetModel(model.Name); if (Admodel != null) { return("该冠名已存在!"); } if (Dal_TitleAd.Add(model) == 0) { return("添加硬广信息失败!"); } return(""); } catch (Exception ex) { return(ex.Message); } }
/// <summary> /// 获取命令明细列表 /// </summary> /// <param name="schoolId"></param> /// <param name="commandType"></param> /// <param name="handleResult"></param> /// <returns></returns> public List <Model.AMS_CommandDetail> GetCommandDetailList(string schoolId, AMS.Model.Enum.CommandType commandType, AMS.Model.Enum.CommandHandleResult handleResult) { StringBuilder str = new StringBuilder(); List <AMS.Model.AMS_CommandDetail> commandDetailList = new List <Model.AMS_CommandDetail>(); List <Model.View_CommandList> commandList = GetCommandList(schoolId, commandType, handleResult); foreach (AMS.Model.View_CommandList cmdModel in commandList) { AMS.Model.AMS_CommandDetail cmd = new Model.AMS_CommandDetail(); switch (cmdModel.Command) { case Model.Enum.CommandType.Caputre: cmd.ContentDescribe = "获取截图"; cmd.ContentName = "获取截图"; break; case Model.Enum.CommandType.HardAd: Model.AMS_HardAd hardAd = Dal_HardAd.GetModelByNum(cmdModel.CommandId.Value); cmd.ContentName = hardAd.Name; cmd.ContentDescribe = hardAd.Describe; cmd.ContentNumber = hardAd.Number; cmd.ContentID = hardAd.ID; break; case Model.Enum.CommandType.Playlist: if (dal_Playlist.GetList(string.Format(" id={0}", cmdModel.CommandId.Value)).Tables[0].Rows.Count > 0) { Model.AMS_PlayList playList = DataRowToAMS_PlayListModel(dal_PlaylistView.GetList(string.Format(" id={0}", cmdModel.CommandId.Value)).Tables[0].Rows[0]); cmd.ContentName = playList.PlayListName; cmd.ContentDescribe = playList.Describe; cmd.ContentNumber = playList.Number; cmd.ContentID = playList.Id; } break; case Model.Enum.CommandType.PrintTemplate: if (dal_PrintTemplateView.GetList(string.Format(" id={0}", cmdModel.CommandId.Value)).Tables[0].Rows.Count > 0) { Model.AMS_PrintTemplate printTemplate = DataRowToAMS_PrintTemplateModel(dal_PrintTemplateView.GetList(string.Format(" id={0}", cmdModel.CommandId.Value)).Tables[0].Rows[0]); cmd.ContentName = printTemplate.Name; cmd.ContentNumber = printTemplate.Number; cmd.ContentDescribe = printTemplate.Describe; cmd.ContentID = printTemplate.Id; } break; case Model.Enum.CommandType.ProgramUpgrade: if (dal_ProgramUpgrade.GetList(string.Format(" id={0}", cmdModel.CommandId.Value)).Tables[0].Rows.Count > 0) { Model.ProgramUpgrade program = DataRowToAMS_ProgramUpgradeListModel(dal_ProgramUpgrade.GetList(string.Format(" id={0}", cmdModel.CommandId.Value)).Tables[0].Rows[0]); cmd.ContentName = ((AMS.Model.Enum.SeatManageSubsystem)program.Application).ToString(); cmd.ContentDescribe = program.Remark; cmd.ContentID = program.Id; } break; case Model.Enum.CommandType.SlipCustomer: if (dal_SlipCustomer.GetList(string.Format(" id={0}", cmdModel.CommandId.Value)).Tables[0].Rows.Count > 0) { Model.AMS_SlipCustomer slipcustomer = DataRowToAMS_SlipCustomerModel(dal_SlipCustomerView.GetList(string.Format(" id={0}", cmdModel.CommandId.Value)).Tables[0].Rows[0]); cmd.ContentName = slipcustomer.SlipName; cmd.ContentNumber = slipcustomer.Number; cmd.ContentDescribe = slipcustomer.Describe; cmd.ContentID = slipcustomer.Id; } break; case Model.Enum.CommandType.TitleAd: if (Dal_TitleAd.GetList(string.Format(" id={0}", cmdModel.CommandId.Value)).Tables[0].Rows.Count > 0) { Model.AMS_TitleAd titleAd = DataRowToAMS_TitleAd(Dal_TitleAd.GetList(string.Format(" id={0}", cmdModel.CommandId.Value)).Tables[0].Rows[0]); cmd.ContentName = titleAd.Name; cmd.ContentNumber = titleAd.Num; cmd.ContentID = titleAd.Id; } break; case Model.Enum.CommandType.RollTitles: if (dal.GetModel(string.Format(" id={0}", cmdModel.CommandId.Value)).Tables[0].Rows.Count > 0) { Model.AMS_RollTitles titleAd = DataRowToAMS_RollTitles(dal.GetModel(string.Format(" id={0}", cmdModel.CommandId.Value)).Tables[0].Rows[0]); cmd.ContentName = titleAd.Name; cmd.ContentNumber = titleAd.Num; cmd.ContentID = titleAd.ID; } break; } cmd.Command = cmdModel.Command; cmd.FinishFlag = cmdModel.FinishFlag; cmd.FinishTime = cmdModel.FinishTime; cmd.ID = cmdModel.ID; cmd.OperatorBranchName = cmdModel.OperatorBranchName; cmd.OperatorLoginId = cmdModel.OperatorLoginId; cmd.OperatorPwd = cmdModel.OperatorPwd; cmd.OperatorRemark = cmdModel.OperatorRemark; cmd.OperatorName = cmdModel.OperatorName; cmd.ReleaseTime = cmdModel.ReleaseTime; cmd.SchoolAddress = cmdModel.SchoolAddress; cmd.SchoolCardInfo = cmdModel.SchoolCardInfo; cmd.SchoolConnectionString = cmdModel.SchoolConnectionString; cmd.SchoolDescribe = cmdModel.SchoolDTUip; cmd.SchoolInterfaceInfo = cmdModel.SchoolInterfaceInfo; cmd.SchoolLinkMan = cmdModel.SchoolLinkMan; cmd.SchoolName = cmdModel.SchoolName; cmd.SchoolNum = cmdModel.SchoolNum; cmd.SchoolProvince = cmdModel.SchoolProvince; commandDetailList.Add(cmd); } return(commandDetailList); }