示例#1
0
        public bool Save(ExhibitionEntity item)
        {
            bool returnValue = false;

            if (item.ExhibitionID > 0)
            {
                returnValue = dao.Update(item);
            }
            else
            {
                returnValue = dao.Add(item) > 0;
            }

            return(returnValue);
        }
示例#2
0
        public async Task <ExhibitionResultModel> UpdateExhibition(ExhibitionDomainModel updateExhibition)
        {
            var data = await _exhibitionRepository.GetByIdAsync(updateExhibition.ExhibitionId);

            ExhibitionEntity exhibition = new ExhibitionEntity
            {
                ExhibitionId     = updateExhibition.ExhibitionId,
                AuditoriumId     = updateExhibition.AuditoriumId,
                ExhibitionName   = updateExhibition.ExhibitionName,
                TypeOfExhibition = updateExhibition.TypeOfExhibition,
                StartTime        = updateExhibition.StartTime,
                EndTime          = updateExhibition.EndTime
            };


            var exhibitionUpdate = _exhibitionRepository.Update(exhibition);

            if (exhibitionUpdate == null)
            {
                return(new ExhibitionResultModel
                {
                    IsSuccessful = false,
                    ErrorMessage = Messages.EXHIBITION_UPDATE_ERROR,
                    Exhibition = null
                });
            }

            _exhibitionRepository.Save();


            ExhibitionResultModel result = new ExhibitionResultModel
            {
                IsSuccessful = true,
                ErrorMessage = null,
                Exhibition   = new ExhibitionDomainModel
                {
                    ExhibitionId     = exhibitionUpdate.ExhibitionId,
                    AuditoriumId     = exhibitionUpdate.AuditoriumId,
                    ExhibitionName   = exhibitionUpdate.ExhibitionName,
                    TypeOfExhibition = exhibitionUpdate.TypeOfExhibition,
                    StartTime        = exhibitionUpdate.StartTime,
                    EndTime          = exhibitionUpdate.EndTime,
                }
            };

            return(result);
        }
        private void InitExhibition()
        {
            BCtrl_Exhibition bll = new BCtrl_Exhibition();

            item = bll.GetEntity(id);
            if (item != null)
            {
                this.txt_exhibitionname.Value         = item.ExhibitionTitle;
                this.txt_exhibitionlocation.Value     = item.ExhibitionLocation;
                this.txt_starttime.Value              = item.ExhibitionStartTime.ToString("yyyy-MM-dd HH:mm:ss");
                this.txt_endTime.Value                = item.ExhibitionEndTime.ToString("yyyy-MM-dd HH:mm:ss");
                this.txt_exhibitionaddress.Value      = item.ExhibitionAddress;
                this.txt_exhibitiontraffic.Value      = item.ExhibitionTraffic;
                this.txt_exhibitionabstract.Value     = item.ExhibitionAbstract;
                this.txt_exhibitionabout.Value        = item.ExhibitionAbout;
                this.txt_exhibitionbooklistdesc.Value = item.ExhibitionBookListDesc;
                //this.txt_advertisementtitle.Value = item.AdvertisementList.ToString();
                if (item.AdvertisementList != null)
                {
                    string tmploc = "";
                    foreach (AdvertisementEntity adv in item.AdvertisementList)
                    {
                        tmploc += adv.AdvertisementTitle + "\n";
                    }
                    this.txt_advertisementtitle.Value = tmploc;
                }

                this.chk_statetype.Checked          = item.StateTypeID == 1;
                this.chk_ispublish.Checked          = item.IsPublish;
                this.chk_isdownloadbooklist.Checked = item.IsDownloadBookList;

                this.txt_booklistdownloadurl.Value = item.BookListDownloadUrl;

                this.hid_eid.Value    = item.ExhibitionID.ToString();
                this.hid_imgurl.Value = item.ExhibitionLogoUrl;
            }
        }
示例#4
0
        public int Add(ExhibitionEntity item)
        {
            int returnValue = 0;

            SqlTransaction trans = null;

            using (SqlConnection con = new SqlConnection(SQlHelper.MyConnectStr))
            {
                try
                {
                    con.Open();
                    trans = con.BeginTransaction();

                    StringBuilder strSql = new StringBuilder();
                    strSql.Append("insert into M_Exhibition_Main(");
                    strSql.Append("ExhibitionTitle,ExhibitionLogoUrl,ExhibitionStartTime,ExhibitionEndTime,ExhibitionAddress,ExhibitionTraffic,ExhibitionLocation,ExhibitionAbstract,ExhibitionAbout,ExhibitionOrder,ExhibitionBookListDesc,StateTypeID,IsPublish,BookListDownloadUrl,IsDownloadBookList,CreateUserID,CreateTime)");
                    strSql.Append(" values (");
                    strSql.Append("@ExhibitionTitle,@ExhibitionLogoUrl,@ExhibitionStartTime,@ExhibitionEndTime,@ExhibitionAddress,@ExhibitionTraffic,@ExhibitionLocation,@ExhibitionAbstract,@ExhibitionAbout,@ExhibitionOrder,@ExhibitionBookListDesc,@StateTypeID,@IsPublish,@BookListDownloadUrl,@IsDownloadBookList,@CreateUserID,@CreateTime)");
                    strSql.Append(";select @@IDENTITY");
                    SqlParameter[] parameters =
                    {
                        new SqlParameter("@ExhibitionTitle",        SqlDbType.NVarChar,    50),
                        new SqlParameter("@ExhibitionLogoUrl",      SqlDbType.VarChar,    100),
                        new SqlParameter("@ExhibitionStartTime",    SqlDbType.DateTime),
                        new SqlParameter("@ExhibitionEndTime",      SqlDbType.DateTime),
                        new SqlParameter("@ExhibitionAddress",      SqlDbType.NVarChar,   100),
                        new SqlParameter("@ExhibitionTraffic",      SqlDbType.NVarChar,   100),
                        new SqlParameter("@ExhibitionLocation",     SqlDbType.NVarChar,   100),
                        new SqlParameter("@ExhibitionAbstract",     SqlDbType.NVarChar,  1000),
                        new SqlParameter("@ExhibitionAbout",        SqlDbType.NVarChar,   500),
                        new SqlParameter("@ExhibitionOrder",        SqlDbType.Int,          4),
                        new SqlParameter("@ExhibitionBookListDesc", SqlDbType.NVarChar,   500),
                        new SqlParameter("@StateTypeID",            SqlDbType.Int,          4),
                        new SqlParameter("@IsPublish",              SqlDbType.Bit,          1),
                        new SqlParameter("@BookListDownloadUrl",    SqlDbType.NVarChar,   255),
                        new SqlParameter("@IsDownloadBookList",     SqlDbType.Bit,          1),
                        new SqlParameter("@CreateUserID",           SqlDbType.VarChar,     20),
                        new SqlParameter("@CreateTime",             SqlDbType.DateTime)
                    };
                    parameters[0].Value  = item.ExhibitionTitle;
                    parameters[1].Value  = item.ExhibitionLogoUrl;
                    parameters[2].Value  = item.ExhibitionStartTime;
                    parameters[3].Value  = item.ExhibitionEndTime;
                    parameters[4].Value  = item.ExhibitionAddress;
                    parameters[5].Value  = item.ExhibitionTraffic;
                    parameters[6].Value  = item.ExhibitionLocation;
                    parameters[7].Value  = item.ExhibitionAbstract;
                    parameters[8].Value  = item.ExhibitionAbout;
                    parameters[9].Value  = item.ExhibitionOrder;
                    parameters[10].Value = item.ExhibitionBookListDesc;
                    parameters[11].Value = item.StateTypeID;
                    parameters[12].Value = item.IsPublish;
                    parameters[13].Value = item.BookListDownloadUrl;
                    parameters[14].Value = item.IsDownloadBookList;
                    parameters[15].Value = item.CreateUserID;
                    parameters[16].Value = item.CreateTime;

                    object objrec = SQlHelper.ExecuteScalar(trans, CommandType.Text, strSql.ToString(), parameters);
                    if (objrec != null)
                    {
                        //写入位置
                        if (item.AdvertisementList != null)
                        {
                            foreach (AdvertisementEntity _loc in item.AdvertisementList)
                            {
                                StringBuilder strSqladv = new StringBuilder();
                                strSqladv.Append("insert into M_Exhibition_Advertisement(");
                                strSqladv.Append("ExhibitionID,AdvertisementUrl,AdvertisementTitle,AdvertisementOrder,StateTypeID,CreateUserID,CreateTime)");
                                strSqladv.Append(" values (");
                                strSqladv.Append("@ExhibitionID,@AdvertisementUrl,@AdvertisementTitle,@AdvertisementOrder,@StateTypeID,@CreateUserID,@CreateTime)");
                                strSqladv.Append(";select @@IDENTITY");
                                SqlParameter[] parametersadv =
                                {
                                    new SqlParameter("@ExhibitionID",       SqlDbType.Int,        4),
                                    new SqlParameter("@AdvertisementUrl",   SqlDbType.NVarChar, 500),
                                    new SqlParameter("@AdvertisementTitle", SqlDbType.NVarChar, 200),
                                    new SqlParameter("@AdvertisementOrder", SqlDbType.Int,        4),
                                    new SqlParameter("@StateTypeID",        SqlDbType.Int,        4),
                                    new SqlParameter("@CreateUserID",       SqlDbType.VarChar,   20),
                                    new SqlParameter("@CreateTime",         SqlDbType.DateTime)
                                };
                                parametersadv[0].Value = int.Parse(objrec.ToString());
                                parametersadv[1].Value = _loc.AdvertisementUrl;
                                parametersadv[2].Value = _loc.AdvertisementTitle;
                                parametersadv[3].Value = _loc.AdvertisementOrder;
                                parametersadv[4].Value = _loc.StateTypeID;
                                parametersadv[5].Value = _loc.CreateUserID;
                                parametersadv[6].Value = _loc.CreateTime;


                                SQlHelper.ExecuteNonQuery(trans, CommandType.Text, strSqladv.ToString(), parametersadv);
                            }
                        }

                        trans.Commit();
                        returnValue = int.Parse(objrec.ToString());
                    }
                }
                catch (Exception ex)
                {
                    if (trans != null)
                    {
                        trans.Rollback();
                    }
                    LogUtil.WriteLog(ex);
                }
            }

            return(returnValue);
        }
示例#5
0
        public bool Update(ExhibitionEntity item)
        {
            bool           returnValue = false;
            SqlTransaction trans       = null;

            using (SqlConnection con = new SqlConnection(SQlHelper.MyConnectStr))
            {
                try
                {
                    con.Open();
                    trans = con.BeginTransaction();
                    //清除位置记录
                    StringBuilder strDelLocSql = new StringBuilder();
                    strDelLocSql.AppendFormat(@"DELETE FROM M_Exhibition_Advertisement WHERE [ExhibitionID] = {0}", item.ExhibitionID.ToString());
                    SQlHelper.ExecuteNonQuery(trans, CommandType.Text, strDelLocSql.ToString(), null);

                    StringBuilder strSql = new StringBuilder();
                    strSql.Append("update M_Exhibition_Main set ");
                    strSql.Append("ExhibitionTitle=@ExhibitionTitle,");
                    strSql.Append("ExhibitionLogoUrl=@ExhibitionLogoUrl,");
                    strSql.Append("ExhibitionStartTime=@ExhibitionStartTime,");
                    strSql.Append("ExhibitionEndTime=@ExhibitionEndTime,");
                    strSql.Append("ExhibitionAddress=@ExhibitionAddress,");
                    strSql.Append("ExhibitionTraffic=@ExhibitionTraffic,");
                    strSql.Append("ExhibitionLocation=@ExhibitionLocation,");
                    strSql.Append("ExhibitionAbstract=@ExhibitionAbstract,");
                    strSql.Append("ExhibitionAbout=@ExhibitionAbout,");
                    strSql.Append("ExhibitionOrder=@ExhibitionOrder,");
                    strSql.Append("ExhibitionBookListDesc=@ExhibitionBookListDesc,");
                    strSql.Append("StateTypeID=@StateTypeID,");
                    strSql.Append("IsPublish=@IsPublish,");
                    strSql.Append("BookListDownloadUrl=@BookListDownloadUrl,");
                    strSql.Append("IsDownloadBookList=@IsDownloadBookList");
                    strSql.Append(" where ExhibitionID=@ExhibitionID");
                    SqlParameter[] parameters =
                    {
                        new SqlParameter("@ExhibitionTitle",        SqlDbType.NVarChar,    50),
                        new SqlParameter("@ExhibitionLogoUrl",      SqlDbType.VarChar,    100),
                        new SqlParameter("@ExhibitionStartTime",    SqlDbType.DateTime),
                        new SqlParameter("@ExhibitionEndTime",      SqlDbType.DateTime),
                        new SqlParameter("@ExhibitionAddress",      SqlDbType.NVarChar,   100),
                        new SqlParameter("@ExhibitionTraffic",      SqlDbType.NVarChar,   100),
                        new SqlParameter("@ExhibitionLocation",     SqlDbType.NVarChar,   100),
                        new SqlParameter("@ExhibitionAbstract",     SqlDbType.NVarChar,  1000),
                        new SqlParameter("@ExhibitionAbout",        SqlDbType.NVarChar,   500),
                        new SqlParameter("@ExhibitionOrder",        SqlDbType.Int,          4),
                        new SqlParameter("@ExhibitionBookListDesc", SqlDbType.NVarChar,   500),
                        new SqlParameter("@StateTypeID",            SqlDbType.Int,          4),
                        new SqlParameter("@IsPublish",              SqlDbType.Bit,          1),
                        new SqlParameter("@BookListDownloadUrl",    SqlDbType.NVarChar,   255),
                        new SqlParameter("@IsDownloadBookList",     SqlDbType.Bit,          1),
                        new SqlParameter("@ExhibitionID",           SqlDbType.Int, 4)
                    };
                    parameters[0].Value  = item.ExhibitionTitle;
                    parameters[1].Value  = item.ExhibitionLogoUrl;
                    parameters[2].Value  = item.ExhibitionStartTime;
                    parameters[3].Value  = item.ExhibitionEndTime;
                    parameters[4].Value  = item.ExhibitionAddress;
                    parameters[5].Value  = item.ExhibitionTraffic;
                    parameters[6].Value  = item.ExhibitionLocation;
                    parameters[7].Value  = item.ExhibitionAbstract;
                    parameters[8].Value  = item.ExhibitionAbout;
                    parameters[9].Value  = item.ExhibitionOrder;
                    parameters[10].Value = item.ExhibitionBookListDesc;
                    parameters[11].Value = item.StateTypeID;
                    parameters[12].Value = item.IsPublish;
                    parameters[13].Value = item.BookListDownloadUrl;
                    parameters[14].Value = item.IsDownloadBookList;
                    parameters[15].Value = item.ExhibitionID;

                    SQlHelper.ExecuteNonQuery(trans, CommandType.Text, strSql.ToString(), parameters);

                    //写入位置
                    if (item.AdvertisementList != null)
                    {
                        foreach (AdvertisementEntity _loc in item.AdvertisementList)
                        {
                            StringBuilder strSqladv = new StringBuilder();
                            strSqladv.Append("insert into M_Exhibition_Advertisement(");
                            strSqladv.Append("ExhibitionID,AdvertisementUrl,AdvertisementTitle,AdvertisementOrder,StateTypeID,CreateUserID,CreateTime)");
                            strSqladv.Append(" values (");
                            strSqladv.Append("@ExhibitionID,@AdvertisementUrl,@AdvertisementTitle,@AdvertisementOrder,@StateTypeID,@CreateUserID,@CreateTime)");
                            strSqladv.Append(";select @@IDENTITY");
                            SqlParameter[] parametersadv =
                            {
                                new SqlParameter("@ExhibitionID",       SqlDbType.Int,        4),
                                new SqlParameter("@AdvertisementUrl",   SqlDbType.NVarChar, 500),
                                new SqlParameter("@AdvertisementTitle", SqlDbType.NVarChar, 200),
                                new SqlParameter("@AdvertisementOrder", SqlDbType.Int,        4),
                                new SqlParameter("@StateTypeID",        SqlDbType.Int,        4),
                                new SqlParameter("@CreateUserID",       SqlDbType.VarChar,   20),
                                new SqlParameter("@CreateTime",         SqlDbType.DateTime)
                            };
                            parametersadv[0].Value = item.ExhibitionID;
                            parametersadv[1].Value = _loc.AdvertisementUrl;
                            parametersadv[2].Value = _loc.AdvertisementTitle;
                            parametersadv[3].Value = _loc.AdvertisementOrder;
                            parametersadv[4].Value = _loc.StateTypeID;
                            parametersadv[5].Value = _loc.CreateUserID;
                            parametersadv[6].Value = _loc.CreateTime;

                            SQlHelper.ExecuteNonQuery(trans, CommandType.Text, strSqladv.ToString(), parametersadv);
                        }

                        trans.Commit();
                        returnValue = true;
                    }
                }
                catch (Exception ex)
                {
                    if (trans != null)
                    {
                        trans.Rollback();
                    }
                    LogUtil.WriteLog(ex);
                }
            }

            return(returnValue);
        }
示例#6
0
        public async Task <ExhibitionResultModel> CreateExhibition(ExhibitionDomainModel exhibitionModel)
        {
            ExhibitionEntity newExhibition = new ExhibitionEntity
            {
                ExhibitionId     = exhibitionModel.ExhibitionId,
                ExhibitionName   = exhibitionModel.ExhibitionName,
                AuditoriumId     = exhibitionModel.AuditoriumId,
                TypeOfExhibition = exhibitionModel.TypeOfExhibition,
                StartTime        = exhibitionModel.StartTime,
                EndTime          = exhibitionModel.EndTime
            };
            bool auditorium        = false;
            var  listOfAuditoriums = await _auditoriumRepository.GetAll();

            foreach (var item in listOfAuditoriums)
            {
                if (item.AuditoriumId == exhibitionModel.AuditoriumId)
                {
                    auditorium = true;
                }
                ;
            }
            if (auditorium == false)
            {
                return(new ExhibitionResultModel
                {
                    IsSuccessful = false,
                    ErrorMessage = Messages.AUDITORIUM_WITH_THIS_ID_DOES_NOT_EXIST,
                    Exhibition = null
                });
            }
            if (exhibitionModel.StartTime < DateTime.Now || exhibitionModel.EndTime < DateTime.Now || exhibitionModel.EndTime < exhibitionModel.StartTime)
            {
                return(new ExhibitionResultModel
                {
                    IsSuccessful = false,
                    ErrorMessage = Messages.START_MUST_BE_IN_THE_FUTURE,
                    Exhibition = null
                });
            }
            var exhibition = _exhibitionRepository.Insert(newExhibition);

            if (exhibition == null)
            {
                return(new ExhibitionResultModel
                {
                    IsSuccessful = false,
                    ErrorMessage = Messages.EXHIBITION_WITH_THIS_ID_ALREADY_EXISTS,
                    Exhibition = null
                });
            }

            ExhibitionResultModel result = new ExhibitionResultModel
            {
                IsSuccessful = true,
                ErrorMessage = null,
                Exhibition   = new ExhibitionDomainModel
                {
                    ExhibitionId     = exhibition.ExhibitionId,
                    ExhibitionName   = exhibition.ExhibitionName,
                    AuditoriumId     = exhibition.AuditoriumId,
                    TypeOfExhibition = exhibition.TypeOfExhibition,
                    StartTime        = exhibition.StartTime,
                    EndTime          = exhibition.EndTime
                }
            };

            return(result);
        }
示例#7
0
        public ExhibitionEntity GetEntity(int id)
        {
            ExhibitionEntity item = null;

            DataSet ds = this.GetExhibitionDataSet(id);

            if (ds != null && ds.Tables.Count == 2)
            {
                if (ds.Tables[0].Rows.Count > 0)
                {
                    item = new ExhibitionEntity();
                    DataRow row = ds.Tables[0].Rows[0];

                    if (row["ExhibitionID"] != null && row["ExhibitionID"].ToString() != "")
                    {
                        item.ExhibitionID = int.Parse(row["ExhibitionID"].ToString());
                    }
                    if (row["ExhibitionTitle"] != null)
                    {
                        item.ExhibitionTitle = row["ExhibitionTitle"].ToString();
                    }
                    if (row["ExhibitionLogoUrl"] != null)
                    {
                        item.ExhibitionLogoUrl = row["ExhibitionLogoUrl"].ToString();
                    }
                    if (row["ExhibitionStartTime"] != null && row["ExhibitionStartTime"].ToString() != "")
                    {
                        item.ExhibitionStartTime = DateTime.Parse(row["ExhibitionStartTime"].ToString());
                    }
                    if (row["ExhibitionEndTime"] != null && row["ExhibitionEndTime"].ToString() != "")
                    {
                        item.ExhibitionEndTime = DateTime.Parse(row["ExhibitionEndTime"].ToString());
                    }
                    if (row["ExhibitionAddress"] != null)
                    {
                        item.ExhibitionAddress = row["ExhibitionAddress"].ToString();
                    }
                    if (row["ExhibitionTraffic"] != null)
                    {
                        item.ExhibitionTraffic = row["ExhibitionTraffic"].ToString();
                    }
                    if (row["ExhibitionLocation"] != null)
                    {
                        item.ExhibitionLocation = row["ExhibitionLocation"].ToString();
                    }
                    if (row["ExhibitionAbstract"] != null)
                    {
                        item.ExhibitionAbstract = row["ExhibitionAbstract"].ToString();
                    }
                    if (row["ExhibitionAbout"] != null)
                    {
                        item.ExhibitionAbout = row["ExhibitionAbout"].ToString();
                    }
                    if (row["ExhibitionOrder"] != null && row["ExhibitionOrder"].ToString() != "")
                    {
                        item.ExhibitionOrder = int.Parse(row["ExhibitionOrder"].ToString());
                    }
                    if (row["ExhibitionBookListDesc"] != null)
                    {
                        item.ExhibitionBookListDesc = row["ExhibitionBookListDesc"].ToString();
                    }
                    if (row["StateTypeID"] != null && row["StateTypeID"].ToString() != "")
                    {
                        item.StateTypeID = int.Parse(row["StateTypeID"].ToString());
                    }
                    if (row["IsPublish"] != null && row["IsPublish"].ToString() != "")
                    {
                        if ((row["IsPublish"].ToString() == "1") || (row["IsPublish"].ToString().ToLower() == "true"))
                        {
                            item.IsPublish = true;
                        }
                        else
                        {
                            item.IsPublish = false;
                        }
                    }
                    if (row["BookListDownloadUrl"] != null)
                    {
                        item.BookListDownloadUrl = row["BookListDownloadUrl"].ToString();
                    }
                    if (row["IsDownloadBookList"] != null && row["IsDownloadBookList"].ToString() != "")
                    {
                        if ((row["IsDownloadBookList"].ToString() == "1") || (row["IsDownloadBookList"].ToString().ToLower() == "true"))
                        {
                            item.IsDownloadBookList = true;
                        }
                        else
                        {
                            item.IsDownloadBookList = false;
                        }
                    }
                    if (row["CreateUserID"] != null)
                    {
                        item.CreateUserID = row["CreateUserID"].ToString();
                    }
                    if (row["CreateTime"] != null && row["CreateTime"].ToString() != "")
                    {
                        item.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
                    }

                    item.AdvertisementList = new List <AdvertisementEntity>();
                    if (ds.Tables[1].Rows.Count > 0)
                    {
                        foreach (DataRow dra in ds.Tables[1].Rows)
                        {
                            if (dra != null)
                            {
                                AdvertisementEntity _item = new AdvertisementEntity();
                                if (dra["AdvertisementID"] != null && dra["AdvertisementID"].ToString() != "")
                                {
                                    _item.AdvertisementID = int.Parse(dra["AdvertisementID"].ToString());
                                }
                                if (dra["ExhibitionID"] != null && dra["ExhibitionID"].ToString() != "")
                                {
                                    _item.ExhibitionID = int.Parse(dra["ExhibitionID"].ToString());
                                }
                                if (dra["AdvertisementUrl"] != null)
                                {
                                    _item.AdvertisementUrl = dra["AdvertisementUrl"].ToString();
                                }
                                if (dra["AdvertisementTitle"] != null)
                                {
                                    _item.AdvertisementTitle = dra["AdvertisementTitle"].ToString();
                                }
                                if (dra["AdvertisementOrder"] != null && dra["AdvertisementOrder"].ToString() != "")
                                {
                                    _item.AdvertisementOrder = int.Parse(dra["AdvertisementOrder"].ToString());
                                }
                                if (dra["StateTypeID"] != null && dra["StateTypeID"].ToString() != "")
                                {
                                    _item.StateTypeID = int.Parse(dra["StateTypeID"].ToString());
                                }
                                if (dra["CreateUserID"] != null)
                                {
                                    _item.CreateUserID = dra["CreateUserID"].ToString();
                                }
                                if (dra["CreateTime"] != null && dra["CreateTime"].ToString() != "")
                                {
                                    _item.CreateTime = DateTime.Parse(dra["CreateTime"].ToString());
                                }

                                item.AdvertisementList.Add(_item);
                            }
                        }
                    }
                }
            }

            return(item);
        }
        protected void btn_submit_Click(object sender, EventArgs e)
        {
            StringBuilder strJs = new StringBuilder();

            strJs.Append("<script type='text/javascript'>");
            strJs.Append("bootbox.alert('保存失败');");
            strJs.Append("</script>");

            try
            {
                #region 填充
                int eid = 0;
                int.TryParse(this.hid_eid.Value, out eid);
                ExhibitionEntity item = new ExhibitionEntity()
                {
                    ExhibitionID           = eid,
                    ExhibitionTitle        = this.txt_exhibitionname.Value,
                    ExhibitionLocation     = this.txt_exhibitionlocation.Value,
                    ExhibitionStartTime    = Convert.ToDateTime(this.txt_starttime.Value),
                    ExhibitionEndTime      = Convert.ToDateTime(this.txt_endTime.Value),
                    ExhibitionAddress      = this.txt_exhibitionaddress.Value,
                    ExhibitionTraffic      = this.txt_exhibitiontraffic.Value,
                    ExhibitionAbstract     = this.txt_exhibitionabstract.Value,
                    ExhibitionAbout        = this.txt_exhibitionabout.Value,
                    ExhibitionBookListDesc = this.txt_exhibitionbooklistdesc.Value,
                    BookListDownloadUrl    = this.txt_booklistdownloadurl.Value,
                    CreateTime             = DateTime.Now,
                    CreateUserID           = this.CurrentAdmin.Sys_UserID,
                    ExhibitionOrder        = 1000,
                    StateTypeID            = this.chk_statetype.Checked ? 1 : 0,
                    IsPublish          = this.chk_ispublish.Checked,
                    IsDownloadBookList = this.chk_isdownloadbooklist.Checked
                };
                item.AdvertisementList = new List <AdvertisementEntity>();

                string[] elocs = this.txt_advertisementtitle.Value.Split(new string[] { "\n" }, StringSplitOptions.RemoveEmptyEntries);
                if (elocs != null)
                {
                    foreach (string loc in elocs)
                    {
                        AdvertisementEntity locEntity = new AdvertisementEntity()
                        {
                            ExhibitionID       = eid,
                            CreateTime         = DateTime.Now,
                            CreateUserID       = this.CurrentAdmin.Sys_UserID,
                            AdvertisementOrder = 1000,
                            AdvertisementTitle = loc,
                            AdvertisementUrl   = "",
                            StateTypeID        = this.chk_statetype.Checked ? 1 : 0
                        };
                        item.AdvertisementList.Add(locEntity);
                    }
                }
                #endregion

                if (this.txt_imageurl.HasFile)
                {
                    string fileName = txt_imageurl.FileName;
                    string tempPath = Server.MapPath("~/UploadFile/ExhibitionLogo/");
                    if (!Directory.Exists(tempPath))
                    {
                        Directory.CreateDirectory(tempPath);
                    }
                    fileName = System.IO.Path.GetFileName(fileName);                  //获取文件名(不带路径)
                    string currFileExtension = System.IO.Path.GetExtension(fileName); //获取文件的扩展名
                    string currFilePath      = tempPath + fileName;                   //获取上传后的文件路径 记录到前面声明的全局变量
                    this.txt_imageurl.SaveAs(currFilePath);
                    item.ExhibitionLogoUrl = "/UploadFile/ExhibitionLogo/" + fileName;
                }
                else
                {
                    item.ExhibitionLogoUrl = hid_imgurl.Value;
                }

                BCtrl_Exhibition bll = new BCtrl_Exhibition();

                if (bll.Save(item))
                {
                    strJs = strJs.Clear();
                    strJs.Append("<script type='text/javascript'>");
                    strJs.Append("bootbox.alert('保存成功', function () {");
                    strJs.Append(@"if (window.parent != undefined) {
                                    window.parent.TObj('tmpExhibitionList')._prmsData.ts = new Date().getTime();
                                    window.parent.TObj('tmpExhibitionList').S();
                                    window.parent.asyncbox.close('exhibition');
                                        }
                                    })");
                    strJs.Append("</script>");
                }
            }
            catch (Exception ex)
            {
                Utils.LogUtil.WriteLog(ex);
                strJs = strJs.Clear();
                strJs.Append("<script type='text/javascript'>");
                strJs.Append("bootbox.alert('保存失败');");
                strJs.Append("</script>");
            }

            ClientScript.RegisterStartupScript(this.GetType(), "LoadExhibitionScript", strJs.ToString());
        }