/// <summary> ///新增黑白名单 /// </summary> /// <param name="requesPayCheck"></param> /// <returns></returns> public APIResultBase GetBackWhiteCarInfo(NanFangUnionModel carInfo) { APIResultBase <NanFangUnionModel> apiBaseResult = new APIResultBase <NanFangUnionModel>(); apiBaseResult.code = "0"; apiBaseResult.msg = ""; BlackWhiteListModel blackWhiteModel = new BlackWhiteListModel(); blackWhiteModel.PlateNumber = carInfo.PlatNumber; blackWhiteModel.BlackWhiteType = 3; blackWhiteModel.StartDate = carInfo.StartTime; blackWhiteModel.EndDate = carInfo.EndTime; if (carInfo.CheckoutFlag == "0") { blackWhiteModel.Reason = "在场"; } else { blackWhiteModel.Reason = "离场"; } blackWhiteModel.Remark = carInfo.RoomNo; JielinkApi jieLinApi = new JielinkApi(); APIResultBase <BlackWhiteListModel> result = jieLinApi.AddBackWhiteList(blackWhiteModel); if (result.code != "0") { apiBaseResult.code = "1"; apiBaseResult.msg = "失败!"; } return(apiBaseResult); }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { string id = GridView1.DataKeys[e.RowIndex].Value.ToString(); string roomID = ((TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text.ToString().Trim(); string carPlateNumber = ((TextBox)GridView1.Rows[e.RowIndex].Cells[4].Controls[0]).Text.ToString().Trim(); string starTime = ((TextBox)GridView1.Rows[e.RowIndex].Cells[5].Controls[0]).Text.ToString().Trim(); string endTime = ((TextBox)GridView1.Rows[e.RowIndex].Cells[6].Controls[0]).Text.ToString().Trim(); string remark = ((TextBox)GridView1.Rows[e.RowIndex].Cells[7].Controls[0]).Text.ToString().Trim(); //向JieLink+平台发送 BlackWhiteListModel blackWhiteCar = new BlackWhiteListModel(); blackWhiteCar.PlateNumber = carPlateNumber; blackWhiteCar.BlackWhiteType = 3; blackWhiteCar.StartDate = starTime; blackWhiteCar.EndDate = endTime; blackWhiteCar.Reason = ""; blackWhiteCar.Remark = remark; JielinkApi jieLinApi = new JielinkApi(); APIResultBase <BlackWhiteListModel> result = jieLinApi.AddBackWhiteList(blackWhiteCar); if (result.code == "0") { string strUpdate = "update tb_cars set RoomID='" + roomID + "',CarPlateNumber='" + carPlateNumber + "',StarTime='" + starTime + "',EndTime='" + endTime + "',Remark='" + remark + "' where ID=" + id; //连接数据库,执行更新语句 MySqlConnection con = new MySqlConnection(connectionString); MySqlCommand cmd = new MySqlCommand(strUpdate, con); try { con.Open(); cmd.ExecuteNonQuery(); this.lbResult.Text = "更新记录成功!"; } catch (Exception ex) { } finally { con.Close(); } } else { this.lbResult.Text = "更新失败!"; } GridView1.EditIndex = -1; Bind(txtRoomID.Text.Trim()); }
/// <summary> /// 添加黑白名单 /// </summary> /// <param name="requestdata"></param> /// <returns></returns> public APIResultBase <BlackWhiteListModel> AddBackWhiteList(BlackWhiteListModel requestdata) { ApiResult <APIResultBase <BlackWhiteListModel> > result = proxyApi.PostRaw <APIResultBase <BlackWhiteListModel> >("park/addblackwhitelist", requestdata); if (result.successed) { if (result.data.code != "0") { LogHelper.Info("增加黑白名单失败," + result.data.msg); } } else { LogHelper.Info("增加黑白名单失败," + result.message); } return(result.data); }
protected void btnAddCar_Click(object sender, EventArgs e) { string strRoomID = txtRoomID.Text; string strPlateNumber = txtPlateNumber.Text; string strStarTime = Request["starTime"].ToString(); string strEndTime = Request["endTime"].ToString(); string strRemark = txtRemark.Text; if (string.IsNullOrEmpty(strStarTime)) { this.lbTips.Text = "请填入住时间!"; return; } if (string.IsNullOrEmpty(strEndTime)) { this.lbTips.Text = "请填写结束时间!"; return; } //向JieLink+平台发送 BlackWhiteListModel blackWhiteCar = new BlackWhiteListModel(); blackWhiteCar.PlateNumber = strPlateNumber; blackWhiteCar.BlackWhiteType = 3; blackWhiteCar.StartDate = strStarTime; blackWhiteCar.EndDate = strEndTime; blackWhiteCar.Reason = ""; blackWhiteCar.Remark = strRemark; JielinkApi jieLinApi = new JielinkApi(); APIResultBase <BlackWhiteListModel> result = jieLinApi.AddBackWhiteList(blackWhiteCar); if (result.code == "0") { //下发成功,则插入记录到数据库 MySqlConnection con = new MySqlConnection(connectionString); string strCmd = "insert into tb_cars(RoomID,CarPlateNumber,StarTime,EndTime,Remark) values('" + strRoomID + "','" + strPlateNumber + "','" + strStarTime + "','" + strEndTime + "','" + strRemark + "');"; try { MySqlCommand cmd = new MySqlCommand(strCmd, con); con.Open(); cmd.ExecuteNonQuery(); Bind(); //重新绑定数据,就可以查看刚插入的记录了 //清空Panel中TextBox控件内容 foreach (Control c in Panel1.Controls) { if (c is TextBox) { (c as TextBox).Text = ""; } } } catch (Exception ex) { } finally { con.Close(); } } else { lbTips.Text = "下发信息失败!"; } }