Exemple #1
0
        /// <summary>
        /// 获取数据列表
        /// </summary>
        /// <param name="json">json数据</param>
        /// <returns></returns>
        public List <MOrderMain> GetDataList(string json)
        {
            MOrderMain data =
                JsonData.JavaScriptDeserialize <MOrderMain>(json);

            return(handler.GetDataList(data, ORDER_BY, Lib4Net.DB.MatchMode.Exact));
        }
Exemple #2
0
        public List <MOrderMain> GetOrderListByAccount(string Account)
        {
            MOrderMain dic = new MOrderMain();

            dic.Account = Account;
            return(dbAccess.GetDataList(dic, "{f:Account}", MatchMode.Exact, ConnectMode.And));
        }
Exemple #3
0
        public ActionResult OrderShipManaul(string id)
        {
            ViewBag.Id         = id;
            ViewBag.deliveryId = Request["deliveryId"];
            MOrderMain model = new MOrderMain();

            model = OrderMainService.Instance.getFace(id);
            return(View(model));
        }
Exemple #4
0
        /// <summary>
        /// 根据订单编号获取数据信息
        /// </summary>
        /// <param name="orderNo"></param>
        /// <returns></returns>
        public OrderMainItemModel QueryOrderDetials(string orderNo)
        {
            OrderMainItemModel model  = new OrderMainItemModel();
            MOrderMain         entity = new MOrderMain();

            entity.OrderNo     = orderNo;
            model.CurrentModel = handler.GetDataListByTemplate("getOrderDetailsByOrderNo", entity).FirstOrDefault();
            model.Id           = orderNo;
            return(model);
        }
Exemple #5
0
        /// <summary>
        /// 添加或修改数据,id为空时为添加,否则为修改
        /// </summary>
        /// <param name="vo">实体数据</param>
        /// <returns></returns>
        public IResult Save(MOrderMain vo)
        {
            IResult result = new Result(false);
            bool    status = dbAccess.Save(vo) > 0;

            if (status)
            {
                result       = new Result(true);
                result["id"] = CommFun.GetString(dbAccess.Builder.ODMapConfig.PrimaryKeyField.GetValue(vo));
            }
            return(result);
        }
Exemple #6
0
        public object ReviewQuery(NameValueCollection nvc)
        {
            OrderMainListModel model  = new OrderMainListModel();
            MOrderMain         entity = new MOrderMain();

            model.PageSize = CommFun.ToInt(nvc["ps"],
                                           SettingHelper.Instance.GetInt("PageSize", 10)).Value;
            model.PageIndex = CommFun.ToInt(nvc["pi"],
                                            SettingHelper.Instance.GetInt("PageIndex", 0)).Value + 1;
            entity.SetData(nvc, false);
            entity.TrimEmptyProperty();
            entity.AddData(":PS", model.PageSize);
            entity.AddData(":PI", model.PageIndex);
            DateTime st = CommFun.ToDateTime(nvc["s"], DateTime.Now.AddDays(-1)).Value;
            DateTime et = CommFun.ToDateTime(nvc["t"], DateTime.Now).Value;

            entity.AddData("ST", st.ToString("yyyy-MM-dd"));
            entity.AddData("ET", et.ToString("yyyy-MM-dd"));
            //关键字
            string keyWords      = CommFun.GetString(nvc["KeyWords"]);
            string accountCondit = "1=1";

            if (!string.IsNullOrEmpty(keyWords))
            {
                int?type = CommFun.ToInt(nvc["keytype"], null);
                if (type == 1)
                {
                    entity.OrderNo = keyWords;
                }
                else if (type == 2)
                {
                    entity.PartnerOrderNo = keyWords;
                }
                else if (type == 3)
                {
                    accountCondit = "(t.account like '%" + keyWords + "%' or t.mobile like '%" + keyWords + "%')";
                }
                else if (type == 4)
                {
                    entity.Face = CommFun.ToDecimal(keyWords, null);
                }
            }

            entity.AddData(":Condition", accountCondit);
            model.TotalCount = CommFun.ToInt(handler.GetScalarByXmlTemplate("getReviewCount", entity), 0).GetValueOrDefault();
            if (model.TotalCount > 0)
            {
                model.List = handler.GetDataListByTemplate("getReviewList", entity);
            }
            return(model);
        }
Exemple #7
0
        /// <summary>
        /// 添加或修改数据,id为空时为添加,否则为修改
        /// </summary>
        /// <param name="id">主键值</param>
        /// <param name="vo">实体数据</param>
        /// <returns></returns>
        public IResult Save(string id, MOrderMain vo)
        {
            bool    status = false;
            IResult result = new Result(status);

            if (string.IsNullOrEmpty(id))
            {
                status = dbAccess.CreateNew(vo);
            }
            else
            {
                status = dbAccess.Update(id, vo);
            }
            if (status)
            {
                result       = new Result(true);
                result["id"] = CommFun.GetString(dbAccess.Builder.ODMapConfig.PrimaryKeyField.GetValue(vo));
            }
            return(result);
        }
Exemple #8
0
 /// <summary>
 /// 获取指定条件的数据集
 /// </summary>
 /// <param name="query">查询条件</param>
 /// <param name="orderBy">排序字段,{f:属性名} asc</param>
 /// <param name="mmode">字符串匹配模式 Exact:精确匹配 Vague:模糊匹配</param>
 /// <param name="cmode">条件连接字符串 And 或 OR</param>
 /// <returns></returns>
 public DataSet GetDataSet(MOrderMain query, string orderBy = "", MatchMode mmode = MatchMode.Exact,
                           ConnectMode cmode = ConnectMode.And)
 {
     return(dbAccess.GetDataSet(query, orderBy, mmode, cmode));
 }
Exemple #9
0
 /// <summary>
 /// 查询单实体信息(单实体数据)
 /// </summary>
 /// <param name="id">主键编号</param>
 /// <returns></returns>
 public MOrderMain GetSingleDataByTemplate(string xmlTemplateName, MOrderMain vo)
 {
     return(dbAccess.GetSingleDataByTemplate(xmlTemplateName, vo));
 }
Exemple #10
0
 /// <summary>
 /// 根据模板获取实体信息
 /// </summary>
 /// <param name="xmlTemplateName">模板名称</param>
 /// <param name="vo">实体</param>
 /// <returns></returns>
 public List <MOrderMain> GetDataListByTemplate(string xmlTemplateName, MOrderMain vo)
 {
     return(dbAccess.GetDataListByTemplate(xmlTemplateName, vo));
 }
Exemple #11
0
 /// <summary>
 /// 根据模板名称获取第一行一列的值
 /// </summary>
 /// <param name="xmlTemplateName">模板名称</param>
 /// <param name="vo">实体</param>
 /// <returns></returns>
 public object GetScalarByXmlTemplate(string xmlTemplateName, MOrderMain vo)
 {
     return(dbAccess.GetScalarByTemplate(xmlTemplateName, vo));
 }
Exemple #12
0
 /// <summary>
 /// 获取指定条件的记录总数
 /// </summary>
 /// <param name="query">查询条件</param>
 /// <param name="mmode">字符串匹配模式 Exact:精确匹配 Vague:模糊匹配</param>
 /// <param name="cmode">条件连接字符串 And 或 OR</param>
 /// <returns></returns>
 public int GetCount(MOrderMain query, MatchMode mmode = MatchMode.Exact,
                     ConnectMode cmode = ConnectMode.And)
 {
     return(dbAccess.GetCount(query, mmode, cmode));
 }
Exemple #13
0
 /// <summary>
 /// 根据主键值修改实体数据
 /// </summary>
 /// <param name="vo">实体数据</param>
 /// <returns></returns>
 public bool Update(MOrderMain vo)
 {
     return(dbAccess.Update(vo));
 }
Exemple #14
0
 /// <summary>
 /// 添加新数据
 /// </summary>
 /// <param name="vo">实体数据</param>
 /// <returns></returns>
 public bool CreateNew(MOrderMain vo)
 {
     return(dbAccess.CreateNew(vo));
 }
Exemple #15
0
 /// <summary>
 /// 根据模版获取DataSet
 /// </summary>
 /// <param name="xmlTemplateName">模板名称</param>
 /// <param name="vo">实体</param>
 /// <returns></returns>
 public DataSet GetDataSetByTemplate(string xmlTemplateName, MOrderMain vo)
 {
     return(dbAccess.GetDataSetByTemplate(xmlTemplateName, vo));
 }
Exemple #16
0
        /// <summary>
        /// 查询列表数据
        /// </summary>
        /// <param name="nvc">参数集合</param>
        /// <returns></returns>
        public OrderMainListModel Query(NameValueCollection nvc)
        {
            OrderMainListModel model  = new OrderMainListModel();
            MOrderMain         entity = new MOrderMain();

            model.PageSize = CommFun.ToInt(nvc["ps"],
                                           SettingHelper.Instance.GetInt("PageSize", 10)).Value;
            model.PageIndex = CommFun.ToInt(nvc["pi"],
                                            SettingHelper.Instance.GetInt("PageIndex", 0)).Value + 1;
            entity.SetData(nvc, false);
            entity.TrimEmptyProperty();
            entity.AddData(":PS", model.PageSize);
            entity.AddData(":PI", model.PageIndex);
            //时间
            DateTime starttime = CommFun.ToDateTime(nvc["e"], DateTime.Now).Value;
            DateTime endtime   = starttime.AddDays(1);

            if (!string.IsNullOrEmpty(nvc["h"]))
            {
                //近半个小时
                entity.AddData(":ST", " t.create_time >= sysdate-30/24/60");
                entity.AddData(":ET", " t.create_time < sysdate+30/24/60");
            }
            else
            {
                entity.AddData(":ST", " t.create_time>=to_date('" + starttime + "','yyyy-mm-dd  hh24:mi:ss')");
                entity.AddData(":ET", "t.create_time<to_date('" + endtime + "','yyyy-mm-dd  hh24:mi:ss')");
            }
            //关键字
            string keyWords      = CommFun.GetString(nvc["KeyWords"]);
            string accountCondit = "1=1";

            if (!string.IsNullOrEmpty(keyWords))
            {
                int?type = CommFun.ToInt(nvc["keytype"], null);
                if (type == 1)
                {
                    entity.OrderNo = keyWords;
                }
                else if (type == 2)
                {
                    entity.PartnerOrderNo = keyWords;
                }
                else if (type == 3)
                {
                    accountCondit = "(t.account like '%" + keyWords + "%' or t.mobile like '%" + keyWords + "%')";
                }
                else if (type == 4)
                {
                    entity.Face = CommFun.ToDecimal(keyWords, null);
                }
            }

            entity.AddData(":Condition", accountCondit);
            model.TotalCount = CommFun.ToInt(handler.GetScalarByXmlTemplate("getCount", entity), 0).GetValueOrDefault();
            if (model.TotalCount > 0)
            {
                model.List = handler.GetDataListByTemplate("getList", entity);
            }
            return(model);
        }
Exemple #17
0
 /// <summary>
 /// 获取分页数据集
 /// </summary>
 /// <param name="query">查询条件</param>
 /// <param name="pageSize">分页</param>
 /// <param name="pageIndex">页索引从1开始</param>
 /// <param name="totalCount">总条数</param>
 /// <param name="orderBy">排序字段</param>
 /// <param name="mmode">字符串匹配模式 Exact:精确匹配 Vague:模糊匹配</param>
 /// <param name="cmode">条件连接字符串 And 或 OR</param>
 /// <returns></returns>
 public DataSet GetPagerDataSet(MOrderMain query, int pageSize, int pageIndex, out int totalCount, string orderBy = "", MatchMode mmode = MatchMode.Exact,
                                ConnectMode cmode = ConnectMode.And)
 {
     totalCount = dbAccess.GetCount(query, mmode, cmode);
     return(dbAccess.GetPagerData(query, pageSize, pageIndex, orderBy, mmode, cmode));
 }