Beispiel #1
0
        /// <summary>
        /// token 信息,获取token详细信息
        /// </summary>
        /// <param name="accessToken"></param>
        /// <returns></returns>
        public UserTokenModel getUserToken(int uid)
        {
            userTokenModel = new ModelAdo <Model.UserTokenModel>();
            UserTokenModel model = userTokenModel.GetModel(" uid=?uid ", "", new MySqlParameter("?uid", uid));

            return(model);
        }
Beispiel #2
0
        public override BarcodeModel.MODEL.BaseSearchModel Insert()
        {
            if (Barcodes == null || Barcodes.Length == 0)
            {
                throw new Exception("请扫描或输入领料单对应的条码标签");
            }
            else if (string.IsNullOrEmpty(ReceiveId))
            {
                throw new Exception("请扫描或输入领料单的条码标签");
            }
            else
            {
                ModelAdo<ReceiveModel> adoReceive = new ModelAdo<ReceiveModel>();
                ReceiveModel receiveModel = adoReceive.GetModel(ReceiveId);
                if (receiveModel == null)
                {
                    throw new Exception("领料单不存在");
                }
                else
                {

                }
            }
            return base.Insert();
        }
Beispiel #3
0
        /// <summary>
        /// token 信息,获取token详细信息
        /// </summary>
        /// <param name="accessToken"></param>
        /// <returns></returns>
        public UserTokenModel getUserToken(string accessToken)
        {
            userTokenModel = new ModelAdo <Model.UserTokenModel>();
            UserTokenModel model = userTokenModel.GetModel(" accessToken=?accessToken ", "", new MySqlParameter("?accessToken", accessToken));

            return(model);
        }
        public override void OnLoad(HttpContext context)
        {
            base.OnLoad(context);
            requestBody             = new RequestBody();
            requestBody.userName    = context.Request["userName"];
            requestBody.userPwd     = context.Request["userPwd"];
            requestBody.userType    = context.Request["userType"];
            requestBody.bpuserid    = context.Request["bpuserid"];
            requestBody.channelid   = context.Request["channelid"];
            requestBody.deviceToken = context.Request["deviceToken"];
            requestBody.deviceType  = context.Request["deviceType"];
            if (requestBody.userType == null || requestBody.userName == null || requestBody.userPwd == null)
            {
                SystemResponse.Output(SystemResponse.TYPE_NULLPARAMETER, out statusCode, out responseJson);
            }
            else
            {
                string password = StringHelper.StringToMD5(requestBody.userPwd);
                ModelAdo <UserModel> userModel = new ModelAdo <UserModel>();
                UserModel            model     = userModel.GetModel(" rid=?rid and name =?name and password=?password", "",
                                                                    new MySqlParameter("?rid", requestBody.userType),
                                                                    new MySqlParameter("?name", requestBody.userName),
                                                                    new MySqlParameter("?password", password));

                if (model == null)
                {
                    SystemResponse.Output(SystemResponse.TYPE_LOGIN_ERROR, out statusCode, out responseJson);
                }
                else
                {
                    DateTime       dt             = DateTime.Now;
                    string         accessToken    = StringHelper.StringToMD5(dt.ToString());
                    TokenHelper    token          = new TokenHelper();
                    UserTokenModel modelUserToken = new UserTokenModel();
                    modelUserToken.uid         = model.id.ToString();
                    modelUserToken.rid         = model.rid;
                    modelUserToken.accessToken = accessToken;
                    modelUserToken.bpuserId    = requestBody.bpuserid;
                    modelUserToken.channelId   = requestBody.channelid;
                    modelUserToken.deviceToken = requestBody.deviceToken;
                    modelUserToken.deviceType  = Convert.ToInt32(requestBody.deviceType);
                    modelUserToken.loginTime   = StringHelper.ConvertDateTimeInt(DateTime.Now);
                    modelUserToken.isLogin     = 1;
                    token.updateToken(modelUserToken);

                    responseBody = new ResponseBody
                    {
                        accessToken = accessToken,
                        uid         = model.id.ToString(),
                        userName    = model.name,
                        nickName    = model.nickname,
                        userAvatar  = model.avatar,
                        userType    = model.rid
                    };
                    responseJson = JsonConvert.SerializeObject(responseBody, Formatting.Indented);
                }
            }
        }
Beispiel #5
0
        /// <summary>
        /// token 信息,修改token详细信息
        /// </summary>
        /// <param name="accessToken"></param>
        /// <returns></returns>
        public int updateToken(UserTokenModel model)
        {
            int obj = 0;

            userTokenModel = new ModelAdo <Model.UserTokenModel>();
            UserTokenModel token = userTokenModel.GetModel(" uid =?uid ", "", new MySqlParameter("?uid", model.uid));

            if (token != null)
            {
                model.id = token.id;
                obj      = userTokenModel.Update(model);
            }
            else
            {
                obj = userTokenModel.Insert(model);
            }
            return(obj);
        }
Beispiel #6
0
        public override BaseSearchModel Insert()
        {
            ModelAdo<UserModel> adoUser = new ModelAdo<UserModel>();
            userModel = adoUser.GetModel("UR01003=@loginName and UR01004=@pass", "", new SqlParameter("@loginName", this.LoginName), new SqlParameter("@pass", this.Password));
            if (userModel != null)
            {

                ModelAdo<LoginHistoryModel> adoLH = new ModelAdo<LoginHistoryModel>();
                loginHistoryModel = adoLH.GetModel("UR05002=@id and UR05005=1", "*", new SqlParameter("@id", userModel.ID));
                if (loginHistoryModel != null)
                {
                    this.ErrorMsg = string.Format("用户{0}已在其他{1}终端登录,请先退出", userModel.UserName, loginHistoryModel.LoginType);
                    this.LoginSuccess = false;
                }
                else
                {
                    string id = Guid.NewGuid().ToString();
                    loginHistoryModel = new LoginHistoryModel()
                    {
                        ID = id,
                        LoginTime = DateTime.Now,
                        LogoutTime = DateTime.Now,
                        ComputerName = this.ComputerName,
                        IP = this.IP,
                        LoginStatus = 1,
                        LoginType = this.LoginType,
                        UserID = userModel.ID
                    };
                    int result = adoLH.Insert(loginHistoryModel);
                    if (result == 1)
                    {
                        this.Token = id;
                        this.UserID = userModel.ID;
                        this.LoginSuccess = true;
                    }
                }
            }
            else
            {
                this.LoginSuccess = false;
                this.ErrorMsg = "用户名或密码不正确";
            }
            return this;
        }
        public override void OnLoad(HttpContext context)
        {
            base.OnLoad(context);
            requestBody          = new RequestBody();
            requestBody.userName = context.Request["userName"];
            requestBody.userPwd  = context.Request["userPwd"];
            requestBody.userType = context.Request["userType"];
            if (requestBody.userName == null || requestBody.userPwd == null || requestBody.userType == null)
            {
                SystemResponse.Output(SystemResponse.TYPE_NULLPARAMETER, out statusCode, out responseJson);
            }
            else
            {
                string password = StringHelper.StringToMD5(requestBody.userPwd);

                ModelAdo <UserModel> userModel = new ModelAdo <UserModel>();
                UserModel            model     = userModel.GetModel(" rid=?rid and name =?name", "",
                                                                    new MySqlParameter("?rid", requestBody.userType),
                                                                    new MySqlParameter("?name", requestBody.userName));
                if (model != null)
                {
                    SystemResponse.Output(SystemResponse.TYPE_EXIST, out statusCode, out responseJson);
                }
                else
                {
                    UserModel token = new UserModel();
                    token.rid      = Convert.ToInt32(requestBody.userType);
                    token.name     = requestBody.userName;
                    token.password = password;
                    token.ctime    = StringHelper.ConvertDateTimeInt(DateTime.Now);
                    if (userModel.Insert(token) >= 1)
                    {
                        responseJson = JsonConvert.SerializeObject(responseBody, Formatting.Indented);
                    }
                    else
                    {
                        SystemResponse.Output(SystemResponse.TYPE_REGISTER_ERROR, out statusCode, out responseJson);
                    }
                }
            }
        }
        public override void OnLoad(HttpContext context)
        {
            base.OnLoad(context);
            requestBody             = new RequestBody();
            requestBody.accessToken = context.Request["accessToken"];
            requestBody.oid         = context.Request["oid"];
            requestBody.action      = Convert.ToInt32(context.Request["action"]);
            requestBody.amount      = Convert.ToDecimal(context.Request["money"]);
            if (requestBody.accessToken == null || requestBody.accessToken.Trim().Length == 0 || requestBody.oid.Length == 0 || requestBody.action == 0)
            {
                SystemResponse.Output(SystemResponse.TYPE_NULLPARAMETER, out statusCode, out responseJson);
            }
            else if (requestBody.action == 2 && requestBody.amount == 0)
            {
                SystemResponse.Output(SystemResponse.TYPE_NULLPARAMETER, out statusCode, out responseJson);
            }
            else
            {
                //验证用户
                TokenHelper    token          = new TokenHelper();
                UserTokenModel userTokenModel = token.getUserToken(requestBody.accessToken);
                if (userTokenModel == null)
                {
                    SystemResponse.Output(SystemResponse.TYPE_EXPIRE, out statusCode, out responseJson);
                }
                else
                {
                    ModelAdo <OrderUserModel> modelAdo = new ModelAdo <OrderUserModel>();

                    //核对有没有供应商已抢单
                    OrderUserModel sendOrder = modelAdo.GetModel(" oid =?oid AND status=2", "",
                                                                 new MySqlParameter("?oid", requestBody.oid));
                    //核对供应商与订单状态
                    OrderUserModel model = modelAdo.GetModel("oid=?oid AND uid=?uid", "",
                                                             new MySqlParameter("?oid", requestBody.oid),
                                                             new MySqlParameter("?uid", userTokenModel.uid));
                    //数据是否存在派单中间表
                    if (model != null)
                    {
                        #region 供应商确认抢单【派单中间表已存在,并且订单状态为2,派单中】
                        if (2 == requestBody.action && sendOrder == null)
                        {
                            model.status     = 2;
                            model.amount     = requestBody.amount;
                            model.createTime = StringHelper.ConvertDateTimeInt(DateTime.Now);
                            model.remark     = "被供应商抢单的订单";

                            //修改订单状态为3,并录入相关抢单数据
                            ModelAdo <OrderModel> orderModelAdo = new ModelAdo <OrderModel>();
                            OrderModel            orderModel    = orderModelAdo.GetModel("id=?id", "",
                                                                                         new MySqlParameter("?id", requestBody.oid)
                                                                                         );
                            if (orderModel != null)
                            {
                                orderModel.ostatus    = 3;
                                orderModel.sendUid    = Convert.ToInt32(userTokenModel.uid);
                                orderModel.sendTime   = model.createTime;
                                orderModel.sendRemark = "供应商抢单并输入价格 【待处理订单】";
                                orderModel.sendAmount = model.amount;
                                if (orderModelAdo.Update(orderModel) >= 1)
                                {
                                    if (modelAdo.Update(model) >= 1)
                                    {
                                        SystemResponse.Output(SystemResponse.TYPE_OK, out statusCode, out responseJson);
                                    }
                                    else
                                    {
                                        SystemResponse.Output(SystemResponse.TYPE_ERROR, out statusCode, out responseJson);
                                    }
                                }
                            }
                            else
                            {
                                SystemResponse.Output(SystemResponse.TYPE_ERROR, out statusCode, out responseJson);
                            }
                        }
                        #endregion
                        #region 用户退回订单 【派单中间表已存在,并且订单状态为3,待处理订单】
                        else if (3 == requestBody.action && sendOrder != null && sendOrder.uid == Convert.ToInt32(userTokenModel.uid))
                        {
                            //修改订单状态为2,并清除相关抢单数据
                            ModelAdo <OrderModel> orderModelAdo = new ModelAdo <OrderModel>();
                            OrderModel            orderModel    = orderModelAdo.GetModel("id=?id", "",
                                                                                         new MySqlParameter("?id", requestBody.oid)
                                                                                         );
                            if (orderModel != null)
                            {
                                orderModel.ostatus    = 2;
                                orderModel.sendUid    = 0;
                                orderModel.sendTime   = 0;
                                orderModel.sendRemark = "供应商退回抢单【派单中】";
                                orderModel.sendAmount = 0;
                                if (orderModelAdo.Update(orderModel) >= 1)
                                {
                                    model.status = 3;
                                    model.remark = "被供应商退回的订单";
                                    modelAdo.Update(model);
                                    SystemResponse.Output(SystemResponse.TYPE_OK, out statusCode, out responseJson);
                                }
                                else
                                {
                                    SystemResponse.Output(SystemResponse.TYPE_NO_PERMISSON, out statusCode, out responseJson);
                                }
                            }
                            else
                            {
                                SystemResponse.Output(SystemResponse.TYPE_ERROR, out statusCode, out responseJson);
                            }
                        }
                        #endregion
                        #region 其他操作
                        else
                        {
                            SystemResponse.Output(SystemResponse.TYPE_NO_PERMISSON, out statusCode, out responseJson);
                        }
                        #endregion
                    }
                    else
                    {
                        SystemResponse.Output(SystemResponse.TYPE_NO_PERMISSON, out statusCode, out responseJson);
                    }
                }
            }
        }
Beispiel #9
0
        public override void OnLoad(HttpContext context)
        {
            base.OnLoad(context);
            requestBody             = new RequestBody();
            requestBody.accessToken = context.Request["accessToken"];
            requestBody.oid         = Convert.ToInt32(context.Request["oid"]);
            if (requestBody.accessToken == null || requestBody.accessToken.Trim().Length == 0 || requestBody.oid == 0)
            {
                SystemResponse.Output(SystemResponse.TYPE_NULLPARAMETER, out statusCode, out responseJson);
            }
            else
            {
                //验证用户
                TokenHelper    token          = new TokenHelper();
                UserTokenModel userTokenModel = token.getUserToken(requestBody.accessToken);
                if (userTokenModel == null)
                {
                    SystemResponse.Output(SystemResponse.TYPE_EXPIRE, out statusCode, out responseJson);
                }
                else
                {
                    ModelAdo <OrderModel> orderModel = new ModelAdo <OrderModel>();
                    OrderModel            model      = orderModel.GetModel("id=?id", "",
                                                                           new MySqlParameter("?id", requestBody.oid)
                                                                           );
                    if (model != null)
                    {
                        responseBody                = new ResponseBody();
                        responseBody.uid            = model.uid;
                        responseBody.title          = model.title;
                        responseBody.subtitle       = model.subtitle;
                        responseBody.createDate     = string.Format("{0:d}", StringHelper.GetNomalTime(model.createDate));
                        responseBody.status         = model.ostatus;
                        responseBody.no             = model.no;
                        responseBody.price          = model.amount.ToString("f2");
                        responseBody.contact        = model.contact;
                        responseBody.contactAddress = model.contactAdress;
                        responseBody.contactOPhone  = model.contactOPhone;
                        responseBody.contactPhone   = model.contactPhone;
                        responseBody.payment        = model.payment;
                        responseBody.type           = model.otid;
                        responseBody.remark         = model.remark;
                        Ext from = new Ext();
                        from.uid          = model.uid;
                        from.city         = model.address1;
                        from.date         = string.Format("{0:d}", StringHelper.GetNomalTime(model.time1));
                        responseBody.from = from;

                        Ext to = new Ext();
                        to.uid          = model.uid;
                        to.city         = model.address2;
                        to.date         = string.Format("{0:d}", StringHelper.GetNomalTime(model.time2));
                        responseBody.to = to;

                        if (model.ostatus == 3)
                        {
                            Send send = new Send();
                            send.date         = string.Format("{0:d}", StringHelper.GetNomalTime(model.sendTime));
                            send.suid         = model.sendUid;
                            send.price        = model.sendAmount.ToString("f2");
                            send.remark       = model.sendRemark;
                            responseBody.send = send;
                        }
                        responseJson = JsonConvert.SerializeObject(responseBody, Formatting.Indented);
                    }
                    else
                    {
                        SystemResponse.Output(SystemResponse.TYPE_NULL, out statusCode, out responseJson);
                    }
                }
            }
        }
        public override void OnLoad(HttpContext context)
        {
            base.OnLoad(context);
            requestBody             = new RequestBody();
            requestBody.accessToken = context.Request["accessToken"];
            requestBody.oid         = context.Request["oid"];
            requestBody.action      = Convert.ToInt32(context.Request["action"]);
            if (requestBody.accessToken == null || requestBody.accessToken.Trim().Length == 0 || requestBody.oid.Length == 0 || requestBody.action == 0)
            {
                SystemResponse.Output(SystemResponse.TYPE_NULLPARAMETER, out statusCode, out responseJson);
            }
            else
            {
                //验证用户
                TokenHelper    token          = new TokenHelper();
                UserTokenModel userTokenModel = token.getUserToken(requestBody.accessToken);
                if (userTokenModel == null)
                {
                    SystemResponse.Output(SystemResponse.TYPE_EXPIRE, out statusCode, out responseJson);
                }
                else
                {
                    #region 客服取消供应商抢单数据、修改订单状态回派单中
                    if (requestBody.action == 2)
                    {
                        //获取当前订单信息
                        ModelAdo <OrderModel> modelAdo = new ModelAdo <OrderModel>();
                        OrderModel            order    = modelAdo.GetModel("id=?oid AND ostatus=?ostatus", "",
                                                                           new MySqlParameter("?oid", requestBody.oid),
                                                                           new MySqlParameter("?ostatus", 3));
                        if (order != null)
                        {
                            //获取派单供应商对应订单中间表数据
                            ModelAdo <OrderUserModel> ouModelAdo = new ModelAdo <OrderUserModel>();
                            OrderUserModel            orderUser  = ouModelAdo.GetModel("oid=?oid AND uid=?uid", "",
                                                                                       new MySqlParameter("?oid", requestBody.oid),
                                                                                       new MySqlParameter("?uid", order.sendUid));
                            orderUser.amount     = 0;
                            orderUser.remark     = "被供应商退回抢单数据";
                            orderUser.createTime = 0;
                            orderUser.status     = 1;
                            if (ouModelAdo.Update(orderUser) >= 1)
                            {
                                order.ostatus    = 2;
                                order.sendUid    = 0;
                                order.sendTime   = 0;
                                order.sendRemark = "被供应商退回抢单数据";
                                order.sendAmount = 0;
                                if (modelAdo.Update(order) >= 1)
                                {
                                    SystemResponse.Output(SystemResponse.TYPE_OK, out statusCode, out responseJson);
                                }
                                else
                                {
                                    SystemResponse.Output(SystemResponse.TYPE_NULL, out statusCode, out responseJson);
                                }
                            }
                        }
                        else
                        {
                            SystemResponse.Output(SystemResponse.TYPE_NULL, out statusCode, out responseJson);
                        }
                    }
                    #endregion

                    #region 客服确认供应商抢单数据
                    else if (requestBody.action == 4)
                    {
                        //获取当前订单信息
                        ModelAdo <OrderModel> modelAdo = new ModelAdo <OrderModel>();
                        OrderModel            order    = modelAdo.GetModel("id=?oid AND ostatus=?ostatus", "",
                                                                           new MySqlParameter("?oid", requestBody.oid),
                                                                           new MySqlParameter("?ostatus", 3));
                        order.ostatus    = 4;
                        order.sendRemark = "客服确认供应商抢单数据";
                        if (order != null)
                        {
                            if (modelAdo.Update(order) >= 1)
                            {
                                //删除派单供应商对应订单中间表数据
                                ModelAdo <OrderUserModel> ouModelAdo = new ModelAdo <OrderUserModel>();
                                int delCount = ouModelAdo.ExecuteSql("DELETE FROM ct_order_user WHERE oid=?oid",
                                                                     new MySqlParameter("?oid", requestBody.oid));
                                if (delCount >= 1)
                                {
                                    SystemResponse.Output(SystemResponse.TYPE_OK, out statusCode, out responseJson);
                                }
                                else
                                {
                                    SystemResponse.Output(SystemResponse.TYPE_NULL, out statusCode, out responseJson);
                                }
                            }
                        }
                        else
                        {
                            SystemResponse.Output(SystemResponse.TYPE_NULL, out statusCode, out responseJson);
                        }
                    }
                    #endregion

                    #region 客服确认关闭已确认数据
                    else if (requestBody.action == 5)
                    {
                        //获取当前订单信息
                        ModelAdo <OrderModel> closeModelAdo = new ModelAdo <OrderModel>();
                        OrderModel            closeOrder    = closeModelAdo.GetModel("id=?oid AND ostatus=?ostatus", "",
                                                                                     new MySqlParameter("?oid", requestBody.oid),
                                                                                     new MySqlParameter("?ostatus", 4));
                        closeOrder.ostatus    = 5;
                        closeOrder.sendRemark = "客服确认完成订单数据";
                        if (closeOrder != null)
                        {
                            if (closeModelAdo.Update(closeOrder) >= 1)
                            {
                                SystemResponse.Output(SystemResponse.TYPE_OK, out statusCode, out responseJson);

                                //删除派单供应商对应订单中间表数据
                                ModelAdo <OrderUserModel> ouModelAdo = new ModelAdo <OrderUserModel>();
                                int delCount = ouModelAdo.ExecuteSql("DELETE FROM ct_order_user WHERE oid=?oid",
                                                                     new MySqlParameter("?oid", requestBody.oid));
                                //if (delCount >= 1)
                                //{
                                //}
                                //else
                                //{
                                //}
                            }
                            else
                            {
                                SystemResponse.Output(SystemResponse.TYPE_NULL, out statusCode, out responseJson);
                            }
                        }
                        else
                        {
                            SystemResponse.Output(SystemResponse.TYPE_NULL, out statusCode, out responseJson);
                        }
                    }
                    #endregion

                    #region 其他
                    else
                    {
                        SystemResponse.Output(SystemResponse.TYPE_NULLPARAMETER, out statusCode, out responseJson);
                    }
                    #endregion
                }
            }
        }
Beispiel #11
0
        public override BaseSearchModel Insert()
        {
            ModelAdo<WOModel> adoWO = new ModelAdo<WOModel>();
            WOModel modelWO = adoWO.GetModel("MP64001=@wo", "", new SqlParameter("@wo", this.Workorder));
            if (modelWO != null)
            {
                ModelAdo<ReportModel> adoReport = new ModelAdo<ReportModel>();
                List<ReportModel> list = adoReport.GetList("WK02002=@wo", "WK02001", "", new SqlParameter("@wo", this.Workorder));
                if (list.Count == 0)
                {
                    ModelAdo<WOWK01Model> adoWK01 = new ModelAdo<WOWK01Model>();
                    WOWK01Model wk01 = new WOWK01Model()
                    {
                        WorkOrder=modelWO.WorkOrder,
                        StockCode=modelWO.StockCode,
                        StockName=modelWO.StockName,
                        QTY=modelWO.PlanQTY,
                        Status=1,
                        TotalHour=0
                    };
                    adoWK01.Insert(wk01);

                    ModelAdo<WOLineNoGroupModel> adoWOLine = new ModelAdo<WOLineNoGroupModel>();
                    List<WOLineNoGroupModel> wolineList = adoWOLine.GetList("MP65001=@wo", "MP65003", "", new SqlParameter("@wo", this.Workorder));
                    int i = 0;
                    string op = "";
                    foreach (WOLineNoGroupModel item in wolineList)
                    {
                        if (op != item.OperationNO)
                            i = 0;
                        i++;
                        ReportModel modelReport = new ReportModel()
                        {
                            BOMOP = item.OperationNO,
                            BOMOPINDEX = i + "",
                            DeQTY = item.PlanQTY,
                            HadDe = 0,
                            HadDeQTY = 0,
                            StockCode = item.StockCode,
                            StockName = item.StockName,
                            Workorder = item.WO,
                            LineNumber = item.Number,
                            ReportNumber = item.ReportNumber,
                            DeDate = System.DateTime.Now,
                            Warehouse=item.Warehouse
                        };
                        adoReport.Insert(modelReport);
                    }
                }
                //                if (!string.IsNullOrEmpty(this.RWID))
                //                {
                //                    ModelAdo<RWBarcodeModel> adoRW = new ModelAdo<RWBarcodeModel>();
                //                    RWBarcodeModel rwModel = adoRW.GetModelByID(this.RWID);
                //                    if (rwModel != null)
                //                    {
                //                        if (this.DeQTY > (float)rwModel.StockUnitQty)
                //                            throw new Exception("汇报数量超出条码数量");

                //                        string sql = @"
                //update RW01 set RW01006=RW01006-@deqty where RW01001=@bid
                //
                //insert into RW02(RW02002,RW02003,RW02004,RW02005,RW02010,RW02011)
                //select RW01001,getdate(),@userid,@username,@dj,N'扣料 工单号'+@wo+' 数量'+convert(varchar(10),@deqty) from RW01 where RW01001=@bid
                //
                //update WK02 set WK02002=
                //";
                //                    }
                //                    else
                //                        throw new Exception("无效原材料条码");
                //                }
                list = adoReport.GetList("WK02002=@wo", "WK02001", "", new SqlParameter("@wo", this.Workorder));
                this.ReturnReportList = list;
                return this;
            }
            else
                throw new Exception("无效工单,请重新确认工单");
        }
        public override void OnLoad(HttpContext context)
        {
            base.OnLoad(context);
            requestBody             = new RequestBody();
            requestBody.accessToken = context.Request["accessToken"];
            requestBody.uTo         = Convert.ToInt32(context.Request["to"]);
            requestBody.content     = context.Request["content"];

            if (requestBody.content.Length == 0 || requestBody.accessToken.Trim().Length == 0 || requestBody.uTo == 0)
            {
                SystemResponse.Output(SystemResponse.TYPE_NULLPARAMETER, out statusCode, out responseJson);
            }
            else
            {
                //验证用户
                TokenHelper    token     = new TokenHelper();
                UserTokenModel fromModel = token.getUserToken(requestBody.accessToken);
                UserTokenModel toModel   = token.getUserToken(requestBody.uTo);
                if (fromModel == null)
                {
                    SystemResponse.Output(SystemResponse.TYPE_EXPIRE, out statusCode, out responseJson);
                }
                else
                {
                    int msgstatus = 0;

                    #region 入库至本地
                    ModelAdo <MsgModel> modelAdo = new ModelAdo <MsgModel>();
                    MsgModel            msg      = new MsgModel();
                    msg.ufrom      = Convert.ToInt32(fromModel.uid);
                    msg.uto        = requestBody.uTo;
                    msg.content    = requestBody.content;
                    msg.createTime = StringHelper.ConvertDateTimeInt(DateTime.Now);
                    msg.status     = msgstatus;
                    if (modelAdo.Insert(msg) >= 1)
                    {
                        #region 百度推送
                        if (toModel != null && toModel.bpuserId.Length >= 1 && toModel.channelId.Length >= 1)
                        {
                            //获取插入本地数据
                            MsgModel msgPush = modelAdo.GetModel("ufrom=?ufrom AND uto=?uto AND createTime=?createTime AND status=0", "",
                                                                 new MySqlParameter("?ufrom", msg.ufrom),
                                                                 new MySqlParameter("?uto", msg.uto),
                                                                 new MySqlParameter("?createTime", msg.createTime));
                            if (msgPush != null)
                            {
                                try
                                {
                                    //百度配置信息
                                    string secretKey    = ConfigurationManager.AppSettings["baidu_secret_key"];
                                    string apiKey       = ConfigurationManager.AppSettings["baidu_api_key"];
                                    uint   depolyStatus = uint.Parse(ConfigurationManager.AppSettings["baidu_depoly_status"]);

                                    String    messages     = "";
                                    TimeSpan  ts           = (DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0));
                                    uint      unixTime     = (uint)ts.TotalSeconds;
                                    string    messageksy   = "api";
                                    uint      message_type = 1;
                                    BaiduPush Bpush        = new BaiduPush("POST", secretKey);



                                    if (toModel.deviceType == 1)
                                    {
                                        message_type       = 1;
                                        toModel.deviceType = 4;
                                        IOSNotification notifaction = new IOSNotification();
                                        notifaction.id         = msgPush.id;
                                        notifaction.ufrom      = msgPush.ufrom;
                                        notifaction.uto        = msgPush.uto;
                                        notifaction.content    = msgPush.content.Trim();
                                        notifaction.createTime = string.Format("{0:yyyy/MM/dd HH:mm:ss}", System.DateTime.Now);
                                        notifaction.type       = msgPush.type;
                                        notifaction.status     = 1;
                                        IOSAPS aps = new IOSAPS()
                                        {
                                            alert = "收到一条新消息",
                                        };
                                        notifaction.aps = aps;
                                        messages        = notifaction.getJsonString();
                                    }
                                    else
                                    {
                                        message_type       = 0;
                                        toModel.deviceType = 3;
                                        BaiduPushNotification notifaction = new BaiduPushNotification();
                                        notifaction.title = "";
                                        //构建custom_content信息
                                        BaiduDescription bdMsg = new BaiduDescription();
                                        bdMsg.id                   = msgPush.id;
                                        bdMsg.ufrom                = msgPush.ufrom;
                                        bdMsg.uto                  = msgPush.uto;
                                        bdMsg.content              = msgPush.content;
                                        bdMsg.createTime           = string.Format("{0:yyyy/MM/dd HH:mm:ss}", System.DateTime.Now);
                                        bdMsg.type                 = msgPush.type;
                                        bdMsg.status               = 1;
                                        notifaction.description    = "收到一条新消息";
                                        notifaction.custom_content = bdMsg;
                                        messages                   = notifaction.getJsonString();
                                    }



                                    PushOptions pOpts = new PushOptions("push_msg", apiKey, toModel.bpuserId.ToString(),
                                                                        toModel.channelId.ToString(), Convert.ToUInt32(toModel.deviceType), messages, messageksy, unixTime);
                                    pOpts.message_type  = message_type;
                                    pOpts.deploy_status = depolyStatus;
                                    pOpts.push_type     = 1;
                                    string response = Bpush.PushMessage(pOpts);
                                    responseJson = response;
                                    msgstatus    = 1;

                                    //处理数据为已读
                                    if (msg.status == 0)
                                    {
                                        msgPush.status = 1;
                                        modelAdo.Update(msgPush);
                                    }

                                    //SystemResponse.Output(SystemResponse.TYPE_OK, out statusCode, out responseJson);
                                    //responseJson = strBDMsg;
                                }
                                catch (Exception ex)
                                {
                                    responseJson = ex.ToString();
                                    SystemResponse.Output(SystemResponse.TYPE_ERROR, out statusCode, out responseJson);
                                }
                            }
                            #endregion
                        }
                        else
                        {
                            SystemResponse.Output(SystemResponse.TYPE_ERROR, out statusCode, out responseJson);
                        }
                        #endregion
                    }
                }
            }
        }
        public override void OnLoad(HttpContext context)
        {
            base.OnLoad(context);
            requestBody             = new RequestBody();
            requestBody.accessToken = context.Request["accessToken"];
            requestBody.oid         = context.Request["oid"];
            requestBody.uid         = context.Request["uid"];
            if (requestBody.accessToken == null || requestBody.accessToken.Trim().Length == 0 || requestBody.oid.Length == 0 || requestBody.uid.Length == 0)
            {
                SystemResponse.Output(SystemResponse.TYPE_NULLPARAMETER, out statusCode, out responseJson);
            }
            else
            {
                List <int> values = JsonConvert.DeserializeObject <List <int> >(requestBody.uid);

                //验证用户
                TokenHelper    token          = new TokenHelper();
                UserTokenModel userTokenModel = token.getUserToken(requestBody.accessToken);
                if (userTokenModel == null)
                {
                    SystemResponse.Output(SystemResponse.TYPE_EXPIRE, out statusCode, out responseJson);
                }
                else
                {
                    //获取订单表数据
                    ModelAdo <OrderModel> modelAdoOrder = new ModelAdo <OrderModel>();
                    OrderModel            orderModel    = modelAdoOrder.GetModel("(id=?id AND ostatus=?ostatus) or (id=?id AND ostatus=?ostatus1) ", "",
                                                                                 new MySqlParameter("?id", requestBody.oid),
                                                                                 new MySqlParameter("?ostatus", 2),
                                                                                 new MySqlParameter("?ostatus1", 1));

                    if (orderModel != null)
                    {
                        ModelAdo <OrderUserModel> modelAdo = new ModelAdo <OrderUserModel>();
                        int existCount = modelAdo.GetRecordCount("oid=?oid",
                                                                 new MySqlParameter("?oid", requestBody.oid));
                        if (existCount >= 1)
                        {
                            int delCount = modelAdo.ExecuteSql("DELETE FROM ct_order_user WHERE oid=?oid",
                                                               new MySqlParameter("?oid", requestBody.oid));
                            if (delCount >= 1)
                            {
                                StringBuilder sbValues = new StringBuilder();
                                sbValues.Append(" INSERT INTO ct_order_user(oid,uid,status,remark) VALUES ");
                                for (int i = 0; i < values.Count; i++)
                                {
                                    sbValues.Append("(" + requestBody.oid + "," + values[i] + ",1,'派送中的订单'),");
                                }
                                sbValues.Remove(sbValues.Length - 1, 1).Append(";");
                                int inCount = modelAdo.ExecuteSql(sbValues.ToString());
                                if (inCount >= 1)
                                {
                                    if (orderModel != null)
                                    {
                                        orderModel.ostatus = 2;
                                        modelAdoOrder.Update(orderModel);
                                    }
                                    SystemResponse.Output(SystemResponse.TYPE_OK, out statusCode, out responseJson);
                                }
                                else
                                {
                                    SystemResponse.Output(SystemResponse.TYPE_NULL, out statusCode, out responseJson);
                                }
                            }
                            else
                            {
                                SystemResponse.Output(SystemResponse.TYPE_ERROR, out statusCode, out responseJson);
                            }
                        }
                        else
                        {
                            StringBuilder sbValues = new StringBuilder();
                            sbValues.Append(" INSERT INTO ct_order_user(oid,uid,status) VALUES ");
                            for (int i = 0; i < values.Count; i++)
                            {
                                sbValues.Append("(" + requestBody.oid + "," + values[i] + ",1),");
                            }
                            sbValues.Remove(sbValues.Length - 1, 1).Append(";");
                            int inCount = modelAdo.ExecuteSql(sbValues.ToString());
                            if (inCount >= 1)
                            {
                                SystemResponse.Output(SystemResponse.TYPE_OK, out statusCode, out responseJson);
                            }
                            else
                            {
                                SystemResponse.Output(SystemResponse.TYPE_NULL, out statusCode, out responseJson);
                            }
                        }
                    }
                    else
                    {
                        SystemResponse.Output(SystemResponse.TYPE_NULL, out statusCode, out responseJson);
                    }
                }
            }
        }