Пример #1
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public static IMSG GetModel(int ID, int msg_to)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 ID,msg_from,msg_to,msg_content,msg_addtime,msg_title from Msg ");
            strSql.Append(" where ID=@ID and msg_to  = @msg_to");
            SqlParameter[] parameters =
            {
                new SqlParameter("@ID",     SqlDbType.Int, 4),
                new SqlParameter("@msg_to", SqlDbType.Int, 4)
            };
            parameters[0].Value = ID;
            parameters[1].Value = msg_to;

            IMSG    model = new IMSG();
            DataSet ds    = DataBase.ExecuteDataset(CommandType.Text, strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["ID"].ToString() != "")
                {
                    model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
                }
                if (ds.Tables[0].Rows[0]["msg_from"].ToString() != "")
                {
                    model.msg_from = int.Parse(ds.Tables[0].Rows[0]["msg_from"].ToString());
                }
                if (ds.Tables[0].Rows[0]["msg_to"].ToString() != "")
                {
                    model.msg_to = int.Parse(ds.Tables[0].Rows[0]["msg_to"].ToString());
                }
                model.msg_content = ds.Tables[0].Rows[0]["msg_content"].ToString();
                if (ds.Tables[0].Rows[0]["msg_addtime"].ToString() != "")
                {
                    model.msg_addtime = DateTime.Parse(ds.Tables[0].Rows[0]["msg_addtime"].ToString());
                }
                model.msg_title = ds.Tables[0].Rows[0]["msg_title"].ToString();
                return(model);
            }
            else
            {
                return(null);
            }
        }
Пример #2
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public static bool Update(IMSG model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update Msg set ");
            strSql.Append("msg_from=@msg_from,");
            strSql.Append("msg_to=@msg_to,");
            strSql.Append("msg_content=@msg_content,");
            strSql.Append("msg_addtime=@msg_addtime,");
            strSql.Append("msg_title=@msg_title,");
            strSql.Append("isRead=@isRead");
            strSql.Append(" where ID=@ID");
            SqlParameter[] parameters =
            {
                new SqlParameter("@msg_from",    SqlDbType.Int,          4),
                new SqlParameter("@msg_to",      SqlDbType.Int,          4),
                new SqlParameter("@msg_content", SqlDbType.NVarChar,  2000),
                new SqlParameter("@msg_addtime", SqlDbType.DateTime),
                new SqlParameter("@msg_title",   SqlDbType.NVarChar,    50),
                new SqlParameter("@ID",          SqlDbType.Int,          4),
                new SqlParameter("@isRead",      SqlDbType.Bit, 1)
            };
            parameters[0].Value = model.msg_from;
            parameters[1].Value = model.msg_to;
            parameters[2].Value = model.msg_content;
            parameters[3].Value = model.msg_addtime;
            parameters[4].Value = model.msg_title;
            parameters[5].Value = model.ID;
            parameters[6].Value = model.isRead;

            int rows = DataBase.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Пример #3
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public static int Add(IMSG model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into Msg(");
            strSql.Append("msg_from,msg_to,msg_content,msg_addtime,msg_title,msg_fromname)");
            strSql.Append(" values (");
            strSql.Append("@msg_from,@msg_to,@msg_content,@msg_addtime,@msg_title,@msg_fromname)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@msg_from",     SqlDbType.Int,          4),
                new SqlParameter("@msg_to",       SqlDbType.Int,          4),
                new SqlParameter("@msg_content",  SqlDbType.NVarChar,  2000),
                new SqlParameter("@msg_addtime",  SqlDbType.DateTime),
                new SqlParameter("@msg_title",    SqlDbType.NVarChar,    50),
                new SqlParameter("@msg_fromname", SqlDbType.NVarChar, 50)
            };
            parameters[0].Value = model.msg_from;
            parameters[1].Value = model.msg_to;
            parameters[2].Value = model.msg_content;
            parameters[3].Value = model.msg_addtime;
            parameters[4].Value = model.msg_title;
            parameters[5].Value = model.msg_fromname;

            object obj = DataBase.ExecuteScalar(CommandType.Text, strSql.ToString(), parameters);

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