Ejemplo n.º 1
0
        /// <summary>
        /// 首页置顶
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void SetTop(bool input)
        {
            try
            {
                int sysno = 0;
                if (input)
                {
                    sysno = int.Parse(Request.QueryString["top"]);
                }
                else
                {
                    sysno = int.Parse(Request.QueryString["notop"]);
                }
                SYS_FamousMod m_famous = SYS_FamousBll.GetInstance().GetModel(sysno);
                if (input)
                {
                    m_famous.IsTop = (int)AppEnum.BOOL.True;
                }
                else
                {
                    m_famous.IsTop = (int)AppEnum.BOOL.False;
                }
                SYS_FamousBll.GetInstance().Update(m_famous);

                ltrNotice.Text = "该记录已置顶!";
                this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('noticediv').style.display='';", true);
            }
            catch
            {
                ltrError.Text = "系统错误,置顶失败!";
                this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('errordiv').style.display='';", true);
            }
        }
Ejemplo n.º 2
0
 protected void BindFamous()
 {
     this.m_famous = SYS_FamousBll.GetInstance().GetModel(this.sysno);
     if (this.m_famous.Photo == "")
     {
         this.m_famous.Photo = "";
     }
     else if (!this.m_famous.Photo.Contains("//"))
     {
         this.m_famous.Photo = AppCmn.AppConfig.WebResourcesPath() + "FamousPhoto/" + this.m_famous.Photo;
     }
     this.DataBind();
 }
Ejemplo n.º 3
0
        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void Delete()
        {
            try
            {
                SYS_FamousMod m_famous = SYS_FamousBll.GetInstance().GetModel(int.Parse(Request.QueryString["delete"]));
                m_famous.DR = (int)AppEnum.State.deleted;
                SYS_FamousBll.GetInstance().Update(m_famous);
                if (m_famous.Source != "")
                {
                    SPD_FamousBll.GetInstance().InputReturn(m_famous.SysNo);
                }

                ltrNotice.Text = "该记录已删除!";
                this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('noticediv').style.display='';", true);
            }
            catch
            {
                ltrError.Text = "系统错误,删除失败!";
                this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('errordiv').style.display='';", true);
            }
        }
Ejemplo n.º 4
0
        /// <summary>
        /// 增加一条数据
        /// </summary>

        public int Add(SYS_FamousMod model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into SYS_Famous(");
            strSql.Append("Name,Description,BirthYear,BirthTime,Death,CateSysNo,Level,CustomerSysNo,DR,TS,Source,Gender,HomeTown,Height,FullName,TimeUnknown,IsTop,Photo,CollectCount)");
            strSql.Append(" values (");
            strSql.Append("@Name,@Description,@BirthYear,@BirthTime,@Death,@CateSysNo,@Level,@CustomerSysNo,@DR,@TS,@Source,@Gender,@HomeTown,@Height,@FullName,@TimeUnknown,@IsTop,@Photo,@CollectCount)");
            strSql.Append(";select @@IDENTITY");
            SqlCommand cmd = new SqlCommand(strSql.ToString());

            SqlParameter[] parameters =
            {
                new SqlParameter("@Name",          SqlDbType.NVarChar,         200),
                new SqlParameter("@Description",   SqlDbType.NText,     2147483646),
                new SqlParameter("@BirthYear",     SqlDbType.Int,                4),
                new SqlParameter("@BirthTime",     SqlDbType.DateTime),
                new SqlParameter("@Death",         SqlDbType.DateTime),
                new SqlParameter("@CateSysNo",     SqlDbType.Int,                4),
                new SqlParameter("@Level",         SqlDbType.Int,                4),
                new SqlParameter("@CustomerSysNo", SqlDbType.Int,                4),
                new SqlParameter("@DR",            SqlDbType.TinyInt,            1),
                new SqlParameter("@TS",            SqlDbType.DateTime),
                new SqlParameter("@Source",        SqlDbType.VarChar,           50),
                new SqlParameter("@Gender",        SqlDbType.TinyInt,            1),
                new SqlParameter("@HomeTown",      SqlDbType.Int,                4),
                new SqlParameter("@Height",        SqlDbType.Int,                4),
                new SqlParameter("@FullName",      SqlDbType.VarChar,          100),
                new SqlParameter("@TimeUnknown",   SqlDbType.TinyInt,            1),
                new SqlParameter("@IsTop",         SqlDbType.Int,                4),
                new SqlParameter("@Photo",         SqlDbType.VarChar,          500),
                new SqlParameter("@CollectCount",  SqlDbType.Int,                4),
            };
            if (model.Name != AppConst.StringNull)
            {
                parameters[0].Value = model.Name;
            }
            else
            {
                parameters[0].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[0]);
            if (model.Description != AppConst.StringNull)
            {
                parameters[1].Value = model.Description;
            }
            else
            {
                parameters[1].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[1]);
            if (model.BirthYear != AppConst.IntNull)
            {
                parameters[2].Value = model.BirthYear;
            }
            else
            {
                parameters[2].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[2]);
            if (model.BirthTime != AppConst.DateTimeNull)
            {
                parameters[3].Value = model.BirthTime;
            }
            else
            {
                parameters[3].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[3]);
            if (model.Death != AppConst.DateTimeNull)
            {
                parameters[4].Value = model.Death;
            }
            else
            {
                parameters[4].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[4]);
            if (model.CateSysNo != AppConst.IntNull)
            {
                parameters[5].Value = model.CateSysNo;
            }
            else
            {
                parameters[5].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[5]);
            if (model.Level != AppConst.IntNull)
            {
                parameters[6].Value = model.Level;
            }
            else
            {
                parameters[6].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[6]);
            if (model.CustomerSysNo != AppConst.IntNull)
            {
                parameters[7].Value = model.CustomerSysNo;
            }
            else
            {
                parameters[7].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[7]);
            if (model.DR != AppConst.IntNull)
            {
                parameters[8].Value = model.DR;
            }
            else
            {
                parameters[8].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[8]);
            if (model.TS != AppConst.DateTimeNull)
            {
                parameters[9].Value = model.TS;
            }
            else
            {
                parameters[9].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[9]);
            if (model.Source != AppConst.StringNull)
            {
                parameters[10].Value = model.Source;
            }
            else
            {
                parameters[10].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[10]);
            if (model.Gender != AppConst.IntNull)
            {
                parameters[11].Value = model.Gender;
            }
            else
            {
                parameters[11].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[11]);
            if (model.HomeTown != AppConst.IntNull)
            {
                parameters[12].Value = model.HomeTown;
            }
            else
            {
                parameters[12].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[12]);
            if (model.Height != AppConst.IntNull)
            {
                parameters[13].Value = model.Height;
            }
            else
            {
                parameters[13].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[13]);
            if (model.FullName != AppConst.StringNull)
            {
                parameters[14].Value = model.FullName;
            }
            else
            {
                parameters[14].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[14]);
            if (model.TimeUnknown != AppConst.IntNull)
            {
                parameters[15].Value = model.TimeUnknown;
            }
            else
            {
                parameters[15].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[15]);
            if (model.IsTop != AppConst.IntNull)
            {
                parameters[16].Value = model.IsTop;
            }
            else
            {
                parameters[16].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[16]);
            if (model.Photo != AppConst.StringNull)
            {
                parameters[17].Value = model.Photo;
            }
            else
            {
                parameters[17].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[17]);
            if (model.CollectCount != AppConst.IntNull)
            {
                parameters[18].Value = model.CollectCount;
            }
            else
            {
                parameters[18].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[18]);

            return(Convert.ToInt32(SqlHelper.ExecuteScalar(cmd, parameters)));
        }
Ejemplo n.º 5
0
        /// <summary>
        /// 更新一条数据
        /// </summary>

        public int Update(SYS_FamousMod model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update SYS_Famous set ");
            strSql.Append("Name=@Name,");
            strSql.Append("Description=@Description,");
            strSql.Append("BirthYear=@BirthYear,");
            strSql.Append("BirthTime=@BirthTime,");
            strSql.Append("Death=@Death,");
            strSql.Append("CateSysNo=@CateSysNo,");
            strSql.Append("Level=@Level,");
            strSql.Append("CustomerSysNo=@CustomerSysNo,");
            strSql.Append("DR=@DR,");
            strSql.Append("TS=@TS,");
            strSql.Append("Source=@Source,");
            strSql.Append("Gender=@Gender,");
            strSql.Append("HomeTown=@HomeTown,");
            strSql.Append("Height=@Height,");
            strSql.Append("FullName=@FullName,");
            strSql.Append("TimeUnknown=@TimeUnknown,");
            strSql.Append("IsTop=@IsTop,");
            strSql.Append("Photo=@Photo,");
            strSql.Append("CollectCount=@CollectCount");
            strSql.Append(" where SysNo=@SysNo ");
            SqlCommand cmd = new SqlCommand(strSql.ToString());

            SqlParameter[] parameters =
            {
                new SqlParameter("@SysNo",         SqlDbType.Int,                4),
                new SqlParameter("@Name",          SqlDbType.NVarChar,         200),
                new SqlParameter("@Description",   SqlDbType.NText,     2147483646),
                new SqlParameter("@BirthYear",     SqlDbType.Int,                4),
                new SqlParameter("@BirthTime",     SqlDbType.DateTime),
                new SqlParameter("@Death",         SqlDbType.DateTime),
                new SqlParameter("@CateSysNo",     SqlDbType.Int,                4),
                new SqlParameter("@Level",         SqlDbType.Int,                4),
                new SqlParameter("@CustomerSysNo", SqlDbType.Int,                4),
                new SqlParameter("@DR",            SqlDbType.TinyInt,            1),
                new SqlParameter("@TS",            SqlDbType.DateTime),
                new SqlParameter("@Source",        SqlDbType.VarChar,           50),
                new SqlParameter("@Gender",        SqlDbType.TinyInt,            1),
                new SqlParameter("@HomeTown",      SqlDbType.Int,                4),
                new SqlParameter("@Height",        SqlDbType.Int,                4),
                new SqlParameter("@FullName",      SqlDbType.VarChar,          100),
                new SqlParameter("@TimeUnknown",   SqlDbType.TinyInt,            1),
                new SqlParameter("@IsTop",         SqlDbType.Int,                4),
                new SqlParameter("@Photo",         SqlDbType.VarChar,          500),
                new SqlParameter("@CollectCount",  SqlDbType.Int, 4)
            };
            if (model.SysNo != AppConst.IntNull)
            {
                parameters[0].Value = model.SysNo;
            }
            else
            {
                parameters[0].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[0]);
            if (model.Name != AppConst.StringNull)
            {
                parameters[1].Value = model.Name;
            }
            else
            {
                parameters[1].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[1]);
            if (model.Description != AppConst.StringNull)
            {
                parameters[2].Value = model.Description;
            }
            else
            {
                parameters[2].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[2]);
            if (model.BirthYear != AppConst.IntNull)
            {
                parameters[3].Value = model.BirthYear;
            }
            else
            {
                parameters[3].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[3]);
            if (model.BirthTime != AppConst.DateTimeNull)
            {
                parameters[4].Value = model.BirthTime;
            }
            else
            {
                parameters[4].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[4]);
            if (model.Death != AppConst.DateTimeNull)
            {
                parameters[5].Value = model.Death;
            }
            else
            {
                parameters[5].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[5]);
            if (model.CateSysNo != AppConst.IntNull)
            {
                parameters[6].Value = model.CateSysNo;
            }
            else
            {
                parameters[6].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[6]);
            if (model.Level != AppConst.IntNull)
            {
                parameters[7].Value = model.Level;
            }
            else
            {
                parameters[7].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[7]);
            if (model.CustomerSysNo != AppConst.IntNull)
            {
                parameters[8].Value = model.CustomerSysNo;
            }
            else
            {
                parameters[8].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[8]);
            if (model.DR != AppConst.IntNull)
            {
                parameters[9].Value = model.DR;
            }
            else
            {
                parameters[9].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[9]);
            if (model.TS != AppConst.DateTimeNull)
            {
                parameters[10].Value = model.TS;
            }
            else
            {
                parameters[10].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[10]);
            if (model.Source != AppConst.StringNull)
            {
                parameters[11].Value = model.Source;
            }
            else
            {
                parameters[11].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[11]);
            if (model.Gender != AppConst.IntNull)
            {
                parameters[12].Value = model.Gender;
            }
            else
            {
                parameters[12].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[12]);
            if (model.HomeTown != AppConst.IntNull)
            {
                parameters[13].Value = model.HomeTown;
            }
            else
            {
                parameters[13].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[13]);
            if (model.Height != AppConst.IntNull)
            {
                parameters[14].Value = model.Height;
            }
            else
            {
                parameters[14].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[14]);
            if (model.FullName != AppConst.StringNull)
            {
                parameters[15].Value = model.FullName;
            }
            else
            {
                parameters[15].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[15]);
            if (model.TimeUnknown != AppConst.IntNull)
            {
                parameters[16].Value = model.TimeUnknown;
            }
            else
            {
                parameters[16].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[16]);
            if (model.IsTop != AppConst.IntNull)
            {
                parameters[17].Value = model.IsTop;
            }
            else
            {
                parameters[17].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[17]);
            if (model.Photo != AppConst.StringNull)
            {
                parameters[18].Value = model.Photo;
            }
            else
            {
                parameters[18].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[18]);
            if (model.CollectCount != AppConst.IntNull)
            {
                parameters[19].Value = model.CollectCount;
            }
            else
            {
                parameters[19].Value = System.DBNull.Value;
            }
            cmd.Parameters.Add(parameters[19]);
            return(SqlHelper.ExecuteNonQuery(cmd, parameters));
        }
Ejemplo n.º 6
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(SYS_FamousMod model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into SYS_Famous(");
            strSql.Append("Name,Description,BirthYear,BirthTime,Death,CateSysNo,Level,CustomerSysNo,DR,TS,Source,Gender,HomeTown,Height,FullName,TimeUnknown,IsTop,Photo,CollectCount)");
            strSql.Append(" values (");
            strSql.Append("@Name,@Description,@BirthYear,@BirthTime,@Death,@CateSysNo,@Level,@CustomerSysNo,@DR,@TS,@Source,@Gender,@HomeTown,@Height,@FullName,@TimeUnknown,@IsTop,@Photo,@CollectCount)");
            strSql.Append(";select @@IDENTITY");
            SqlCommand cmd = new SqlCommand(strSql.ToString());
            SqlParameter[] parameters = {
                 new SqlParameter("@Name",SqlDbType.NVarChar,200),
                 new SqlParameter("@Description",SqlDbType.NText,2147483646),
                 new SqlParameter("@BirthYear",SqlDbType.Int,4),
                 new SqlParameter("@BirthTime",SqlDbType.DateTime),
                 new SqlParameter("@Death",SqlDbType.DateTime),
                 new SqlParameter("@CateSysNo",SqlDbType.Int,4),
                 new SqlParameter("@Level",SqlDbType.Int,4),
                 new SqlParameter("@CustomerSysNo",SqlDbType.Int,4),
                 new SqlParameter("@DR",SqlDbType.TinyInt,1),
                 new SqlParameter("@TS",SqlDbType.DateTime),
                 new SqlParameter("@Source",SqlDbType.VarChar,50),
                 new SqlParameter("@Gender",SqlDbType.TinyInt,1),
                 new SqlParameter("@HomeTown",SqlDbType.Int,4),
                 new SqlParameter("@Height",SqlDbType.Int,4),
                 new SqlParameter("@FullName",SqlDbType.VarChar,100),
                 new SqlParameter("@TimeUnknown",SqlDbType.TinyInt,1),
                 new SqlParameter("@IsTop",SqlDbType.Int,4),
                 new SqlParameter("@Photo",SqlDbType.VarChar,500),
                 new SqlParameter("@CollectCount",SqlDbType.Int,4),
             };
            if (model.Name != AppConst.StringNull)
                parameters[0].Value = model.Name;
            else
                parameters[0].Value = System.DBNull.Value;
            cmd.Parameters.Add(parameters[0]);
            if (model.Description != AppConst.StringNull)
                parameters[1].Value = model.Description;
            else
                parameters[1].Value = System.DBNull.Value;
            cmd.Parameters.Add(parameters[1]);
            if (model.BirthYear != AppConst.IntNull)
                parameters[2].Value = model.BirthYear;
            else
                parameters[2].Value = System.DBNull.Value;
            cmd.Parameters.Add(parameters[2]);
            if (model.BirthTime != AppConst.DateTimeNull)
                parameters[3].Value = model.BirthTime;
            else
                parameters[3].Value = System.DBNull.Value;
            cmd.Parameters.Add(parameters[3]);
            if (model.Death != AppConst.DateTimeNull)
                parameters[4].Value = model.Death;
            else
                parameters[4].Value = System.DBNull.Value;
            cmd.Parameters.Add(parameters[4]);
            if (model.CateSysNo != AppConst.IntNull)
                parameters[5].Value = model.CateSysNo;
            else
                parameters[5].Value = System.DBNull.Value;
            cmd.Parameters.Add(parameters[5]);
            if (model.Level != AppConst.IntNull)
                parameters[6].Value = model.Level;
            else
                parameters[6].Value = System.DBNull.Value;
            cmd.Parameters.Add(parameters[6]);
            if (model.CustomerSysNo != AppConst.IntNull)
                parameters[7].Value = model.CustomerSysNo;
            else
                parameters[7].Value = System.DBNull.Value;
            cmd.Parameters.Add(parameters[7]);
            if (model.DR != AppConst.IntNull)
                parameters[8].Value = model.DR;
            else
                parameters[8].Value = System.DBNull.Value;
            cmd.Parameters.Add(parameters[8]);
            if (model.TS != AppConst.DateTimeNull)
                parameters[9].Value = model.TS;
            else
                parameters[9].Value = System.DBNull.Value;
            cmd.Parameters.Add(parameters[9]);
            if (model.Source != AppConst.StringNull)
                parameters[10].Value = model.Source;
            else
                parameters[10].Value = System.DBNull.Value;
            cmd.Parameters.Add(parameters[10]);
            if (model.Gender != AppConst.IntNull)
                parameters[11].Value = model.Gender;
            else
                parameters[11].Value = System.DBNull.Value;
            cmd.Parameters.Add(parameters[11]);
            if (model.HomeTown != AppConst.IntNull)
                parameters[12].Value = model.HomeTown;
            else
                parameters[12].Value = System.DBNull.Value;
            cmd.Parameters.Add(parameters[12]);
            if (model.Height != AppConst.IntNull)
                parameters[13].Value = model.Height;
            else
                parameters[13].Value = System.DBNull.Value;
            cmd.Parameters.Add(parameters[13]);
            if (model.FullName != AppConst.StringNull)
                parameters[14].Value = model.FullName;
            else
                parameters[14].Value = System.DBNull.Value;
            cmd.Parameters.Add(parameters[14]);
            if (model.TimeUnknown != AppConst.IntNull)
                parameters[15].Value = model.TimeUnknown;
            else
                parameters[15].Value = System.DBNull.Value;
            cmd.Parameters.Add(parameters[15]);
            if (model.IsTop != AppConst.IntNull)
                parameters[16].Value = model.IsTop;
            else
                parameters[16].Value = System.DBNull.Value;
            cmd.Parameters.Add(parameters[16]);
            if (model.Photo != AppConst.StringNull)
                parameters[17].Value = model.Photo;
            else
                parameters[17].Value = System.DBNull.Value;
            cmd.Parameters.Add(parameters[17]);
            if (model.CollectCount != AppConst.IntNull)
                parameters[18].Value = model.CollectCount;
            else
                parameters[18].Value = System.DBNull.Value;
            cmd.Parameters.Add(parameters[18]);

            return Convert.ToInt32(SqlHelper.ExecuteScalar(cmd, parameters));
        }
Ejemplo n.º 7
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public int Update(SYS_FamousMod model)
 {
     StringBuilder strSql = new StringBuilder();
     strSql.Append("update SYS_Famous set ");
     strSql.Append("Name=@Name,");
     strSql.Append("Description=@Description,");
     strSql.Append("BirthYear=@BirthYear,");
     strSql.Append("BirthTime=@BirthTime,");
     strSql.Append("Death=@Death,");
     strSql.Append("CateSysNo=@CateSysNo,");
     strSql.Append("Level=@Level,");
     strSql.Append("CustomerSysNo=@CustomerSysNo,");
     strSql.Append("DR=@DR,");
     strSql.Append("TS=@TS,");
     strSql.Append("Source=@Source,");
     strSql.Append("Gender=@Gender,");
     strSql.Append("HomeTown=@HomeTown,");
     strSql.Append("Height=@Height,");
     strSql.Append("FullName=@FullName,");
     strSql.Append("TimeUnknown=@TimeUnknown,");
     strSql.Append("IsTop=@IsTop,");
     strSql.Append("Photo=@Photo,");
     strSql.Append("CollectCount=@CollectCount");
     strSql.Append(" where SysNo=@SysNo ");
     SqlCommand cmd = new SqlCommand(strSql.ToString());
     SqlParameter[] parameters = {
          new SqlParameter("@SysNo",SqlDbType.Int,4),
          new SqlParameter("@Name",SqlDbType.NVarChar,200),
          new SqlParameter("@Description",SqlDbType.NText,2147483646),
          new SqlParameter("@BirthYear",SqlDbType.Int,4),
          new SqlParameter("@BirthTime",SqlDbType.DateTime),
          new SqlParameter("@Death",SqlDbType.DateTime),
          new SqlParameter("@CateSysNo",SqlDbType.Int,4),
          new SqlParameter("@Level",SqlDbType.Int,4),
          new SqlParameter("@CustomerSysNo",SqlDbType.Int,4),
          new SqlParameter("@DR",SqlDbType.TinyInt,1),
          new SqlParameter("@TS",SqlDbType.DateTime),
          new SqlParameter("@Source",SqlDbType.VarChar,50),
          new SqlParameter("@Gender",SqlDbType.TinyInt,1),
          new SqlParameter("@HomeTown",SqlDbType.Int,4),
          new SqlParameter("@Height",SqlDbType.Int,4),
          new SqlParameter("@FullName",SqlDbType.VarChar,100),
          new SqlParameter("@TimeUnknown",SqlDbType.TinyInt,1),
          new SqlParameter("@IsTop",SqlDbType.Int,4),
          new SqlParameter("@Photo",SqlDbType.VarChar,500),
          new SqlParameter("@CollectCount",SqlDbType.Int,4)
      };
     if (model.SysNo != AppConst.IntNull)
         parameters[0].Value = model.SysNo;
     else
         parameters[0].Value = System.DBNull.Value;
     cmd.Parameters.Add(parameters[0]);
     if (model.Name != AppConst.StringNull)
         parameters[1].Value = model.Name;
     else
         parameters[1].Value = System.DBNull.Value;
     cmd.Parameters.Add(parameters[1]);
     if (model.Description != AppConst.StringNull)
         parameters[2].Value = model.Description;
     else
         parameters[2].Value = System.DBNull.Value;
     cmd.Parameters.Add(parameters[2]);
     if (model.BirthYear != AppConst.IntNull)
         parameters[3].Value = model.BirthYear;
     else
         parameters[3].Value = System.DBNull.Value;
     cmd.Parameters.Add(parameters[3]);
     if (model.BirthTime != AppConst.DateTimeNull)
         parameters[4].Value = model.BirthTime;
     else
         parameters[4].Value = System.DBNull.Value;
     cmd.Parameters.Add(parameters[4]);
     if (model.Death != AppConst.DateTimeNull)
         parameters[5].Value = model.Death;
     else
         parameters[5].Value = System.DBNull.Value;
     cmd.Parameters.Add(parameters[5]);
     if (model.CateSysNo != AppConst.IntNull)
         parameters[6].Value = model.CateSysNo;
     else
         parameters[6].Value = System.DBNull.Value;
     cmd.Parameters.Add(parameters[6]);
     if (model.Level != AppConst.IntNull)
         parameters[7].Value = model.Level;
     else
         parameters[7].Value = System.DBNull.Value;
     cmd.Parameters.Add(parameters[7]);
     if (model.CustomerSysNo != AppConst.IntNull)
         parameters[8].Value = model.CustomerSysNo;
     else
         parameters[8].Value = System.DBNull.Value;
     cmd.Parameters.Add(parameters[8]);
     if (model.DR != AppConst.IntNull)
         parameters[9].Value = model.DR;
     else
         parameters[9].Value = System.DBNull.Value;
     cmd.Parameters.Add(parameters[9]);
     if (model.TS != AppConst.DateTimeNull)
         parameters[10].Value = model.TS;
     else
         parameters[10].Value = System.DBNull.Value;
     cmd.Parameters.Add(parameters[10]);
     if (model.Source != AppConst.StringNull)
         parameters[11].Value = model.Source;
     else
         parameters[11].Value = System.DBNull.Value;
     cmd.Parameters.Add(parameters[11]);
     if (model.Gender != AppConst.IntNull)
         parameters[12].Value = model.Gender;
     else
         parameters[12].Value = System.DBNull.Value;
     cmd.Parameters.Add(parameters[12]);
     if (model.HomeTown != AppConst.IntNull)
         parameters[13].Value = model.HomeTown;
     else
         parameters[13].Value = System.DBNull.Value;
     cmd.Parameters.Add(parameters[13]);
     if (model.Height != AppConst.IntNull)
         parameters[14].Value = model.Height;
     else
         parameters[14].Value = System.DBNull.Value;
     cmd.Parameters.Add(parameters[14]);
     if (model.FullName != AppConst.StringNull)
         parameters[15].Value = model.FullName;
     else
         parameters[15].Value = System.DBNull.Value;
     cmd.Parameters.Add(parameters[15]);
     if (model.TimeUnknown != AppConst.IntNull)
         parameters[16].Value = model.TimeUnknown;
     else
         parameters[16].Value = System.DBNull.Value;
     cmd.Parameters.Add(parameters[16]);
     if (model.IsTop != AppConst.IntNull)
         parameters[17].Value = model.IsTop;
     else
         parameters[17].Value = System.DBNull.Value;
     cmd.Parameters.Add(parameters[17]);
     if (model.Photo != AppConst.StringNull)
         parameters[18].Value = model.Photo;
     else
         parameters[18].Value = System.DBNull.Value;
     cmd.Parameters.Add(parameters[18]);
     if (model.CollectCount != AppConst.IntNull)
         parameters[19].Value = model.CollectCount;
     else
         parameters[19].Value = System.DBNull.Value;
     cmd.Parameters.Add(parameters[19]);
     return SqlHelper.ExecuteNonQuery(cmd, parameters);
 }
Ejemplo n.º 8
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public SYS_FamousMod GetModel(int SysNo)
 {
     StringBuilder strSql = new StringBuilder();
     strSql.Append("select SysNo, Name, Description, BirthYear, BirthTime, Death, CateSysNo, Level, CustomerSysNo, DR, TS, Source, Gender, HomeTown, Height, FullName, TimeUnknown, IsTop, Photo, CollectCount from  SYS_Famous");
     strSql.Append(" where SysNo=@SysNo ");
     SqlParameter[] parameters = {
     new SqlParameter("@SysNo", SqlDbType.Int,4 )
      		};
     parameters[0].Value = SysNo;
     SYS_FamousMod model = new SYS_FamousMod();
     DataSet ds = SqlHelper.ExecuteDataSet(strSql.ToString(), parameters);
     if (ds.Tables[0].Rows.Count > 0)
     {
         if (ds.Tables[0].Rows[0]["SysNo"].ToString() != "")
         {
             model.SysNo = int.Parse(ds.Tables[0].Rows[0]["SysNo"].ToString());
         }
         model.Name = ds.Tables[0].Rows[0]["Name"].ToString();
         model.Description = ds.Tables[0].Rows[0]["Description"].ToString();
         if (ds.Tables[0].Rows[0]["BirthYear"].ToString() != "")
         {
             model.BirthYear = int.Parse(ds.Tables[0].Rows[0]["BirthYear"].ToString());
         }
         if (ds.Tables[0].Rows[0]["BirthTime"].ToString() != "")
         {
             model.BirthTime = DateTime.Parse(ds.Tables[0].Rows[0]["BirthTime"].ToString());
         }
         if (ds.Tables[0].Rows[0]["Death"].ToString() != "")
         {
             model.Death = DateTime.Parse(ds.Tables[0].Rows[0]["Death"].ToString());
         }
         if (ds.Tables[0].Rows[0]["CateSysNo"].ToString() != "")
         {
             model.CateSysNo = int.Parse(ds.Tables[0].Rows[0]["CateSysNo"].ToString());
         }
         if (ds.Tables[0].Rows[0]["Level"].ToString() != "")
         {
             model.Level = int.Parse(ds.Tables[0].Rows[0]["Level"].ToString());
         }
         if (ds.Tables[0].Rows[0]["CustomerSysNo"].ToString() != "")
         {
             model.CustomerSysNo = int.Parse(ds.Tables[0].Rows[0]["CustomerSysNo"].ToString());
         }
         if (ds.Tables[0].Rows[0]["DR"].ToString() != "")
         {
             model.DR = int.Parse(ds.Tables[0].Rows[0]["DR"].ToString());
         }
         if (ds.Tables[0].Rows[0]["TS"].ToString() != "")
         {
             model.TS = DateTime.Parse(ds.Tables[0].Rows[0]["TS"].ToString());
         }
         model.Source = ds.Tables[0].Rows[0]["Source"].ToString();
         if (ds.Tables[0].Rows[0]["Gender"].ToString() != "")
         {
             model.Gender = int.Parse(ds.Tables[0].Rows[0]["Gender"].ToString());
         }
         if (ds.Tables[0].Rows[0]["HomeTown"].ToString() != "")
         {
             model.HomeTown = int.Parse(ds.Tables[0].Rows[0]["HomeTown"].ToString());
         }
         if (ds.Tables[0].Rows[0]["Height"].ToString() != "")
         {
             model.Height = int.Parse(ds.Tables[0].Rows[0]["Height"].ToString());
         }
         model.FullName = ds.Tables[0].Rows[0]["FullName"].ToString();
         if (ds.Tables[0].Rows[0]["TimeUnknown"].ToString() != "")
         {
             model.TimeUnknown = int.Parse(ds.Tables[0].Rows[0]["TimeUnknown"].ToString());
         }
         if (ds.Tables[0].Rows[0]["IsTop"].ToString() != "")
         {
             model.IsTop = int.Parse(ds.Tables[0].Rows[0]["IsTop"].ToString());
         }
         model.Photo = ds.Tables[0].Rows[0]["Photo"].ToString();
         if (ds.Tables[0].Rows[0]["CollectCount"].ToString() != "")
         {
             model.CollectCount = int.Parse(ds.Tables[0].Rows[0]["CollectCount"].ToString());
         }
         return model;
     }
     else
     {
         return null;
     }
 }
Ejemplo n.º 9
0
        /// <summary>
        /// 更新一条数据
        /// </summary>

        public void Update(SYS_FamousMod model)
        {
            dal.Update(model);
        }
Ejemplo n.º 10
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public void Update(SYS_FamousMod model)
 {
     dal.Update(model);
 }
Ejemplo n.º 11
0
        /// <summary>
        /// 批量导入
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void Unnamed2_Click(object sender, EventArgs e)
        {
            using (SQLData m_data = new SQLData())
            {
                for (int i = 16831; i < 40965; i++)
                {
                    DataRow m_dr = m_data.CmdtoDataRow("select * from [SPD_Famous] where sysno =" + i);
                    if (m_dr["Name"].ToString() == "" || m_dr["Biography"].ToString() == "" || m_dr["Biography"].ToString() == "SameNameError")
                    {
                        continue;
                    }
                    SYS_FamousMod m_famous = new SYS_FamousMod();
                    if (m_dr["FamousSysNo"].ToString() != "")
                    {
                        m_famous = SYS_FamousBll.GetInstance().GetModel(int.Parse(m_dr["FamousSysNo"].ToString()));
                        m_famous.Photo = m_dr["photo"].ToString();
                        SYS_FamousBll.GetInstance().Update(m_famous);
                        //Console.WriteLine(m_dr["sysno"] + " update ");
                        continue;
                    }

                    DataTable m_area = SYS_DistrictBll.GetInstance().GetTreeDetail(m_dr["HomeTown"].ToString().Split(new char[] { '(', ',' })[0].Trim());
                    if (!CommonTools.IsDataTableNoRow(m_area))
                    {
                        m_famous.HomeTown = int.Parse(m_area.Rows[0]["SysNo3"].ToString());
                    }

                    string[] tmp = m_dr["BirthTmp"].ToString().Split(new char[] { '-', ' ', ':' });
                    int month = 0;
                    int day = 0;
                    int hour = 0;
                    int minute = 0;

                    if (tmp.Length > 6)
                    {
                        if (m_dr["BirthTmp"].ToString().StartsWith("-"))
                        {
                            m_famous.BirthYear = int.Parse("-" + tmp[1]);
                            month = int.Parse(tmp[2].Replace("January", "1").Replace("February", "2").Replace("March", "3")
                                .Replace("April", "4").Replace("May", "5").Replace("June", "6").Replace("July", "7")
                                .Replace("August", "8").Replace("September", "9").Replace("October", "10")
                                .Replace("November", "11").Replace("December", "12"));
                            day = int.Parse(tmp[3]);
                            if (tmp[4] == "12" && tmp[5] == "00" && tmp[6] == "PM")
                            {
                                hour = int.Parse(tmp[4]);
                                m_famous.TimeUnknown = 1;
                            }
                            else
                            {
                                if (tmp[6] == "PM" && tmp[4] != "12")
                                {
                                    hour = (int.Parse(tmp[4]) + 12);
                                }
                                else
                                {
                                    hour = int.Parse(tmp[4]);
                                }
                                m_famous.TimeUnknown = 0;
                            }
                            minute = int.Parse(tmp[5]);
                        }
                    }
                    else
                    {
                        m_famous.BirthYear = int.Parse(tmp[0]);
                        month = int.Parse(tmp[1].Replace("January", "1").Replace("February", "2").Replace("March", "3")
                            .Replace("April", "4").Replace("May", "5").Replace("June", "6").Replace("July", "7")
                            .Replace("August", "8").Replace("September", "9").Replace("October", "10")
                            .Replace("November", "11").Replace("December", "12"));
                        day = int.Parse(tmp[2]);
                        if (tmp[3] == "12" && tmp[4] == "00" && tmp[5] == "PM")
                        {
                            hour = int.Parse(tmp[3]);
                            m_famous.TimeUnknown = 1;
                        }
                        else
                        {
                            if (tmp[5] == "PM" && tmp[3] != "12")
                            {
                                hour = int.Parse(tmp[3]) + 12;
                            }
                            else
                            {
                                hour = int.Parse(tmp[3]);
                            }
                            m_famous.TimeUnknown = 0;
                        }
                        minute = int.Parse(tmp[4]);
                    }

                    m_famous.BirthTime = new DateTime(8000, month, day, hour, minute, 0);
                    m_famous.CateSysNo = 1;
                    m_famous.CustomerSysNo = 1;
                    m_famous.Description = m_dr["Biography"].ToString();
                    m_famous.DR = 0;
                    m_famous.FullName = m_dr["FamousName"].ToString();
                    m_famous.Gender = int.Parse(m_dr["Gender"].ToString());
                    if (m_dr["Height"].ToString() != "")
                    {
                        m_famous.Height = int.Parse(m_dr["Height"].ToString().Replace("m", ""));
                    }
                    m_famous.IsTop = 0;
                    m_famous.Name = m_dr["Name"].ToString();
                    m_famous.Source = "AstroTheme";
                    m_famous.TS = DateTime.Now;
                    m_famous.Photo = m_dr["photo"].ToString();
                    m_famous.SysNo = SYS_FamousBll.GetInstance().Add(m_famous);
                    SPD_FamousMod m_spider = SPD_FamousBll.GetInstance().GetModel(i);
                    m_spider.FamousSysNo = m_famous.SysNo;
                    SPD_FamousBll.GetInstance().Update(m_spider);
                    //Console.WriteLine(m_dr["sysno"] + " add ");
                }
            }
        }
Ejemplo n.º 12
0
        protected void PrepareForm()
        {
            #region  项绑定
            drpCate.DataSource     = SYS_Famous_CategoryBll.GetInstance().GetList();
            drpCate.DataTextField  = "Name";
            drpCate.DataValueField = "SysNo";
            drpCate.DataBind();

            drpDistrict1.DataSource     = SYS_DistrictBll.GetInstance().GetFirstLevel(0);
            drpDistrict1.DataTextField  = "Name";
            drpDistrict1.DataValueField = "SysNo";
            drpDistrict1.DataBind();
            drpDistrict1.Items.Insert(0, new ListItem("请选择", "0"));

            chkTime.DataSource     = AppEnum.GetTimeUnknown();
            chkTime.DataTextField  = "Value";
            chkTime.DataValueField = "Key";
            chkTime.DataBind();
            #endregion

            if (type == "ADD")
            {
            }
            else if (type == "EDIT")
            {
                if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
                {
                    try
                    {
                        SysNo = int.Parse(Request.QueryString["id"]);
                        SYS_FamousMod m_famous = SYS_FamousBll.GetInstance().GetModel(SysNo);
                        txtSysNo.Text    = m_famous.SysNo.ToString();
                        txtName.Text     = m_famous.Name;
                        txtFullName.Text = m_famous.FullName;
                        txtDesc.Text     = m_famous.Description;
                        txtYear.Text     = m_famous.BirthYear.ToString();
                        txtMonth.Text    = m_famous.BirthTime.Month.ToString();
                        txtDay.Text      = m_famous.BirthTime.Day.ToString();
                        txtHour.Text     = m_famous.BirthTime.Hour.ToString();
                        txtMinute.Text   = m_famous.BirthTime.Minute.ToString();
                        if (m_famous.Height != AppConst.IntNull)
                        {
                            txtHeight.Text = m_famous.Height.ToString();
                        }

                        chkTime.SelectedIndex   = chkTime.Items.IndexOf(chkTime.Items.FindByValue(m_famous.TimeUnknown.ToString()));
                        drpCate.SelectedIndex   = drpCate.Items.IndexOf(drpCate.Items.FindByValue(m_famous.CateSysNo.ToString()));
                        drpGender.SelectedIndex = drpGender.Items.IndexOf(drpGender.Items.FindByValue(m_famous.Gender.ToString()));

                        DataTable m_area = SYS_DistrictBll.GetInstance().GetTreeDetail(m_famous.HomeTown);
                        if (!CommonTools.IsDataTableNoRow(m_area))
                        {
                            drpDistrict1.SelectedIndex = drpDistrict1.Items.IndexOf(drpDistrict1.Items.FindByValue(m_area.Rows[0]["SysNo1"].ToString()));
                            drpDistrict1_SelectedIndexChanged(new object(), new EventArgs());
                            drpDistrict2.SelectedIndex = drpDistrict2.Items.IndexOf(drpDistrict2.Items.FindByValue(m_area.Rows[0]["SysNo2"].ToString()));
                            drpDistrict2_SelectedIndexChanged(new object(), new EventArgs());
                            drpDistrict3.SelectedIndex = drpDistrict3.Items.IndexOf(drpDistrict3.Items.FindByValue(m_area.Rows[0]["SysNo3"].ToString()));
                            drpDistrict3_SelectedIndexChanged(new object(), new EventArgs());
                        }

                        DataTable m_keydt = REL_Famous_KeyWordBll.GetInstance().GetFamousList(SysNo);
                        if (!AppCmn.CommonTools.IsDataTableNoRow(m_keydt))
                        {
                            for (int i = 0; i < m_keydt.Rows.Count; i++)
                            {
                                txtKey.Text += m_keydt.Rows[i]["KeyWords"].ToString() + " ";
                            }
                            txtKey.Text = txtKey.Text.Trim();
                        }
                    }
                    catch
                    {
                        Response.Redirect("../Error.aspx?msg=");
                        return;
                    }
                }
            }
            else if (type == "INPUT")
            {
                if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
                {
                    try
                    {
                        int           spider   = int.Parse(Request.QueryString["id"]);
                        SPD_FamousMod m_spider = SPD_FamousBll.GetInstance().GetModel(spider);
                        txtSysNo.Text    = "自动生成";
                        txtFullName.Text = m_spider.FamousName;
                        string[] tmp = m_spider.BirthTmp.Split(new char[] { '-', ' ', ':' });

                        if (tmp.Length > 6)
                        {
                            if (m_spider.BirthTmp.StartsWith("-"))
                            {
                                txtYear.Text  = "-" + tmp[1];
                                txtMonth.Text = tmp[2].Replace("January", "1").Replace("February", "2").Replace("March", "3")
                                                .Replace("April", "4").Replace("May", "5").Replace("June", "6").Replace("July", "7")
                                                .Replace("August", "8").Replace("September", "9").Replace("October", "10")
                                                .Replace("November", "11").Replace("December", "12");
                                txtDay.Text = tmp[3];
                                if (tmp[4] == "12" && tmp[5] == "00" && tmp[6] == "PM")
                                {
                                    txtHour.Text          = tmp[4];
                                    chkTime.SelectedIndex = 0;
                                }
                                else
                                {
                                    if (tmp[6] == "PM")
                                    {
                                        txtHour.Text = (int.Parse(tmp[4]) + 12).ToString();
                                    }
                                    else
                                    {
                                        txtHour.Text = tmp[4];
                                    }
                                    chkTime.SelectedIndex = 1;
                                }
                                txtMinute.Text = tmp[5];
                            }
                        }
                        else
                        {
                            txtYear.Text  = tmp[0];
                            txtMonth.Text = tmp[1].Replace("January", "1").Replace("February", "2").Replace("March", "3")
                                            .Replace("April", "4").Replace("May", "5").Replace("June", "6").Replace("July", "7")
                                            .Replace("August", "8").Replace("September", "9").Replace("October", "10")
                                            .Replace("November", "11").Replace("December", "12");
                            txtDay.Text = tmp[2];
                            if (tmp[3] == "12" && tmp[4] == "00" && tmp[5] == "PM")
                            {
                                txtHour.Text          = tmp[3];
                                chkTime.SelectedIndex = 0;
                            }
                            else
                            {
                                if (tmp[5] == "PM")
                                {
                                    txtHour.Text = (int.Parse(tmp[3]) + 12).ToString();
                                }
                                else
                                {
                                    txtHour.Text = tmp[3];
                                }
                                chkTime.SelectedIndex = 1;
                            }
                            txtMinute.Text = tmp[4];
                        }

                        txtHeight.Text          = m_spider.Height.Replace("m", "");
                        drpGender.SelectedIndex = drpGender.Items.IndexOf(drpGender.Items.FindByValue(m_spider.Gender.ToString()));

                        DataTable m_area = SYS_DistrictBll.GetInstance().GetTreeDetail(m_spider.HomeTown.Split(new char[] { '(', ',' })[0].Trim());
                        if (!CommonTools.IsDataTableNoRow(m_area))
                        {
                            drpDistrict1.SelectedIndex = drpDistrict1.Items.IndexOf(drpDistrict1.Items.FindByValue(m_area.Rows[0]["SysNo1"].ToString()));
                            drpDistrict1_SelectedIndexChanged(new object(), new EventArgs());
                            drpDistrict2.SelectedIndex = drpDistrict2.Items.IndexOf(drpDistrict2.Items.FindByValue(m_area.Rows[0]["SysNo2"].ToString()));
                            drpDistrict2_SelectedIndexChanged(new object(), new EventArgs());
                            drpDistrict3.SelectedIndex = drpDistrict3.Items.IndexOf(drpDistrict3.Items.FindByValue(m_area.Rows[0]["SysNo3"].ToString()));
                            drpDistrict3_SelectedIndexChanged(new object(), new EventArgs());
                        }
                    }
                    catch { }
                }
            }
        }
Ejemplo n.º 13
0
        protected void Unnamed3_Click(object sender, EventArgs e)
        {
            string[]      keys     = this.txtKey.Text.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
            DataTable     m_keys   = new DataTable();
            SYS_FamousMod m_famous = new SYS_FamousMod();

            if (type == "EDIT")
            {
                if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
                {
                    SysNo = int.Parse(Request.QueryString["id"]);
                }
                m_famous = SYS_FamousBll.GetInstance().GetModel(SysNo);
                m_keys   = REL_Famous_KeyWordBll.GetInstance().GetFamousList(SysNo);
            }
            try
            {
                m_famous.BirthYear = int.Parse(txtYear.Text);
                m_famous.BirthTime = new DateTime(AppConst.DateTimeNull.Year, int.Parse(txtMonth.Text), int.Parse(txtDay.Text),
                                                  int.Parse(txtHour.Text), int.Parse(txtMinute.Text), 0);
                m_famous.CateSysNo     = int.Parse(drpCate.SelectedValue);
                m_famous.CustomerSysNo = GetSession().AdminEntity.CustomerSysNo;
                m_famous.Description   = txtDesc.Text;
                m_famous.FullName      = txtFullName.Text;
                m_famous.Gender        = int.Parse(drpGender.SelectedValue);
                if (txtHeight.Text != AppConst.StringNull)
                {
                    m_famous.Height = int.Parse(txtHeight.Text);
                }
                if (drpDistrict3.SelectedValue == "0")
                {
                    ltrError.Text = "请选择第三级地区!";
                    this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('errordiv').style.display='';closeforseconds();", true);
                }
                m_famous.HomeTown = int.Parse(drpDistrict3.SelectedValue);
                m_famous.Name     = txtName.Text;
                if (type == "INPUT")
                {
                    m_famous.Source = "AstroTheme";
                }
                else
                {
                    m_famous.Source = "手动添加";
                }
                m_famous.TimeUnknown = int.Parse(chkTime.SelectedValue);
            }
            catch
            {
                ltrError.Text = "输入资料格式有误,请检查!";
                this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('errordiv').style.display='';closeforseconds();", true);
                return;
            }
            try
            {
                if (type == "ADD")
                {
                    m_famous.SysNo = SYS_FamousBll.GetInstance().Add(m_famous);
                    for (int i = 0; i < keys.Length; i++)
                    {
                        SYS_Famous_KeyWordsMod tmp_key = new SYS_Famous_KeyWordsMod();
                        tmp_key.SysNo = SYS_Famous_KeyWordsBll.GetInstance().GetSysNoByName(keys[i]);
                        if (tmp_key.SysNo == AppConst.IntNull)
                        {
                            tmp_key.KeyWords = keys[i];
                            tmp_key.SysNo    = SYS_Famous_KeyWordsBll.GetInstance().Add(tmp_key);
                        }
                        REL_Famous_KeyWordMod tmp_rel = new REL_Famous_KeyWordMod();
                        tmp_rel.Famous_SysNo  = m_famous.SysNo;
                        tmp_rel.KeyWord_SysNo = tmp_key.SysNo;
                        REL_Famous_KeyWordBll.GetInstance().Add(tmp_rel);
                    }
                    LogManagement.getInstance().WriteTrace(m_famous.SysNo, "Celebrity.Add", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username);
                }
                else if (type == "EDIT")
                {
                    SYS_FamousBll.GetInstance().Update(m_famous);
                    REL_Famous_KeyWordBll.GetInstance().RemoveAllKeyByFamous(m_famous.SysNo);
                    for (int i = 0; i < keys.Length; i++)
                    {
                        SYS_Famous_KeyWordsMod tmp_key = new SYS_Famous_KeyWordsMod();
                        tmp_key.SysNo = SYS_Famous_KeyWordsBll.GetInstance().GetSysNoByName(keys[i]);
                        if (tmp_key.SysNo == AppConst.IntNull)
                        {
                            tmp_key.KeyWords = keys[i];
                            tmp_key.SysNo    = SYS_Famous_KeyWordsBll.GetInstance().Add(tmp_key);
                        }
                        REL_Famous_KeyWordMod tmp_rel = new REL_Famous_KeyWordMod();
                        tmp_rel.Famous_SysNo  = m_famous.SysNo;
                        tmp_rel.KeyWord_SysNo = tmp_key.SysNo;
                        REL_Famous_KeyWordBll.GetInstance().Add(tmp_rel);
                    }
                    LogManagement.getInstance().WriteTrace(m_famous.SysNo, "Celebrity.Edit", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username);
                }
                else if (type == "INPUT")
                {
                    m_famous.SysNo = SYS_FamousBll.GetInstance().Add(m_famous);
                    int           spider   = int.Parse(Request.QueryString["id"]);
                    SPD_FamousMod m_spider = SPD_FamousBll.GetInstance().GetModel(spider);
                    m_spider.FamousSysNo = m_famous.SysNo;
                    SPD_FamousBll.GetInstance().Update(m_spider);
                    for (int i = 0; i < keys.Length; i++)
                    {
                        SYS_Famous_KeyWordsMod tmp_key = new SYS_Famous_KeyWordsMod();
                        tmp_key.SysNo = SYS_Famous_KeyWordsBll.GetInstance().GetSysNoByName(keys[i]);
                        if (tmp_key.SysNo == AppConst.IntNull)
                        {
                            tmp_key.KeyWords = keys[i];
                            tmp_key.SysNo    = SYS_Famous_KeyWordsBll.GetInstance().Add(tmp_key);
                        }
                        REL_Famous_KeyWordMod tmp_rel = new REL_Famous_KeyWordMod();
                        tmp_rel.Famous_SysNo  = m_famous.SysNo;
                        tmp_rel.KeyWord_SysNo = tmp_key.SysNo;
                        REL_Famous_KeyWordBll.GetInstance().Add(tmp_rel);
                    }
                    LogManagement.getInstance().WriteTrace(m_famous.SysNo, "Celebrity.Input", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username);
                }
                ltrNotice.Text = "该记录已保存成功!";
                this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('noticediv').style.display='';", true);
            }
            catch (Exception ex)
            {
                ltrError.Text = "系统错误,保存失败!";
                this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('errordiv').style.display='';closeforseconds();", true);
                LogManagement.getInstance().WriteException(ex, "Celebrity.Save", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username);
            }
        }
Ejemplo n.º 14
0
        protected void Unnamed3_Click(object sender, EventArgs e)
        {
            string[] keys = this.txtKey.Text.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
            DataTable m_keys = new DataTable();
            SYS_FamousMod m_famous = new SYS_FamousMod();
            if (type == "EDIT")
            {
                if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
                {
                    SysNo = int.Parse(Request.QueryString["id"]);
                }
                m_famous = SYS_FamousBll.GetInstance().GetModel(SysNo);
                m_keys = REL_Famous_KeyWordBll.GetInstance().GetFamousList(SysNo);
            }
            try
            {
                m_famous.BirthYear = int.Parse(txtYear.Text);
                m_famous.BirthTime = new DateTime(AppConst.DateTimeNull.Year, int.Parse(txtMonth.Text), int.Parse(txtDay.Text),
                    int.Parse(txtHour.Text), int.Parse(txtMinute.Text), 0);
                m_famous.CateSysNo = int.Parse(drpCate.SelectedValue);
                m_famous.CustomerSysNo = GetSession().AdminEntity.CustomerSysNo;
                m_famous.Description = txtDesc.Text;
                m_famous.FullName = txtFullName.Text;
                m_famous.Gender = int.Parse(drpGender.SelectedValue);
                if (txtHeight.Text != AppConst.StringNull)
                {
                    m_famous.Height = int.Parse(txtHeight.Text);
                }
                if (drpDistrict3.SelectedValue == "0")
                {
                    ltrError.Text = "请选择第三级地区!";
                    this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('errordiv').style.display='';closeforseconds();", true);
                }
                m_famous.HomeTown = int.Parse(drpDistrict3.SelectedValue);
                m_famous.Name = txtName.Text;
                if (type == "INPUT")
                {
                    m_famous.Source = "AstroTheme";
                }
                else
                {
                    m_famous.Source = "手动添加";
                }
                m_famous.TimeUnknown = int.Parse(chkTime.SelectedValue);

            }
            catch
            {
                ltrError.Text = "输入资料格式有误,请检查!";
                this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('errordiv').style.display='';closeforseconds();", true);
                return;
            }
            try
            {
                if (type == "ADD")
                {
                    m_famous.SysNo = SYS_FamousBll.GetInstance().Add(m_famous);
                    for (int i = 0; i < keys.Length; i++)
                    {
                        SYS_Famous_KeyWordsMod tmp_key = new SYS_Famous_KeyWordsMod();
                        tmp_key.SysNo = SYS_Famous_KeyWordsBll.GetInstance().GetSysNoByName(keys[i]);
                        if (tmp_key.SysNo == AppConst.IntNull)
                        {
                            tmp_key.KeyWords = keys[i];
                            tmp_key.SysNo = SYS_Famous_KeyWordsBll.GetInstance().Add(tmp_key);
                        }
                        REL_Famous_KeyWordMod tmp_rel = new REL_Famous_KeyWordMod();
                        tmp_rel.Famous_SysNo = m_famous.SysNo;
                        tmp_rel.KeyWord_SysNo = tmp_key.SysNo;
                        REL_Famous_KeyWordBll.GetInstance().Add(tmp_rel);
                    }
                    LogManagement.getInstance().WriteTrace(m_famous.SysNo, "Celebrity.Add", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username);
                }
                else if (type == "EDIT")
                {
                    SYS_FamousBll.GetInstance().Update(m_famous);
                    REL_Famous_KeyWordBll.GetInstance().RemoveAllKeyByFamous(m_famous.SysNo);
                    for (int i = 0; i < keys.Length; i++)
                    {
                        SYS_Famous_KeyWordsMod tmp_key = new SYS_Famous_KeyWordsMod();
                        tmp_key.SysNo = SYS_Famous_KeyWordsBll.GetInstance().GetSysNoByName(keys[i]);
                        if (tmp_key.SysNo == AppConst.IntNull)
                        {
                            tmp_key.KeyWords = keys[i];
                            tmp_key.SysNo = SYS_Famous_KeyWordsBll.GetInstance().Add(tmp_key);
                        }
                        REL_Famous_KeyWordMod tmp_rel = new REL_Famous_KeyWordMod();
                        tmp_rel.Famous_SysNo = m_famous.SysNo;
                        tmp_rel.KeyWord_SysNo = tmp_key.SysNo;
                        REL_Famous_KeyWordBll.GetInstance().Add(tmp_rel);
                    }
                    LogManagement.getInstance().WriteTrace(m_famous.SysNo, "Celebrity.Edit", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username);
                }
                else if (type == "INPUT")
                {
                    m_famous.SysNo = SYS_FamousBll.GetInstance().Add(m_famous);
                    int spider = int.Parse(Request.QueryString["id"]);
                    SPD_FamousMod m_spider = SPD_FamousBll.GetInstance().GetModel(spider);
                    m_spider.FamousSysNo = m_famous.SysNo;
                    SPD_FamousBll.GetInstance().Update(m_spider);
                    for (int i = 0; i < keys.Length; i++)
                    {
                        SYS_Famous_KeyWordsMod tmp_key = new SYS_Famous_KeyWordsMod();
                        tmp_key.SysNo = SYS_Famous_KeyWordsBll.GetInstance().GetSysNoByName(keys[i]);
                        if (tmp_key.SysNo == AppConst.IntNull)
                        {
                            tmp_key.KeyWords = keys[i];
                            tmp_key.SysNo = SYS_Famous_KeyWordsBll.GetInstance().Add(tmp_key);
                        }
                        REL_Famous_KeyWordMod tmp_rel = new REL_Famous_KeyWordMod();
                        tmp_rel.Famous_SysNo = m_famous.SysNo;
                        tmp_rel.KeyWord_SysNo = tmp_key.SysNo;
                        REL_Famous_KeyWordBll.GetInstance().Add(tmp_rel);
                    }
                    LogManagement.getInstance().WriteTrace(m_famous.SysNo, "Celebrity.Input", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username);
                }
                ltrNotice.Text = "该记录已保存成功!";
                this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('noticediv').style.display='';", true);
            }
            catch (Exception ex)
            {
                ltrError.Text = "系统错误,保存失败!";
                this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('errordiv').style.display='';closeforseconds();", true);
                LogManagement.getInstance().WriteException(ex, "Celebrity.Save", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username);
            }
        }
Ejemplo n.º 15
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>

        public SYS_FamousMod GetModel(int SysNo)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select SysNo, Name, Description, BirthYear, BirthTime, Death, CateSysNo, Level, CustomerSysNo, DR, TS, Source, Gender, HomeTown, Height, FullName, TimeUnknown, IsTop, Photo, CollectCount from  SYS_Famous");
            strSql.Append(" where SysNo=@SysNo ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@SysNo", SqlDbType.Int, 4)
            };
            parameters[0].Value = SysNo;
            SYS_FamousMod model = new SYS_FamousMod();
            DataSet       ds    = SqlHelper.ExecuteDataSet(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["SysNo"].ToString() != "")
                {
                    model.SysNo = int.Parse(ds.Tables[0].Rows[0]["SysNo"].ToString());
                }
                model.Name        = ds.Tables[0].Rows[0]["Name"].ToString();
                model.Description = ds.Tables[0].Rows[0]["Description"].ToString();
                if (ds.Tables[0].Rows[0]["BirthYear"].ToString() != "")
                {
                    model.BirthYear = int.Parse(ds.Tables[0].Rows[0]["BirthYear"].ToString());
                }
                if (ds.Tables[0].Rows[0]["BirthTime"].ToString() != "")
                {
                    model.BirthTime = DateTime.Parse(ds.Tables[0].Rows[0]["BirthTime"].ToString());
                }
                if (ds.Tables[0].Rows[0]["Death"].ToString() != "")
                {
                    model.Death = DateTime.Parse(ds.Tables[0].Rows[0]["Death"].ToString());
                }
                if (ds.Tables[0].Rows[0]["CateSysNo"].ToString() != "")
                {
                    model.CateSysNo = int.Parse(ds.Tables[0].Rows[0]["CateSysNo"].ToString());
                }
                if (ds.Tables[0].Rows[0]["Level"].ToString() != "")
                {
                    model.Level = int.Parse(ds.Tables[0].Rows[0]["Level"].ToString());
                }
                if (ds.Tables[0].Rows[0]["CustomerSysNo"].ToString() != "")
                {
                    model.CustomerSysNo = int.Parse(ds.Tables[0].Rows[0]["CustomerSysNo"].ToString());
                }
                if (ds.Tables[0].Rows[0]["DR"].ToString() != "")
                {
                    model.DR = int.Parse(ds.Tables[0].Rows[0]["DR"].ToString());
                }
                if (ds.Tables[0].Rows[0]["TS"].ToString() != "")
                {
                    model.TS = DateTime.Parse(ds.Tables[0].Rows[0]["TS"].ToString());
                }
                model.Source = ds.Tables[0].Rows[0]["Source"].ToString();
                if (ds.Tables[0].Rows[0]["Gender"].ToString() != "")
                {
                    model.Gender = int.Parse(ds.Tables[0].Rows[0]["Gender"].ToString());
                }
                if (ds.Tables[0].Rows[0]["HomeTown"].ToString() != "")
                {
                    model.HomeTown = int.Parse(ds.Tables[0].Rows[0]["HomeTown"].ToString());
                }
                if (ds.Tables[0].Rows[0]["Height"].ToString() != "")
                {
                    model.Height = int.Parse(ds.Tables[0].Rows[0]["Height"].ToString());
                }
                model.FullName = ds.Tables[0].Rows[0]["FullName"].ToString();
                if (ds.Tables[0].Rows[0]["TimeUnknown"].ToString() != "")
                {
                    model.TimeUnknown = int.Parse(ds.Tables[0].Rows[0]["TimeUnknown"].ToString());
                }
                if (ds.Tables[0].Rows[0]["IsTop"].ToString() != "")
                {
                    model.IsTop = int.Parse(ds.Tables[0].Rows[0]["IsTop"].ToString());
                }
                model.Photo = ds.Tables[0].Rows[0]["Photo"].ToString();
                if (ds.Tables[0].Rows[0]["CollectCount"].ToString() != "")
                {
                    model.CollectCount = int.Parse(ds.Tables[0].Rows[0]["CollectCount"].ToString());
                }
                return(model);
            }
            else
            {
                return(null);
            }
        }
Ejemplo n.º 16
0
 protected void BindFamous()
 {
     this.m_famous = SYS_FamousBll.GetInstance().GetModel(this.sysno);
     if (this.m_famous.Photo == "")
     {
         this.m_famous.Photo = "";
     }
     else if (!this.m_famous.Photo.Contains("//"))
     {
         this.m_famous.Photo = AppCmn.AppConfig.WebResourcesPath()+"FamousPhoto/" + this.m_famous.Photo;
     }
     this.DataBind();
 }
Ejemplo n.º 17
0
        /// <summary>
        /// 批量导入
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void Unnamed2_Click(object sender, EventArgs e)
        {
            using (SQLData m_data = new SQLData())
            {
                for (int i = 16831; i < 40965; i++)
                {
                    DataRow m_dr = m_data.CmdtoDataRow("select * from [SPD_Famous] where sysno =" + i);
                    if (m_dr["Name"].ToString() == "" || m_dr["Biography"].ToString() == "" || m_dr["Biography"].ToString() == "SameNameError")
                    {
                        continue;
                    }
                    SYS_FamousMod m_famous = new SYS_FamousMod();
                    if (m_dr["FamousSysNo"].ToString() != "")
                    {
                        m_famous       = SYS_FamousBll.GetInstance().GetModel(int.Parse(m_dr["FamousSysNo"].ToString()));
                        m_famous.Photo = m_dr["photo"].ToString();
                        SYS_FamousBll.GetInstance().Update(m_famous);
                        //Console.WriteLine(m_dr["sysno"] + " update ");
                        continue;
                    }


                    DataTable m_area = SYS_DistrictBll.GetInstance().GetTreeDetail(m_dr["HomeTown"].ToString().Split(new char[] { '(', ',' })[0].Trim());
                    if (!CommonTools.IsDataTableNoRow(m_area))
                    {
                        m_famous.HomeTown = int.Parse(m_area.Rows[0]["SysNo3"].ToString());
                    }

                    string[] tmp    = m_dr["BirthTmp"].ToString().Split(new char[] { '-', ' ', ':' });
                    int      month  = 0;
                    int      day    = 0;
                    int      hour   = 0;
                    int      minute = 0;

                    if (tmp.Length > 6)
                    {
                        if (m_dr["BirthTmp"].ToString().StartsWith("-"))
                        {
                            m_famous.BirthYear = int.Parse("-" + tmp[1]);
                            month = int.Parse(tmp[2].Replace("January", "1").Replace("February", "2").Replace("March", "3")
                                              .Replace("April", "4").Replace("May", "5").Replace("June", "6").Replace("July", "7")
                                              .Replace("August", "8").Replace("September", "9").Replace("October", "10")
                                              .Replace("November", "11").Replace("December", "12"));
                            day = int.Parse(tmp[3]);
                            if (tmp[4] == "12" && tmp[5] == "00" && tmp[6] == "PM")
                            {
                                hour = int.Parse(tmp[4]);
                                m_famous.TimeUnknown = 1;
                            }
                            else
                            {
                                if (tmp[6] == "PM" && tmp[4] != "12")
                                {
                                    hour = (int.Parse(tmp[4]) + 12);
                                }
                                else
                                {
                                    hour = int.Parse(tmp[4]);
                                }
                                m_famous.TimeUnknown = 0;
                            }
                            minute = int.Parse(tmp[5]);
                        }
                    }
                    else
                    {
                        m_famous.BirthYear = int.Parse(tmp[0]);
                        month = int.Parse(tmp[1].Replace("January", "1").Replace("February", "2").Replace("March", "3")
                                          .Replace("April", "4").Replace("May", "5").Replace("June", "6").Replace("July", "7")
                                          .Replace("August", "8").Replace("September", "9").Replace("October", "10")
                                          .Replace("November", "11").Replace("December", "12"));
                        day = int.Parse(tmp[2]);
                        if (tmp[3] == "12" && tmp[4] == "00" && tmp[5] == "PM")
                        {
                            hour = int.Parse(tmp[3]);
                            m_famous.TimeUnknown = 1;
                        }
                        else
                        {
                            if (tmp[5] == "PM" && tmp[3] != "12")
                            {
                                hour = int.Parse(tmp[3]) + 12;
                            }
                            else
                            {
                                hour = int.Parse(tmp[3]);
                            }
                            m_famous.TimeUnknown = 0;
                        }
                        minute = int.Parse(tmp[4]);
                    }

                    m_famous.BirthTime     = new DateTime(8000, month, day, hour, minute, 0);
                    m_famous.CateSysNo     = 1;
                    m_famous.CustomerSysNo = 1;
                    m_famous.Description   = m_dr["Biography"].ToString();
                    m_famous.DR            = 0;
                    m_famous.FullName      = m_dr["FamousName"].ToString();
                    m_famous.Gender        = int.Parse(m_dr["Gender"].ToString());
                    if (m_dr["Height"].ToString() != "")
                    {
                        m_famous.Height = int.Parse(m_dr["Height"].ToString().Replace("m", ""));
                    }
                    m_famous.IsTop  = 0;
                    m_famous.Name   = m_dr["Name"].ToString();
                    m_famous.Source = "AstroTheme";
                    m_famous.TS     = DateTime.Now;
                    m_famous.Photo  = m_dr["photo"].ToString();
                    m_famous.SysNo  = SYS_FamousBll.GetInstance().Add(m_famous);
                    SPD_FamousMod m_spider = SPD_FamousBll.GetInstance().GetModel(i);
                    m_spider.FamousSysNo = m_famous.SysNo;
                    SPD_FamousBll.GetInstance().Update(m_spider);
                    //Console.WriteLine(m_dr["sysno"] + " add ");
                }
            }
        }
Ejemplo n.º 18
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public int Add(SYS_FamousMod model)
 {
     return dal.Add(model);
 }
Ejemplo n.º 19
0
        /// <summary>
        /// 增加一条数据
        /// </summary>

        public int Add(SYS_FamousMod model)
        {
            return(dal.Add(model));
        }