C# (CSharp) MDLC_Blog Examples

Example #1

        /// <summary>
        /// Add one record
        /// </summary>
        public int Add(MDLC_Blog model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("INSERT INTO [C_Blog](");
            strSql.Append("[BlogId],[BlogTitle],[BlogCategory],[Tag],[Content],[Hits],[IsDisplay],[Sequence],[AddedTime],[AddedBy],[UpdatedTime],[UpdatedBy]");
            strSql.Append(")");
            strSql.Append(" VALUES (");
            strSql.Append("" + model.BlogId + ",");
            strSql.Append("" + model.BlogTitle + ",");
            strSql.Append("" + model.BlogCategory + ",");
            strSql.Append("" + model.Tag + ",");
            strSql.Append("" + model.Content + ",");
            strSql.Append("" + model.Hits + ",");
            strSql.Append("" + model.IsDisplay + ",");
            strSql.Append("" + model.Sequence + ",");
            strSql.Append("" + model.AddedTime + ",");
            strSql.Append("" + model.AddedBy + ",");
            strSql.Append("" + model.UpdatedTime + ",");
            strSql.Append("" + model.UpdatedBy + "");
            strSql.Append(")");
            strSql.Append(";SELECT @@IDENTITY");
            object obj = DbHelperSQL.GetSingle(strSql.ToString());

            if (obj == null)
            {
                return(1);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }

Example #2

File: C_Blog.cs Project: jojozhuang/Projects

        /// <summary>
        /// Add one record
        /// </summary>
        public int Add(MDLC_Blog model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("INSERT INTO [C_Blog](");
            strSql.Append("[BlogId],[BlogTitle],[BlogCategory],[Tag],[Content],[Hits],[IsDisplay],[Sequence],[AddedTime],[AddedBy],[UpdatedTime],[UpdatedBy]");
            strSql.Append(")");
            strSql.Append(" VALUES (");
            strSql.Append("" + model.BlogId + ",");
			strSql.Append("" + model.BlogTitle + ",");
			strSql.Append("" + model.BlogCategory + ",");
			strSql.Append("" + model.Tag + ",");
			strSql.Append("" + model.Content + ",");
			strSql.Append("" + model.Hits + ",");
			strSql.Append("" + model.IsDisplay + ",");
			strSql.Append("" + model.Sequence + ",");
			strSql.Append("" + model.AddedTime + ",");
			strSql.Append("" + model.AddedBy + ",");
			strSql.Append("" + model.UpdatedTime + ",");
			strSql.Append("" + model.UpdatedBy + "");
			strSql.Append(")");
            strSql.Append(";SELECT @@IDENTITY");
            object obj = DbHelperSQL.GetSingle(strSql.ToString());
            if (obj == null)
            {
                return 1;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }

Example #3

File: C_Blog.cs Project: jojozhuang/Projects

		/// <summary>
        /// Method to get one recoder by primary key
        /// </summary>    	 
        public MDLC_Blog GetModel(int BlogId)
        {
			//Set up a return value
            MDLC_Blog model = null;

            StringBuilder strSql = new StringBuilder();
            strSql.Append("SELECT [BlogId], [BlogTitle], [BlogCategory], [Tag], [Content], [Hits], [IsDisplay], [Sequence], [AddedTime], [AddedBy], [UpdatedTime], [UpdatedBy] ");
            strSql.Append(" FROM [C_Blog] ");
            strSql.Append(" WHERE [BlogId]=" + BlogId.ToString());
            using (SqlDataReader sdr = DbHelperSQL.ExecuteReader(strSql.ToString()))
            {
                if (sdr.Read())
                    model = new MDLC_Blog(sdr.(0), sdr.(1), sdr.(2), sdr.(3), sdr.(4), sdr.(5), sdr.(6), sdr.(7), sdr.(8), sdr.(9), sdr.(10), sdr.(11));
				else
                    model = new MDLC_Blog();                
            }
            return model;
        }

Example #4

        /// <summary>
        /// Update one record
        /// </summary>
        public void Update(MDLC_Blog model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("UPDATE [C_Blog] SET ");
            strSql.Append("[BlogId]=" + model.BlogId + ",");
            strSql.Append("[BlogTitle]=" + model.BlogTitle + ",");
            strSql.Append("[BlogCategory]=" + model.BlogCategory + ",");
            strSql.Append("[Tag]=" + model.Tag + ",");
            strSql.Append("[Content]=" + model.Content + ",");
            strSql.Append("[Hits]=" + model.Hits + ",");
            strSql.Append("[IsDisplay]=" + model.IsDisplay + ",");
            strSql.Append("[Sequence]=" + model.Sequence + ",");
            strSql.Append("[AddedTime]=" + model.AddedTime + ",");
            strSql.Append("[AddedBy]=" + model.AddedBy + ",");
            strSql.Append("[UpdatedTime]=" + model.UpdatedTime + ",");
            strSql.Append("[UpdatedBy]=" + model.UpdatedBy + "");
            strSql.Append(" WHERE [BlogId]=" + model.BlogId + "");
            DbHelperSQL.ExecuteSql(strSql.ToString());
        }

Example #5

        /// <summary>
        /// Method to get one recoder by primary key
        /// </summary>
        public MDLC_Blog GetModel(int BlogId)
        {
            //Set up a return value
            MDLC_Blog model = null;

            StringBuilder strSql = new StringBuilder();

            strSql.Append("SELECT [BlogId], [BlogTitle], [BlogCategory], [Tag], [Content], [Hits], [IsDisplay], [Sequence], [AddedTime], [AddedBy], [UpdatedTime], [UpdatedBy] ");
            strSql.Append(" FROM [C_Blog] ");
            strSql.Append(" WHERE [BlogId]=" + BlogId.ToString());
            using (SqlDataReader sdr = DbHelperSQL.ExecuteReader(strSql.ToString()))
            {
                if (sdr.Read())
                {
                    model = new MDLC_Blog(sdr.(0), sdr.(1), sdr.(2), sdr.(3), sdr.(4), sdr.(5), sdr.(6), sdr.(7), sdr.(8), sdr.(9), sdr.(10), sdr.(11));
                }
                else
                {
                    model = new MDLC_Blog();
                }
            }
            return(model);
        }

Example #6

File: C_Blog.cs Project: jojozhuang/Projects

        /// <summary>
        /// Update one record
        /// </summary>
        public void Update(MDLC_Blog model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("UPDATE [C_Blog] SET ");
            strSql.Append("[BlogId]=" + model.BlogId + ",");
			strSql.Append("[BlogTitle]=" + model.BlogTitle + ",");
			strSql.Append("[BlogCategory]=" + model.BlogCategory + ",");
			strSql.Append("[Tag]=" + model.Tag + ",");
			strSql.Append("[Content]=" + model.Content + ",");
			strSql.Append("[Hits]=" + model.Hits + ",");
			strSql.Append("[IsDisplay]=" + model.IsDisplay + ",");
			strSql.Append("[Sequence]=" + model.Sequence + ",");
			strSql.Append("[AddedTime]=" + model.AddedTime + ",");
			strSql.Append("[AddedBy]=" + model.AddedBy + ",");
			strSql.Append("[UpdatedTime]=" + model.UpdatedTime + ",");
			strSql.Append("[UpdatedBy]=" + model.UpdatedBy + "");
			strSql.Append(" WHERE [BlogId]=" + model.BlogId + "");
            DbHelperSQL.ExecuteSql(strSql.ToString());
        }

Example #7

File: C_Blog.cs Project: jojozhuang/Projects

 /// <summary>
 /// Update one record
 /// </summary>
 public void Update(MDLC_Blog model)
 {
 	dal.Update(model);
 }

Example #8

File: C_Blog.cs Project: jojozhuang/Projects

 /// <summary>
 /// Add one record
 /// </summary>
 public int Add(MDLC_Blog model)
 {
     return dal.Add(model);
 }

Example #9

File: C_Blog.cs Project: jojozhuang/code-generator-winform

 /// <summary>
 /// Update one record
 /// </summary>
 public void Update(MDLC_Blog model)
 {
     dal.Update(model);
 }

Example #10

File: C_Blog.cs Project: jojozhuang/code-generator-winform

 /// <summary>
 /// Add one record
 /// </summary>
 public int Add(MDLC_Blog model)
 {
     return(dal.Add(model));
 }