예제 #1
0
        public static long Insert(c_voteEntity item)
        {
            long id = 0;

            try
            {
                DataTable dt = DBAccess.DataAccess.Miou_GetDataSetBySql(DBAccess.LogUName, string.Format("select * from {0} where {1} = {2} ;", tableName, keyName, 0)).Tables[0];
                dt.TableName = tableName;
                DataRow dr = dt.NewRow();
                item.createtime = DateTime.Now;
                item.lasttime   = item.createtime;
                DBAccess.FillDataRow(ref dr, item);
                List <long> ids = new List <long>();

                dt.Rows.Add(dr);

                if (DBAccess.DataAccess.Miou_UpdateDataTablesNoTranWithIndentity(DBAccess.LogUName
                                                                                 , new List <DataTable> {
                    dt
                }, out ids).StartsWith("000"))
                {
                    if (ids.Count > 0)
                    {
                        id = ids[0];
                    }
                }
            }
            catch (Exception ex)
            {
                string ss = ex.ToString();
            }
            return(id);
        }
예제 #2
0
        public static bool Update(c_voteEntity item, ref string info)
        {
            bool rv = true;

            try
            {
                DataTable dt = DBAccess.DataAccess.Miou_GetDataSetBySql(DBAccess.LogUName, string.Format("select * from {0} where {1} = {2} ;", tableName, keyName, item.voteid)).Tables[0];

                if (dt.Rows.Count > 0)
                {
                    item.lasttime = DateTime.Now;
                    DataRow dr = dt.Rows[0];
                    DBAccess.FillDataRow(ref dr, item);

                    string vs = DBAccess.DataAccess.Miou_UpdateDataSet(DBAccess.LogUName, tableName, "*", "1<>1", "", dt);
                    if (!vs.StartsWith("000000"))
                    {
                        rv   = false;
                        info = vs.Substring(6);
                    }
                }
                else
                {
                    rv   = false;
                    info = "找不到记录!";
                }
            }
            catch (Exception ex)
            {
                info = ex.Message;
                rv   = false;
            }

            return(rv);
        }
예제 #3
0
        public static c_voteEntity GetByKeyId(int id, ref string info)
        {
            try
            {
                c_voteEntity entity = new c_voteEntity();
                DataTable    dt     = DBAccess.DataAccess.Miou_GetDataSetBySql(DBAccess.LogUName, string.Format("select * from {0} where {1} = {2} ;", tableName, keyName, id)).Tables[0];
                var          list   = DBAccess.GetEntityList <c_voteEntity>(dt);
                if (list != null && list.Count > 0)
                {
                    entity = list[0];
                }

                return(entity);
            }
            catch (Exception ex)
            {
                info = ex.Message;
                return(new c_voteEntity());
            }
        }
예제 #4
0
        public JsonResult submitvote(string title, string remark, DateTime enddte, int vid = 0)
        {
            if (!Common.HeistMon.HMon.GetInstance().AddMon("submitvote_" + base.GetUserid(), 20))
            {
                this.HttpContext.Response.Write("FireWall!");
                this.HttpContext.Response.End();
                return(null);
            }

            AjaxResult ajax = new AjaxResult();

            ajax.ErrorMessage = "";
            ajax.RetCode      = 1;


            var u = GetUser();

            if (u == null || u.uid <= 0)
            {
                ajax.ErrorMessage = "用户登录超时,请重新登录.";
                return(Json(ajax));
            }
            if (u.isvip == 0 && u.vipdate <= DateTime.Now.Date)
            {
                ajax.ErrorMessage = "您无发起投票的权限,请联系社区相关人员.";
                return(Json(ajax));
            }

            if (string.IsNullOrEmpty(title.Trim()))
            {
                ajax.ErrorMessage = "投票主题未填.";
                return(Json(ajax));
            }
            if (enddte < DateTime.Now.Date.AddDays(1))
            {
                ajax.ErrorMessage = "日期不能小于当天.";
                return(Json(ajax));
            }
            double addvoteprice  = 0;
            double joinvoteprice = 0;

            if (vid == 0)
            {
                if (LinkTokenSQ.MvcApplication.Syspar.ContainsKey("addvoteprice"))
                {
                    double.TryParse(LinkTokenSQ.MvcApplication.Syspar["addvoteprice"].keyvalue, out addvoteprice);
                }
                if (LinkTokenSQ.MvcApplication.Syspar.ContainsKey("joinvoteprice"))
                {
                    double.TryParse(LinkTokenSQ.MvcApplication.Syspar["joinvoteprice"].keyvalue, out joinvoteprice);
                }
            }
            string       info = "";
            c_voteEntity vote = new c_voteEntity();

            if (vid > 0)
            {
                var list = c_voteDal.GetListByWhere(string.Format(" and voteid={0} and uid={1} ", vid, u.uid), ref info);
                if (list == null || list.Count == 0)
                {
                    ajax.ErrorMessage = "数据未找到.";
                    return(Json(ajax));
                }
                vote = list[0];
            }
            else
            {
                vote.createtime = DateTime.Now;
            }
            vote.lasttime     = DateTime.Now;
            vote.votetitle    = title;
            vote.votestatus   = 0;
            vote.votetype     = 0;
            vote.remark       = remark;
            vote.paywkcamount = addvoteprice;
            vote.uid          = u.uid;
            vote.voteid       = vid;
            vote.enddate      = enddte;
            if (vote.voteid == 0)
            {
                long voteid = c_voteDal.Insert(vote);

                if (voteid > 0)
                {
                    if (addvoteprice > 0)
                    {
                        if (DBAccess.UserPay(u.uid, addvoteprice) != 1)
                        {
                            c_voteDal.Del(voteid.ToString(), ref info);
                            ajax.ErrorMessage = "支付失败,可能账户余额不足.";
                            return(Json(ajax));
                        }
                    }
                    ajax.ErrorMessage = voteid.ToString();
                }
                else
                {
                    ajax.ErrorMessage = "保存失败,请重试试.";
                    return(Json(ajax));
                }
            }
            else
            {
                if (vote.votestatus > 3)
                {
                    ajax.ErrorMessage = "不能修改.";
                    return(Json(ajax));
                }
                if (!c_voteDal.Update(vote, ref info))
                {
                    ajax.ErrorMessage = "保存失败,请重试试.";
                    return(Json(ajax));
                }
                else
                {
                    ajax.ErrorMessage = "已保存.";
                    return(Json(ajax));
                }
            }
            ajax.RetCode = 0;
            return(Json(ajax));
        }