Пример #1
0
        public JsonResult PublishNewHeart()
        {
            //发布心愿采用form方式。。。。
            NewHeart newHeart = new NewHeart();
            newHeart = Common.JosnDeserialize<NewHeart>(Request.Form["NewHeart"].ToString(), null);
            string joinerLoginName = Request.Form["joinerLoginName"].ToString();

            JsonResult jr = new JsonResult();
            jr.ContentType = "text/json";
            jr.JsonRequestBehavior = JsonRequestBehavior.AllowGet;

            if (DBTools.PubNewHeart(newHeart, joinerLoginName))
            {
                jr.Data = new { isSuccess = true };
            }
            else
            {
                jr.Data = new { isSuccess = false, errorMessage = "Pub Heart Error" };
            }
            return jr;
        }
Пример #2
0
        public static List<NewHeart> GetNewMessage(string loginName)
        {
            DataTable dt = null;
            List<NewHeart> list = new List<NewHeart>();

            string sql = string.Format(@"select *  from ht_userJoin j
                    inner join ht_heartInfo h on j.heartId=h.heartId
                    where joinerLoginName='{0}' and isRead='false' ", loginName);
            try
            {
                dt = SqlHelper.ExecuteDataset(ConnString.GetConString, CommandType.Text, sql.ToString()).Tables[0];
                if (dt.Rows.Count > 0)
                {
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        NewHeart nh = new NewHeart();
                        nh.Contact = dt.Rows[i]["contact"].ToString();
                        if (string.IsNullOrEmpty(dt.Rows[i]["endDate"].ToString()))
                        {
                            nh.FinishDate = string.Empty;
                        }
                        else
                        {
                            nh.FinishDate = Convert.ToDateTime(dt.Rows[i]["endDate"].ToString()).ToString("yyyy-MM-dd");
                        }
                        nh.HeartContent = dt.Rows[i]["content"].ToString();
                        nh.HeartLevel = int.Parse(dt.Rows[i]["heartLevel"].ToString());
                        nh.Joiner = dt.Rows[i]["participator"].ToString();
                        nh.Puber = dt.Rows[i]["pubName"].ToString();
                        nh.Title = dt.Rows[i]["title"].ToString();
                        nh.Station = int.Parse(dt.Rows[i]["station"].ToString());
                        nh.HeartId = int.Parse(dt.Rows[i]["heartId"].ToString());
                        list.Add(nh);
                    }
                }
            }
            catch
            {
                return null;
            }
            return list;
        }
Пример #3
0
        /// <summary>
        /// 发布心愿
        /// </summary>
        /// <param name="newHeart">心愿内容</param>
        /// <param name="joinerLoginName">参与者登录名(可选)</param>
        /// <returns></returns>
        public static bool PubNewHeart(NewHeart newHeart, string joinerLoginName = "")
        {
            try
            {
                string sql = string.Format(@"INSERT INTO ht_heartInfo
                       ([title]
                       ,[pubID]
                       ,[pubName]
                       ,[participator]
                       ,[contact]
                       ,[bgImage]
                       ,[content]
                       ,[beginDate]
                       ,[endDate]
                       ,[heartLevel]
                       ,[station]
                       ,[isPrivate])
                 VALUES
                       (@title
                       ,@pubID
                       ,@pubName
                       ,@participator
                       ,@contact
                       ,@bgImage
                       ,@content
                       ,@beginDate
                       ,@endDate
                       ,@heartLevel
                       ,@station
                       ,@isPrivate)");
                SqlParameter[] parameters = {
                    new SqlParameter("@title", SqlDbType.NVarChar),
                    new SqlParameter("@pubID", SqlDbType.NVarChar),
                    new SqlParameter("@pubName", SqlDbType.NVarChar),
                    new SqlParameter("@participator", SqlDbType.NVarChar),
                    new SqlParameter("@contact", SqlDbType.NVarChar),
                    new SqlParameter("@bgImage", SqlDbType.NVarChar),
                    new SqlParameter("@content", SqlDbType.NVarChar),
                    new SqlParameter("@beginDate", SqlDbType.DateTime),
                    new SqlParameter("@endDate", SqlDbType.DateTime),
                    new SqlParameter("@heartLevel", SqlDbType.Int),
                    new SqlParameter("@station", SqlDbType.Int) ,
                    new SqlParameter("@isPrivate", SqlDbType.Int)
                                        };
                parameters[0].Value = newHeart.Title;
                parameters[1].Value = newHeart.PubId;
                parameters[2].Value = newHeart.Puber;
                parameters[3].Value = newHeart.Joiner;
                parameters[4].Value = newHeart.Contact;
                parameters[5].Value = 1;//newHeart.bgimage;
                parameters[6].Value = newHeart.HeartContent;
                parameters[7].Value = DateTime.Now;
                parameters[8].Value = newHeart.FinishDate == "" ? null : newHeart.FinishDate;
                parameters[9].Value = newHeart.HeartLevel;
                parameters[10].Value = 0;//newHeart.station;
                parameters[11].Value = newHeart.IsPrivate;
                object o = SqlHelper.ExecuteNonQuery(ConnString.GetConString, CommandType.Text, sql, parameters);

                //获取heartId
                string sql_maxId = "select max( heartId) from ht_heartInfo ";
                object id = SqlHelper.ExecuteScalar(ConnString.GetConString, CommandType.Text, sql_maxId);

                //绑定参与关系
                BindUserJoin(int.Parse(id.ToString()), newHeart.PubId, newHeart.Joiner, joinerLoginName);
            }
            catch (Exception)
            {

                return false;
            }
            return true;
        }
Пример #4
0
        /// <summary>
        /// 根据登录名获取心愿信息
        /// </summary>
        /// <param name="loginName">登录名</param>
        /// <returns></returns>
        public static List<NewHeart> GetHeartsByLoginName(string loginName)
        {
            DataTable dt = null;
            List<NewHeart> list = new List<NewHeart>();

            string sql = " select * from ht_heartInfo where pubId='" + loginName + "' order by heartId desc";
            try
            {
                dt = SqlHelper.ExecuteDataset(ConnString.GetConString, CommandType.Text, sql.ToString()).Tables[0];
                if (dt.Rows.Count > 0)
                {
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        NewHeart nh = new NewHeart();
                        nh.Contact = dt.Rows[i]["contact"].ToString();
                        if (string.IsNullOrEmpty(dt.Rows[i]["endDate"].ToString()))
                        {
                            nh.FinishDate = string.Empty;
                        }
                        else
                        {
                            nh.FinishDate = Convert.ToDateTime(dt.Rows[i]["endDate"].ToString()).ToString("yyyy-MM-dd");
                        }
                        nh.HeartContent = dt.Rows[i]["content"].ToString();
                        nh.HeartLevel = int.Parse(dt.Rows[i]["heartLevel"].ToString());
                        nh.Joiner = dt.Rows[i]["participator"].ToString();
                        nh.Puber = dt.Rows[i]["pubName"].ToString();
                        nh.Title = dt.Rows[i]["title"].ToString();
                        nh.Station = int.Parse(dt.Rows[i]["station"].ToString());
                        nh.HeartId = int.Parse(dt.Rows[i]["heartId"].ToString());
                        list.Add(nh);
                    }
                }
            }
            catch
            {
                return null;
            }
            return list;
        }