/// <summary> /// 更新一条数据 /// </summary> public bool Update(AMS.Model.AMS_AdvertisementSchoolCopy model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update AMS_AdvertisementSchoolCopy set "); strSql.Append("Num=@Num,"); strSql.Append("Name=@Name,"); strSql.Append("EffectDate=@EffectDate,"); strSql.Append("EndDate=@EndDate,"); strSql.Append("OperatorName=@OperatorName,"); strSql.Append("CustomerID=@CustomerID,"); strSql.Append("Type=@Type,"); strSql.Append("AdContent=@AdContent,"); strSql.Append("SchoolID=@SchoolID,"); strSql.Append("OriginalID=@OriginalID,"); strSql.Append("IsNew=@IsNew"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@Num", SqlDbType.NVarChar, 50), new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@EffectDate", SqlDbType.DateTime), new SqlParameter("@EndDate", SqlDbType.DateTime), new SqlParameter("@OperatorName", SqlDbType.Int, 4), new SqlParameter("@CustomerID", SqlDbType.Int, 4), new SqlParameter("@Type", SqlDbType.Int, 4), new SqlParameter("@AdContent", SqlDbType.Text), new SqlParameter("@SchoolID", SqlDbType.Int, 4), new SqlParameter("@OriginalID", SqlDbType.Int, 4), new SqlParameter("@IsNew", SqlDbType.Bit, 1), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.Num; parameters[1].Value = model.Name; parameters[2].Value = model.EffectDate; parameters[3].Value = model.EndDate; parameters[4].Value = model.OperatorID; parameters[5].Value = model.CustomerID; parameters[6].Value = (int)model.Type; parameters[7].Value = model.AdContent; parameters[8].Value = model.SchoolID; parameters[9].Value = model.OriginalID; parameters[10].Value = model.IsNew; parameters[11].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(AMS.Model.AMS_AdvertisementSchoolCopy model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into AMS_AdvertisementSchoolCopy("); strSql.Append("Num,Name,EffectDate,EndDate,OperatorName,CustomerID,Type,AdContent,SchoolID,OriginalID,IsNew)"); strSql.Append(" values ("); strSql.Append("@Num,@Name,@EffectDate,@EndDate,@OperatorName,@CustomerID,@Type,@AdContent,@SchoolID,@OriginalID,@IsNew)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Num", SqlDbType.NVarChar, 50), new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@EffectDate", SqlDbType.DateTime), new SqlParameter("@EndDate", SqlDbType.DateTime), new SqlParameter("@OperatorName", SqlDbType.Int, 4), new SqlParameter("@CustomerID", SqlDbType.Int, 4), new SqlParameter("@Type", SqlDbType.Int, 4), new SqlParameter("@AdContent", SqlDbType.Text), new SqlParameter("@SchoolID", SqlDbType.Int, 4), new SqlParameter("@OriginalID", SqlDbType.Int, 4), new SqlParameter("@IsNew", SqlDbType.Bit, 1) }; parameters[0].Value = model.Num; parameters[1].Value = model.Name; parameters[2].Value = model.EffectDate; parameters[3].Value = model.EndDate; parameters[4].Value = model.OperatorID; parameters[5].Value = model.CustomerID; parameters[6].Value = (int)model.Type; parameters[7].Value = model.AdContent; parameters[8].Value = model.SchoolID; parameters[9].Value = model.OriginalID; parameters[10].Value = model.IsNew; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public AMS.Model.AMS_AdvertisementSchoolCopy GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 from View_AdvertisementCopy "); strSql.Append(" where "); SqlParameter[] parameters = { }; AMS.Model.AMS_AdvertisementSchoolCopy model = new AMS.Model.AMS_AdvertisementSchoolCopy(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(model); } else { return(null); } }
public static bool Get(int AdID) { try { AMS.Model.AMS_AdvertisementSchoolCopy adModel = AMS.ServiceProxy.AdvertisementOperationService.GetSchoolAdvert(AdID); if (adModel != null) { //上传下载类 AMS.ServiceProxy.FileOperate advertfileOperate = new AMS.ServiceProxy.FileOperate(); SeatManage.Bll.FileOperate seatmanagefileOperate = new SeatManage.Bll.FileOperate(); seatmanagefileOperate.Downloaded += new SeatManage.Bll.EventHandleFileTransport(seatmanagefileOperate_Downloaded); advertfileOperate.DownloadError += new AMS.ServiceProxy.EventHandleFileOperateError(fileOperate_DownloadError); //创建model SeatManage.ClassModel.AMS_Advertisement model = new SeatManage.ClassModel.AMS_Advertisement(); model.AdContent = adModel.AdContent; model.EffectDate = adModel.EffectDate; model.EndDate = adModel.EndDate; model.ImageFilePath = SeatManage.ClassModel.AMS_Advertisement.GetDownloadFile(adModel.AdContent); model.Name = adModel.Name; model.Num = adModel.Num; model.Type = (SeatManage.EnumType.AdType)System.Enum.Parse(typeof(SeatManage.EnumType.AdType), adModel.Type.ToString()); //图片下载 foreach (string file in model.ImageFilePath) { string fileFullName = string.Format(@"{0}{1}", ServiceSet.TempFilePath, file); //开始下载文件 if (!File.Exists(fileFullName)) { bool downloadResult = false; string error = advertfileOperate.FileDownLoad(fileFullName, file, (SeatManage.EnumType.SeatManageSubsystem)System.Enum.Parse(typeof(SeatManage.EnumType.SeatManageSubsystem), model.Type.ToString())); if (error == "") { downloadResult = true; } else { downloadResult = false; } if (!downloadResult) { //下载失败,直接返回false return(false); } } } //图片上传 foreach (string file in model.ImageFilePath) { string fileFullName = string.Format(@"{0}{1}", ServiceSet.TempFilePath, file); //文件下载完成,执行上传操作 bool uploadResult = seatmanagefileOperate.UpdateFile(fileFullName, file, (SeatManage.EnumType.SeatManageSubsystem)System.Enum.Parse(typeof(SeatManage.EnumType.SeatManageSubsystem), model.Type.ToString())); if (!uploadResult) { //上传失败,直接返回false,不再尝试其他操作 return(false); } } SeatManage.ClassModel.AMS_Advertisement sameModel = SeatManage.Bll.AdvertisementOperation.GetAdModel(model.Num, model.Type); string errorMessage = ""; if (sameModel == null) { errorMessage = SeatManage.Bll.AdvertisementOperation.AddAdModel(model); } else { model.ID = sameModel.ID; errorMessage = SeatManage.Bll.AdvertisementOperation.UpdateAdModel(model); } if (errorMessage != "") { SeatManage.SeatManageComm.WriteLog.Write(string.Format("更新广告遇到错误:{0}", errorMessage)); return(false); } } return(true); } catch (Exception ex) { throw ex; } }
/// <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; } }
/// <summary> /// 得到一个对象实体 /// </summary> public AMS.Model.AMS_AdvertisementSchoolCopy GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,Num,Name,EffectDate,EndDate,OperatorName,CustomerID,Type,AdContent,SchoolID,OriginalID,IsNew from AMS_AdvertisementSchoolCopy "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; AMS.Model.AMS_AdvertisementSchoolCopy model = new AMS.Model.AMS_AdvertisementSchoolCopy(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } if (ds.Tables[0].Rows[0]["Num"] != null && ds.Tables[0].Rows[0]["Num"].ToString() != "") { model.Num = ds.Tables[0].Rows[0]["Num"].ToString(); } if (ds.Tables[0].Rows[0]["Name"] != null && ds.Tables[0].Rows[0]["Name"].ToString() != "") { model.Name = ds.Tables[0].Rows[0]["Name"].ToString(); } if (ds.Tables[0].Rows[0]["EffectDate"] != null && ds.Tables[0].Rows[0]["EffectDate"].ToString() != "") { model.EffectDate = DateTime.Parse(ds.Tables[0].Rows[0]["EffectDate"].ToString()); } if (ds.Tables[0].Rows[0]["EndDate"] != null && ds.Tables[0].Rows[0]["EndDate"].ToString() != "") { model.EndDate = DateTime.Parse(ds.Tables[0].Rows[0]["EndDate"].ToString()); } if (ds.Tables[0].Rows[0]["OperatorName"] != null && ds.Tables[0].Rows[0]["OperatorName"].ToString() != "") { model.OperatorID = int.Parse(ds.Tables[0].Rows[0]["OperatorName"].ToString()); } if (ds.Tables[0].Rows[0]["CustomerID"] != null && ds.Tables[0].Rows[0]["CustomerID"].ToString() != "") { model.CustomerID = int.Parse(ds.Tables[0].Rows[0]["CustomerID"].ToString()); } if (ds.Tables[0].Rows[0]["Type"] != null && ds.Tables[0].Rows[0]["Type"].ToString() != "") { model.Type = (AMS.Model.Enum.AdType) int.Parse(ds.Tables[0].Rows[0]["Type"].ToString()); } if (ds.Tables[0].Rows[0]["AdContent"] != null && ds.Tables[0].Rows[0]["AdContent"].ToString() != "") { model.AdContent = ds.Tables[0].Rows[0]["AdContent"].ToString(); } if (ds.Tables[0].Rows[0]["SchoolID"] != null && ds.Tables[0].Rows[0]["SchoolID"].ToString() != "") { model.SchoolID = int.Parse(ds.Tables[0].Rows[0]["SchoolID"].ToString()); } if (ds.Tables[0].Rows[0]["OriginalID"] != null && ds.Tables[0].Rows[0]["OriginalID"].ToString() != "") { model.OriginalID = int.Parse(ds.Tables[0].Rows[0]["OriginalID"].ToString()); } if (ds.Tables[0].Rows[0]["IsNew"] != null && ds.Tables[0].Rows[0]["IsNew"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsNew"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsNew"].ToString().ToLower() == "true")) { model.IsNew = true; } else { model.IsNew = false; } } return(model); } else { return(null); } }