/// <summary>
/// 添加车辆信息
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void ADDCLINFO(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
SZHL_YCGL_CAR carInfo = JsonConvert.DeserializeObject <SZHL_YCGL_CAR>(P1);
if (string.IsNullOrEmpty(carInfo.CarType))
{
msg.ErrorMsg = "请选择车类型";
return;
}
if (string.IsNullOrEmpty(carInfo.CarNum))
{
msg.ErrorMsg = "请填写车牌号";
return;
}
if (carInfo.ID == 0)
{
SZHL_YCGL_CAR carInfo1 = new SZHL_YCGL_CARB().GetEntity(d => d.CarNum == carInfo.CarNum && d.ComId == UserInfo.User.ComId);
if (carInfo1 != null)
{
msg.ErrorMsg = "已有此车牌号的车辆";
}
else
{
carInfo.CRDate = DateTime.Now;
carInfo.CRUser = UserInfo.User.UserName;
carInfo.ComId = UserInfo.User.ComId;
carInfo.IsDel = 0;
new SZHL_YCGL_CARB().Insert(carInfo);
}
}
else
{
new SZHL_YCGL_CARB().Update(carInfo);
}
}
/// <summary>
/// 查看可用车辆列表（微信端）
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void GETKYCLLIST(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
//var list = new SZHL_HYGL_ROOMB().GetEntities(p => p.Status == "1" && p.IsDel == 0);
string strwhere = string.Empty;
if (P1 != "all")
{
strwhere = " and isnull(CarBrand,'')!='' ";
}
DataTable dt = new SZHL_YCGL_CARB().GetDTByCommand("select * from dbo.SZHL_YCGL_CAR where IsDel=0 and Status='0' and comid=" + UserInfo.QYinfo.ComId + strwhere);
dt.Columns.Add("CarTypeName", Type.GetType("System.String"));
dt.Columns.Add("ZT", Type.GetType("System.String"));
dt.Columns.Add("ZYSJ", Type.GetType("System.String"));
foreach (DataRow dr in dt.Rows)
{
int rid = Int32.Parse(dr["ID"].ToString());
int tid = Int32.Parse(dr["CarType"].ToString());
var st = DateTime.Now;
var et = DateTime.Now.AddDays(1);
var jaz = new JH_Auth_ZiDianB().GetEntity(p => p.ID == tid);
if (jaz != null)
{
dr["CarTypeName"] = jaz.TypeName;
}
var list = new SZHL_YCGLB().GetEntities(p => p.ComId == UserInfo.QYinfo.ComId && p.CarID == rid && p.IsDel == 0 && ((st > p.StartTime && st < p.EndTime) || (et > p.StartTime && et < p.EndTime))).OrderBy(p => p.StartTime);
if (list.Count() == 0)
{
dr["ZT"] = "0";
dr["ZYSJ"] = "";
}
else
{
dr["ZT"] = "1";
dr["ZYSJ"] = list.First().StartTime.Value.ToString("yyyy-MM-dd HH:mm") + "~" + list.First().EndTime.Value.ToString("yyyy-MM-dd HH:mm");
}
}
msg.Result = dt;
}
/// <summary>
/// 获取车辆信息
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void GETCLINFO(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
int Id = int.Parse(P1);
var car = new SZHL_YCGL_CARB().GetEntity(d => d.ID == Id && d.ComId == UserInfo.User.ComId);
msg.Result = car;
//string strSql = string.Format("SELECT ycgl.* from SZHL_YCGL ycgl inner join SZHL_YCGL_CAR car on ycgl.CarID=car.ID inner join Yan_WF_PI wfpi on ycgl.intProcessStanceid=wfpi.ID where wfpi.isComplete='Y' and ycgl.ComId={0} and ycgl.CarID={1}", UserInfo.User.ComId, Id);
//msg.Result1 = new SZHL_YCGL_CARB().GetDTByCommand(strSql);
int tid = Int32.Parse(car.CarType);
msg.Result3 = new JH_Auth_ZiDianB().GetEntity(p => p.ID == tid);
#region 微信端
var st = DateTime.Now;
var list = new SZHL_YCGLB().GetEntities(p => p.CarID == Id && p.IsDel == 0 && st < p.EndTime).OrderBy(p => p.StartTime);
List <int> li = new List <int>();
foreach (var l in list)
{
var pi = new Yan_WF_PIB().GetEntity(p => p.ID == l.intProcessStanceid);
if (pi != null && pi.IsCanceled == "Y")
{
li.Add(l.ID);
}
}
var list1 = list.Where(p => !li.Contains(p.ID));
msg.Result2 = list1;
#endregion
if (!string.IsNullOrEmpty(car.Files))
{
msg.Result4 = new FT_FileB().GetEntities(" ID in (" + car.Files + ")");
}
}
