public override int Update(BaseSearchModel model) { try { foreach (RWBarcodeModel item in RWBarcodeModels) { //修改条码信息 ModelAdo<RWBarcodeModel> adoBarcode = new ModelAdo<RWBarcodeModel>(); item.Status = Status; adoBarcode.Update(item); //添加条码历史记录 ModelAdo<RWHistoryModel> adoBarcodeHistroy = new ModelAdo<RWHistoryModel>(); RWHistoryModel historyModel = new RWHistoryModel() { CreateTime = DateTime.Now, BillID = "", BarcodeID = item.ID, Remark = Remark }; adoBarcodeHistroy.Insert(historyModel); } } catch (Exception) { return 0; } return 1; }
public override BaseSearchModel Insert() { using (TransactionScope ts = new TransactionScope()) { //修改条码中对应装箱ID信息 ModelAdo<RWBarcodeModel> apiBarcode = new ModelAdo<RWBarcodeModel>(); //添加历史记录 ModelAdo<RWHistoryModel> adoBarcodeHistroy = new ModelAdo<RWHistoryModel>(); foreach (RWBarcodeModel item in RWBarcodeModels) { item.BoxID = packingModel.ID; apiBarcode.Update(item); //创建条码历史记录【Add】 RWHistoryModel historyModel = new RWHistoryModel() { CreateTime = DateTime.Now, BillID = "", BarcodeID = item.ID, Remark = Remark }; adoBarcodeHistroy.Insert(historyModel); } //修改barcode的条码状态 ModelAdo<PackingModel> apiPacking = new ModelAdo<PackingModel>(); packingModel.Status = 2; apiPacking.Update(packingModel); ts.Complete(); } return this; }
/// <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 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 BaseSearchModel Insert() { if (Count >= 1) { ModelAdo<PackingModel> modelAdo = new ModelAdo<PackingModel>(); string[] strs = new string[Count]; List<PackingModel> list = new List<PackingModel>(); for (int i = 0; i < Count; i++) { PackingModel pm = this.MemberwiseClone() as PackingModel; pm.CreateTime = DateTime.Now; pm.Status = 1; strs[i] = pm.ID; modelAdo.Insert(pm); list.Add(pm); } this.PackingModels = list.ToArray() ; this.ReturnID = strs; } return this; }
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 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 } } } }