Ejemplo n.º 1
0
        public JObject Delete(JObject data)
        {
            try
            {
                DBServer  dbserver  = new SqlServer();
                AvgCredit rolemodel = new AvgCredit(dbserver);
                string    ID        = data["data"].ToString().Replace("\"", "");

                string filter = String.Format("ID='{0}'", ID);
                int    res    = rolemodel.Delete("ID", ID);

                if (res > 0)
                {
                    return(ShowSuccess("成功删除" + res + "条记录."));
                }
                else
                {
                    return(ShowExecuteError("删除失败."));
                }
            }

            catch (Exception ex)
            {
                return(ShowExecuteError(ex.Message));
            }
        }
Ejemplo n.º 2
0
        public JObject Edit(JObject data)
        {
            try
            {
                DBServer  dbserver = new SqlServer();
                AvgCredit model    = new AvgCredit(dbserver);

                if (model.Update(data))
                {
                    return(ShowSuccess("保存成功."));
                }
                else
                {
                    return(ShowExecuteError("保存失败."));
                }
            }
            catch (Exception ex)
            {
                return(ShowExecuteError(ex.Message));
            }
        }
Ejemplo n.º 3
0
        public JObject Add(JObject data)
        {
            try
            {
                DBServer  dbserver = new SqlServer();
                AvgCredit model    = new AvgCredit(dbserver);

                data.Remove("ID");
                data.Add(new JProperty("ID", GUID.NewGuid()));
                if (model.Create(data))
                {
                    return(ShowSuccess("保存成功."));
                }
                else
                {
                    return(ShowExecuteError("保存失败."));
                }
            }
            catch (Exception ex)
            {
                return(ShowExecuteError(ex.Message));
            }
        }
Ejemplo n.º 4
0
 public JObject PageLoad(long start, long limit, string field, string direction, string searchInfo)
 {
     try
     {
         DBSortPage   dbsort   = new DBSortPage(start, limit, field, direction);
         DBServer     dbserver = new SqlServer();
         AvgCredit    mybase   = new AvgCredit(dbserver);
         DBSearchInfo sinfo    = new DBSearchInfo(searchInfo);
         if (sinfo.Count <= 0)
         {
             return(mybase.Load(dbsort));
         }
         else
         {
             string filterf = sinfo.GetSiftQueryString();
             return(mybase.Load(dbsort, filterf));
         }
     }
     catch (Exception ex)
     {
         return(ShowDataLoadError(ex.Message));
     }
 }