private string NewUserID(UnitParameter up)
{
var s = from t in DB.LamdaTable(up, "user_info", "a")
where t.userid.startwith(DateTime.Now.ToString("yyyyMMdd"))
select t;
var maxid = Int64Std.IsNotInt64Then(s.Max(up, "userid"), Int64Std.ParseStd(DateTime.Now.ToString("yyyyMMdd") + "00000").Value);
return((maxid + 1).ToString());
}
private string GetNewSeq(string maxseq)
{
var currentfirst = DateTime.Now.ToString("yyyyMMdd") + "1".PadLeft(8, '0');
if (maxseq == "")
{
return(currentfirst);
}
if (Int64Std.IsNotInt64Then(maxseq) >= Int64Std.IsNotInt64Then(currentfirst))
{
return((Int64Std.IsNotInt64Then(maxseq) + 1).ToString());
}
else
{
return(currentfirst);
}
}
public override object post()
{
var estate_id = ComFunc.nvl(PostDataD.estate);
var position_id = ComFunc.nvl(PostDataD.position_id);
var device_id = ComFunc.nvl(PostDataD.device_id);
var occur_time = DateTimeStd.IsDateTimeThen(PostDataD.occur_time, "yyyy-MM-dd HH:mm:ss");
var plate_no = ComFunc.nvl(PostDataD.plate_no);
var plate_color = ComFunc.nvl(PostDataD.plate_color);
var vertical_color = ComFunc.nvl(PostDataD.vertical_color);
string pic = ComFunc.nvl(PostDataD.file_content).Replace(" ", "+");
string file_name = ComFunc.nvl(PostDataD.file_name);
long file_length = Int64Std.IsNotInt64Then(PostDataD.file_length);
BeginTrans();
var up = DB.NewDBUnitParameter();
if (!(from t in DB.LamdaTable(up, "IC_Position")
where t.P_GUID == position_id
select t).IsExists(up))
{
return(new
{
code = "failed",
msg = "不是合法的位置信息"
});
}
if (!(from t in DB.LamdaTable(up, "IC_Device")
where t.D_UID == device_id
select t).IsExists(up))
{
return(new
{
code = "failed",
msg = "不是合法的设备"
});
}
if (!(from t in DB.LamdaTable(up, "IC_Estate")
where t.E_ID == estate_id
select t).IsExists(up))
{
return(new
{
code = "failed",
msg = "小区信息不正确"
});
}
if (!ComFunc.IsBase64(pic) || file_length == 0)
{
return(new
{
code = "failed",
msg = "抓拍图片格式不正确"
});
}
if (occur_time == "")
{
return(new
{
code = "failed",
msg = "抓拍时间格式不正确"
});
}
var uid = Guid.NewGuid().ToString();
DB.QuickInsert(up, "IC_Car_Monitor", new
{
CM_GUID = uid,
CM_Estate_ID = estate_id,
CM_Occur_Time = occur_time,
CM_Position_XY = position_id,
CM_Device = device_id,
CM_Pic1 = "",
CM_IsProcessed = 0,
add_id = TokenPayLoad.ID,
add_name = ComFunc.nvl(TokenPayLoad["username"]),
add_ip = ClientInfo.IP,
add_time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
last_id = TokenPayLoad.ID,
last_name = ComFunc.nvl(TokenPayLoad["username"]),
last_ip = ClientInfo.IP,
last_time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
});
CommitTrans();
return(new
{
code = "success",
msg = "",
uid
});
}
