/// <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 = "下发信息失败！";
}
}
