public static AjaxResult AddICCard(string id, string deviceId, string icCard, string startDate, string endDate, string locktype) { NewLockManager managerNew = new NewLockManager(); string start = managerNew.GetDateTime(startDate).ToString(); string end = managerNew.GetDateTime(endDate).ToString(); if (locktype == "1") //新锁 { string type = startDate == endDate ? "3" : "4"; string returnDate = managerNew.GetPostInterface(deviceId, "Admin", type, icCard, start, end); Dictionary <string, object> returnInfo = new Dictionary <string, object>(); returnInfo = JSONHelper.FromJson <Dictionary <string, object> >(returnDate); if (returnInfo["ret"].ToString() == "1") { return(AjaxResult.Error(returnInfo["msg"].ToString())); } } else { LockManager manager = new LockManager(); manager.AddICCard(deviceId, icCard, startDate, endDate); manager.UpdatePassengerInfoToDevice(deviceId, icCard, "", "", "", DateTime.Parse(start).ToString("yyyyMMddHHmm").Substring(2, 10), DateTime.Parse(end).ToString("yyyyMMddHHmm").Substring(2, 10), "1"); } return(AjaxResult.Success()); }
public string GetLockReturnInfo(string info, string status, string index, string lockerid, string cardid, string type, string time) { string statucode = "0"; string reason = ""; FileStream fs = new FileStream(Server.MapPath("~") + "\\BaseManage\\Log.txt", FileMode.Append); StreamWriter sw = new StreamWriter(fs); sw.WriteLine(DateTime.Now.ToString() + " info:" + info + " status:" + status + " index:" + index + " lockerid:" + lockerid + " cardid:" + cardid + " type:" + type + " time:" + time); try { //0-刷卡开门, //1-添加刷卡卡号 //2-删除刷卡卡号 //3-通过手机APP方式添加身份证UID, //4-通过手机APP删除身份证UID, //5-卡号过期,自动删除 string sql = "insert into Rent_Locks_ReturnLog values ('" + Guid.NewGuid().ToString() + "','" + index + "','" + lockerid + "','" + cardid + "','" + type + "','" + time + "','" + DateTime.Now.ToString() + "','" + GetTypeDesc(type, cardid) + "','')"; MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql)); if (type == "3") //添加身份证编号到表内 { Dictionary <string, string> ret = new Dictionary <string, string>(); sql = "select * from v_RentHistory_view where DeviceID='" + lockerid + "' and RRAStartDate<='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' and RRAEndDate>'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' and RRAStatus='2'"; DataTable dt = MySQLHelper.ExecuteDataset(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql)).Tables[0]; if (dt.Rows.Count > 0) { LockManager manager = new LockManager(); manager.AddICCard(lockerid, cardid, dt.Rows[0]["RRAStartDate"].ToString(), dt.Rows[0]["RRAEndDate"].ToString()); } } } 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> ret1 = new Dictionary <string, string>(); ret1.Add("resutcode", statucode); ret1.Add("reason", reason); return(JSONHelper.ToJson(ret1)); }