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));
}
