public string ClearPasswordToLock(string aarId)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
RentAttribute a = new RentAttribute(int.Parse(aarId));
DataTable dt = MySQLHelper.ExecuteDataset(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand("select * from Rent_Locks where rentno='" + a.RentNo + "'")).Tables[0];
string lockID = dt.Rows.Count.ToString();
string a1 = a.RRAStartDate.ToString("yyyy-MM-dd HH:mm:ss");
string a2 = a.RRAEndDate.ToString("yyyy-MM-dd HH:mm:ss");
////LockID='" + dt.Rows[0]["DeviceID"].ToString() + "' and StartDate='" + a1 + "' and EndDate='" + a2 + "'
//string sql = "select * from Rent_Locks_ICCards where LockID='" + dt.Rows[0]["DeviceID"].ToString() + "' and StartDate='" + a.RRAStartDate.ToString("yyyy-MM-dd HH:mm:ss") + "' and EndDate='" + a.RRAEndDate.ToString("yyyy-MM-dd HH:mm:ss") + "'";
string sql = "select * from Rent_Locks_ICCards where LockID='" + lockID + "'";
LockManager manager = new LockManager();
DataTable dt1 = MySQLHelper.ExecuteDataset(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql)).Tables[0];
foreach (DataRow row in dt1.Rows)
{
string returnStr = manager.UpdatePassengerInfoToDevice(dt.Rows[0]["DeviceID"].ToString(), row["ICCard"].ToString(), "", "", "", a.RRAStartDate.ToString("yyyyMMddHHmm").Substring(2, 10), a.RRAEndDate.ToString("yyyyMMddHHmm").Substring(2, 10), "2");
}
if (dt.Rows.Count > 0)
{
string returnStr = manager.UpdatePassengerInfoToDevice(dt.Rows[0]["DeviceID"].ToString(), "", "", "", a.RRANationName, a.RRAStartDate.ToString("yyyyMMddHHmm").Substring(2, 10), a.RRAEndDate.ToString("yyyyMMddHHmm").Substring(2, 10), "4");
dic.Add("ret", "0");
dic.Add("msg", returnStr);
}
else
{
dic.Add("ret", "1");
dic.Add("msg", "未发现智能锁信息，无法添加密码");
}
return(JSONHelper.ToJson(dic));
}
protected void btnDelete_Click(object sender, EventArgs e)
{
RentAttributeHelper rentAttributeHelper = new RentAttributeHelper();
RentAttribute rentAttribute = new RentAttribute(int.Parse(RRAID));
rentAttribute.RRAModifiedBy = SysContext.CurrentUserName;
rentAttribute.RRAModifiedDate = System.DateTime.Now;
rentAttribute.RRAIsActive = true;
rentAttributeHelper.DeleteRentAttribute(rentAttribute);
ScriptManager.RegisterStartupScript(btnSave, GetType(), "warning", "javascript:DeleteDialog('" + rentAttribute.RentNo + "');", true);
}
protected void InitialControls()
{
RentAttributeHelper rentAttributeHelper = new RentAttributeHelper();
lblRentNo.Text = RentNo;
RentInfo rentInfo = new RentInfo(RentNo);
if (!string.IsNullOrEmpty(RRAID))
{
RentAttribute rra = new RentAttribute(int.Parse(RRAID));
lblAddress.Text = rentInfo.RAddress;
lblCreatedBy.Text = rra.RRACreatedBy;
lblCreatedDate.Text = rra.RRACreatedDate.ToString();
txtRentPrice.Text = rra.RRentPrice.ToString();
txtStartDate.Text = rra.RRAStartDate.ToString("yyyy-MM-dd");
txtEndDate.Text = rra.RRAEndDate.ToString("yyyy-MM-dd");
txtContactName.Text = rra.RRAContactName;
txtContactTel.Text = rra.RRAContactTel;
txtIDCard.Text = rra.RRAIDCard;
txtPassword.Text = rra.RRANationName;
dlRenties.DataSource = rentAttributeHelper.GetRetinues(RRAID);
dlRenties.DataBind();
btnDelete.Visible = true;
btnSave.Visible = false;
imgAdd.Visible = false;
imgCard.Visible = false;
btnStart.Visible = false;
btnEnd.Visible = false;
}
else
{
lblCreatedBy.Text = SysContext.CurrentUserName;
lblCreatedByName.Text = SysContext.CurrentRealName;
lblCreatedDate.Text = System.DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
lblAddress.Text = rentInfo.RAddress;
txtRentPrice.Text = rentInfo.RLocationDescription;
txtStartDate.Text = Request["startDate"];
txtEndDate.Text = DateTime.Parse(txtStartDate.Text).AddDays(4).ToString("yyyy-MM-dd");
txtEndDate.Text = Request["endDate"];
if (dtRenties.Columns.Count <= 0)
{
dtRenties.Columns.Add("Name");
dtRenties.Columns.Add("IDCard");
}
}
}
protected void InitialControls()
{
RentAttributeHelper rentAttributeHelper = new RentAttributeHelper();
DataBindProvince();
DataBindNationName();
if (EditType == "D")
{
RentAttribute rentAttribute = new RentAttribute(int.Parse(RentNo));
lblRentNo.Text = rentAttribute.RentNo;
RentInfo rentInfo = new RentInfo(rentAttribute.RentNo);
txtContactName.Text = rentAttribute.RRAContactName;
txtIDCard.Text = rentAttribute.RRAIDCard;
txtContactTel.Text = rentAttribute.RRAContactTel;
txtRentPrice.Text = rentAttribute.RRentPrice.ToString();
ddlContactProvince.SelectedIndex = ddlContactProvince.Items.IndexOf(ddlContactProvince.Items.FindByText(rentAttribute.RRAContactProvince));
ddlNationName.SelectedIndex = ddlNationName.Items.IndexOf(ddlNationName.Items.FindByText(rentAttribute.RRANationName));
txtStartDate.Text = rentAttribute.RRAStartDate.ToString("yyyy-MM-dd");
txtEndDate.Text = rentAttribute.RRAEndDate.ToString("yyyy-MM-dd");
txtDescription.Text = rentAttribute.RRADescription;
lblCreatedBy.Text = rentAttribute.RRACreatedBy;
RentInfoHelper helper = new RentInfoHelper();
DataTable dtUser = helper.GetDataTable("select * from cf_user where loginName='" + lblCreatedBy.Text + "'");
foreach (DataRow row in dtUser.Rows)
{
lblCreatedByName.Text = row["RealName"].ToString();
}
lblCreatedDate.Text = rentAttribute.RRACreatedDate.ToString("yyyy-MM-dd hh:mm:ss");
btnStart.Visible = false;
btnEnd.Visible = false;
btnSave.Visible = false;
}
else
{
//获取租房者信息
RentAttribute rentAttribute = new RentAttribute(int.Parse(RentNo));
lblRentNo.Text = rentAttribute.RentNo;
RentInfo rentInfo = new RentInfo(rentAttribute.RentNo);
txtContactName.Text = rentAttribute.RRAContactName; //承租人姓名
txtIDCard.Text = rentAttribute.RRAIDCard; //身份证号ID
txtContactTel.Text = rentAttribute.RRAContactTel; //承租人联系电话
txtRentPrice.Text = rentAttribute.RRentPrice.ToString(); //租赁价格
ddlContactProvince.SelectedIndex = ddlContactProvince.Items.IndexOf(ddlContactProvince.Items.FindByText(rentAttribute.RRAContactProvince)); //获取所属省份
ddlNationName.SelectedIndex = ddlNationName.Items.IndexOf(ddlNationName.Items.FindByText(rentAttribute.RRANationName)); //获取所属国籍
txtStartDate.Text = rentAttribute.RRAStartDate.ToString("yyyy-MM-dd"); //租赁起始时间
txtEndDate.Text = rentAttribute.RRAEndDate.ToString("yyyy-MM-dd"); //租赁结束时间
txtDescription.Text = rentAttribute.RRADescription; //备注
lblCreatedBy.Text = rentAttribute.RRACreatedBy;
RentInfoHelper helper = new RentInfoHelper();
DataTable dtUser = helper.GetDataTable("select * from cf_user where loginName='" + lblCreatedBy.Text + "'");
foreach (DataRow row in dtUser.Rows)
{
lblCreatedByName.Text = row["RealName"].ToString(); //创建人
}
lblCreatedDate.Text = rentAttribute.RRACreatedDate.ToString("yyyy-MM-dd hh:mm:ss"); //创建时间
if (EditType == "A")
{
lblRentStatus.Text = "此房源已出租";
btnSave.Visible = false;
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
RentInfo rentInfo = new RentInfo(RentNo);
//租户身份扫描
//string url = ConfigurationManager.AppSettings["CertificateUrl"];
//string data = "{" +
// "\"AppID\":\"0000004\"," +
// "\"FunID\":\"000\"," +
// "\"OrderID\":\""+Guid.NewGuid().ToString().Replace("-","").Substring(0,30)+"\"," +
// "\"HouseID\":\""+RentNo+"\"," +
// "\"LessorID\":\""+rentInfo.RIDCard+"\"," +
// "\"LessorName\":\""+rentInfo.ROwner+"\"," +
// "\"LesseeID\":\""+txtIDCard.Text+"\"," +
// "\"LesseeName\":\""+txtContactName.Text+"\"," +
// "\"Rent\":\""+txtRentPrice.Text+"\"," +
// "\"RentType\":\""+rentInfo.RentType+"\"," +
// "\"StartTime\":\""+txtStartDate.Text+"\"," +
// "\"EndTime\":\""+txtEndDate.Text+"\"," +
// "\"AgentFlag\":\"0\"," +
// "\"AgentID\":\"\"," +
// "\"AgentName\":\"\"" +
// "}";
//string ret = LigerRM.Common.WebRequestHelper.WebRequestPoster.Post(url, data);
////{'ret':'1','desc':'SDT-HOUSE-3836333933303230313730333233313032333235333631'}
//Dictionary<string,string> result = JSONHelper.FromJson<Dictionary<string, string>>(ret);
//if (result["ret"] == "1")
//{
RentAttributeHelper rentAttributeHelper = new RentAttributeHelper();
RentAttribute rentAttribute = new RentAttribute(int.Parse(RentNo));
rentAttribute.RentNo = lblRentNo.Text;
rentAttribute.RRAContactName = txtContactName.Text.Trim();
rentAttribute.RRAContactTel = txtContactTel.Text.Trim();
rentAttribute.RRANationName = ddlNationName.SelectedItem.Text;
rentAttribute.RRAIDCard = txtIDCard.Text.Trim();
rentAttribute.RRentPrice = Convert.ToDecimal(txtRentPrice.Text.Trim());
rentAttribute.RRAContactProvince = ddlContactProvince.SelectedItem.Text;
rentAttribute.RRAStartDate = Convert.ToDateTime(txtStartDate.Text);
rentAttribute.RRAEndDate = Convert.ToDateTime(txtEndDate.Text);
rentAttribute.RRADescription = txtDescription.Text.Trim();
rentAttribute.Status = ((int)RentAttributeHelper.AttributeStatus.Complete).ToString();
//if (rentInfo.IsAvailable == false)
//{
// rentAttribute.RRACreatedBy = SysContext.CurrentUserName;
// rentAttribute.RRACreatedDate = System.DateTime.Now;
// //rentAttributeHelper.AddRentAttribute(rentAttribute);
//}
//else
//{
if (EditType == "E")
{
rentAttribute.RRAModifiedBy = SysContext.CurrentUserName;
rentAttribute.RRAModifiedDate = System.DateTime.Now;
rentAttributeHelper.UpdateRentAttribute(rentAttribute);
}
//}
//RentAttributeHelper helper = new RentAttributeHelper();
//string number = helper.AddRentAttribute(rentAttribute);
//string imgUrl = CreateQR(number);
//Session["RentOrder"] = rentAttribute;
//Response.Redirect("ScanImage.aspx?url=" + imgUrl + "&ran=" + number);
Session["RentNo"] = null;
ScriptManager.RegisterStartupScript(btnSave, GetType(), "warning", "javascript:SubmitDialog('" + rentAttribute.RentNo + "');", true);
//}
}
protected void btnSave_Click(object sender, EventArgs e)
{
RentInfo rentInfo = new RentInfo(RentNo);
//租户身份扫描
RentAttributeHelper rentAttributeHelper = new RentAttributeHelper();
RentAttribute rentAttribute = new RentAttribute(lblRentNo.Text);
rentAttribute.RentNo = lblRentNo.Text;
rentAttribute.RRAContactName = txtContactName.Text.Trim();
rentAttribute.RRAContactTel = txtContactTel.Text.Trim();
rentAttribute.RRANationName = txtPassword.Text;
rentAttribute.RRAIDCard = txtIDCard.Text.Trim();
rentAttribute.RRentPrice = Convert.ToDecimal(txtRentPrice.Text.Trim());
rentAttribute.RRAContactProvince = string.Empty;
rentAttribute.RRAStartDate = Convert.ToDateTime(txtStartDate.Text);
rentAttribute.RRAEndDate = Convert.ToDateTime(txtEndDate.Text);
rentAttribute.RRADescription = string.Empty;
rentAttribute.Status = ((int)RentAttributeHelper.AttributeStatus.Complete).ToString();
if (rentInfo.IsAvailable == false)
{
rentAttribute.RRACreatedBy = SysContext.CurrentUserName;
rentAttribute.RRACreatedDate = System.DateTime.Now;
}
else
{
if (EditType == "E")
{
rentAttribute.RRAModifiedBy = SysContext.CurrentUserName;
rentAttribute.RRAModifiedDate = System.DateTime.Now;
rentAttributeHelper.UpdateRentAttribute(rentAttribute);
}
}
RentAttributeHelper helper = new RentAttributeHelper();
string number = helper.AddRentAttribute(rentAttribute);
for (int i = 0; i < dlRenties.Items.Count; i++)
{
TextBox txtName = dlRenties.Items[i].FindControl("txtName") as TextBox;
TextBox txtIdCard = dlRenties.Items[i].FindControl("txtIdCard") as TextBox;
dtRenties.Rows[i][0] = txtName.Text;
dtRenties.Rows[i][1] = txtIdCard.Text;
}
//写入随行人员
foreach (DataRow row in dtRenties.Rows)
{
if (!row.IsNull("Name") && !row.IsNull("IDCard"))
{
helper.AddRetinues(row["Name"].ToString(), row["IDCard"].ToString(), number);
}
}
//写入密码
helper.AddPassword(lblRentNo.Text, txtPassword.Text, txtStartDate.Text, txtEndDate.Text, txtContactTel.Text);
//写入华泽数据
helper.UploadDataToHZ(number, lblRentNo.Text);
//string imgUrl = CreateQR(number);
//Session["RentOrder"] = rentAttribute;
//Response.Redirect("ScanImage.aspx?url=" + imgUrl + "&ran=" + number);
//Session["RentNo"] = null;
ScriptManager.RegisterStartupScript(btnSave, GetType(), "warning", "javascript:SubmitDialog();", true);
//}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
System.IO.Stream postData = Request.InputStream;
StreamReader sRead = new StreamReader(postData);
string postContent = sRead.ReadToEnd();
sRead.Close();
Dictionary <string, string> retDic = new Dictionary <string, string>();
string sql = string.Empty;
string statucode = "200";
string reason = "";
FileStream fs = new FileStream(Server.MapPath("~") + "\\MotorManage\\Log.txt", FileMode.Append);
StreamWriter sw = new StreamWriter(fs);
//sw.WriteLine(DateTime.Now.ToString() + " " + Request.Headers["ResourceId"] + " " + postContent);
try
{
switch (Request.Headers["ResourceId"])
{
case "banevent": //道闸事件
//postContent ="{\"res\":[{\"whois\":{\"pln\":\"津GHY798\",\"etag\":\"\"},\"loc\":{\"parklot\":\"ff8080815d340ac3015d3e2bc5c00004\",\"logicid\":\"8\"},\"status\":1,\"timeStamp\":\"2017-11-16T11:57:43+08:00\"}]}";
Dictionary <string, BanEvent[]> ret1 = JSONHelper.FromJson <Dictionary <string, BanEvent[]> >(postContent);
//{
// “loc”:{“parklot”: “0201”, “logicid”:”755001”},
// “whois”:{“pln”: “”, “etag”:””},
// "status": 0,
// "timeStamp":”2016-11-01T19:40:00+8:00”
//}
foreach (BanEvent b in ret1["res"])
{
sql = "insert into Motor_BanEvent values ('" + Guid.NewGuid().ToString() + "','" + b.loc.parklot + "','" + b.loc.logicid + "','" + b.whois.pln + "','" + b.whois.etag + "','" + b.status + "','" + DateTime.Parse(b.timestamp).ToString() + "','')";
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
sql = "Update Motor_berthesInfo set status='" + b.status + "' where ParkID='" + b.loc.parklot + "' and BertheNumber ='" + b.loc.logicid + "'";
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
string uploadData = ConfigurationManager.AppSettings["UploadData"];
RentAttribute rentAttribute = new RentAttribute();
RentAttributeHelper rentAttributeHelper = new RentAttributeHelper();
if (uploadData.Equals("1"))
{
//string sql = "insert into T_Person_Info values ('" + Guid.NewGuid().ToString() + "','" + info.RRAID.ToString() + "','" + info.RRAContactName + "','" + info.RRAIDCard + "','0','" + DateTime.Now.ToString() + "','0','','RZF','" + rent.RAddress + "','" + rent.RPSName + "','" + rent.RPSName + "','0','','')";
rentAttributeHelper.UploadPersonInfo("0", b.whois.pln);
}
}
break;
case "parkevent": //停车走车
Dictionary <string, ParkEvent[]> ret2 = JSONHelper.FromJson <Dictionary <string, ParkEvent[]> >(postContent);
//{
// “loc”:{“parklot”: “0201”, “logicid”:”755001”},
// “whois”:{“pln”: “”, “etag”:””},
// "status": 0,
// "timeStamp":”2016-11-01T19:40:00+8:00”
//}
foreach (ParkEvent p in ret2["res"])
{
sql = "insert into Motor_ParkEvent values ('" + Guid.NewGuid().ToString() + "','','" + p.loc.logicid + "','" + p.whois.pln + "','" + p.whois.etag + "','" + p.status + "','" + DateTime.Parse(p.timestamp).ToString() + "','')";
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
sql = "Update Motor_berthesInfo set status='" + p.status + "' where BertheNumber ='" + p.loc.logicid + "'";
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
}
break;
case "devstatus": //车位状态
break;
case "alarm": //告警
break;
}
}
catch (Exception ex)
{
statucode = "201";
reason = ex.Message;
sw.WriteLine(DateTime.Now.ToString() + " " + ex.Message);
}
//开始写入
sw.WriteLine(DateTime.Now.ToString() + " " + Request.Headers["ResourceId"] + " " + postContent);
//清空缓冲区
sw.Flush();
//关闭流
sw.Close();
fs.Close();
Dictionary <string, string> ret = new Dictionary <string, string>();
ret.Add("rsc", statucode);
ret.Add("reason", reason);
Response.Write(JSONHelper.ToJson(ret));
}
}
public static AjaxResult AddRentRecord(string name, string idcard)
{
string sql = "select * from rent_rentattribute where (('" + DateTime.Now + "'>=RRAStartDate and '" + DateTime.Now.ToString() + "'< RRAEndDate)" +
" or ('" + DateTime.Now.AddDays(4).ToString() + "'>RRAStartDate and '" + DateTime.Now.AddDays(4).ToString() + "'<=RRAEndDate) or ('" + DateTime.Now.ToString() + "'<RRAStartDate and '" + DateTime.Now.AddDays(4).ToString() + "'>RRAEndDate)) and rrastatus not in ('5','7','8','9') order by RRACreatedDate desc";
DataTable dt1 = MySQLHelper.ExecuteDataset(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql)).Tables[0];
Dictionary <string, string> used = new Dictionary <string, string>();
Dictionary <string, string> all = new Dictionary <string, string>();
Dictionary <string, string> left = new Dictionary <string, string>();
foreach (DataRow r in dt1.Rows)
{
used.Add(r["rraId"].ToString(), r["RentNO"].ToString());
}
sql = "select * from v_RentDetail_view where RIDCard=(select idcard from CF_User where LoginName='" + LigerRM.Common.SysContext.CurrentUserName + "')";
DataTable dt = DB.ExecuteDataSet(sql).Tables[0];
foreach (DataRow r in dt.Rows)
{
all.Add(r["rid"].ToString(), r["RentNO"].ToString());
}
foreach (KeyValuePair <string, string> p in all)
{
if (!used.Values.Contains(p.Value))
{
left.Add(p.Key, p.Value);
}
}
string rentNo = string.Empty;
if (left.Count == 0)
{
Random ran = new Random(1);
int index = ran.Next(0, all.Count);
rentNo = dt.Rows[index]["RentNO"].ToString();
}
else
{
Random ran = new Random(1);
int index = ran.Next(0, left.Count);
rentNo = left.Values.ToList()[index];
}
RentInfo rentInfo = new RentInfo(rentNo);
//租户身份扫描
RentAttributeHelper rentAttributeHelper = new RentAttributeHelper();
RentAttribute rentAttribute = new RentAttribute(rentInfo.RentNo);
rentAttribute.RentNo = rentInfo.RentNo;
rentAttribute.RRAContactName = name;
rentAttribute.RRAContactTel = string.Empty;
rentAttribute.RRANationName = string.Empty;
rentAttribute.RRAIDCard = idcard;
rentAttribute.RRentPrice = Convert.ToDecimal(rentInfo.RLocationDescription);
rentAttribute.RRAContactProvince = string.Empty;
rentAttribute.RRAStartDate = DateTime.Now;
rentAttribute.RRAEndDate = DateTime.Now.AddDays(4);
rentAttribute.RRADescription = string.Empty;
rentAttribute.Status = ((int)RentAttributeHelper.AttributeStatus.Complete).ToString();
rentAttribute.RRACreatedBy = SysContext.CurrentUserName;
rentAttribute.RRACreatedDate = System.DateTime.Now;
RentAttributeHelper helper = new RentAttributeHelper();
string number = helper.AddRentAttribute(rentAttribute);
//写入华泽数据
helper.UploadDataToHZ(number, rentInfo.RentNo);
return(AjaxResult.Success());
}
