/// <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); }
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(); }
/// <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); } } }
/// <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); }
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); } } } }
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 } } }
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); } } } }