public OrderDetail Save(OrderDetail orderDetail)
{
var orderDetailRepo = Mapper.Map <OrderDetailRepo>(orderDetail);
NH.Run(s => s.SaveOrUpdate(orderDetailRepo));
return(Mapper.Map <OrderDetail>(orderDetailRepo));
}
public Album Save(Album album)
{
var albumRepo = Mapper.Map <AlbumRepo>(album);
NH.Run(s => s.SaveOrUpdate(albumRepo));
return(Mapper.Map <Album>(albumRepo));
}
public Artist Save(Artist artist)
{
var artistRepo = Mapper.Map <ArtistRepo>(artist);
NH.Run(s => s.SaveOrUpdate(artistRepo));
return(Mapper.Map <Artist>(artistRepo));
}
public Cart Save(Cart cart)
{
var artistRepo = Mapper.Map <CartRepo>(cart);
NH.Run(s => s.SaveOrUpdate(cart));
return(Mapper.Map <Cart>(artistRepo));
}
public List <Driver> GetActiveDrivers()
{
using (var session = NH.OpenSession())
{
return(session.Query <Driver>().Where(x => x.Drv_Timing >= DateTime.Now.AddMinutes(-30)).ToList());
}
}
public Order Save(Order genre)
{
var orderRepo = Mapper.Map <OrderRepo>(genre);
NH.Run(s => s.SaveOrUpdate(orderRepo));
return(Mapper.Map <Order>(orderRepo));
}
public Driver Login(LoginBody loginBody)
{
using (ISession session = NH.OpenSession())
{
try
{
var _password = session.CreateSQLQuery($"select Drv_Password from dbo.Drivers where Drv_Ident={loginBody.ident}").UniqueResult <string>();
Log(_password);
var check = loginBody.password == _password;//BCrypt.Net.BCrypt.CheckPassword(loginBody.password, _password);
if (check)
{
return(session.Query <Driver>().FetchMany(x => x.OpinionList)
.Where(x => x.Drv_Identity == loginBody.ident).FirstOrDefault());
}
else
{
return(null);
}
// return result;//result.FirstOrDefault();
}
catch (Exception e)
{
Log(e.Message);
return(null);
}
}
}
public bool Register(RegisterBody registerBody)
{
using (var session = NH.OpenSession())
{
if (session.Query <Driver>().Where(x => x.Drv_Identity == registerBody.driver.Drv_Identity).FirstOrDefault() != null)
{
return(false);
}
else
{
try
{
using (var trans = session.BeginTransaction())
{
var driv = registerBody.driver;
session.CreateSQLQuery($"insert into dbo.drivers(Drv_Name,Drv_Surname,Drv_Identity,Drv_Password,Drv_Phone) values ('{driv.Drv_Name}','{driv.Drv_Surname}','{driv.Drv_Identity}','','{driv.Drv_Phone}')").ExecuteUpdate();
trans.Commit();
}
session.CreateSQLQuery($"update dbo.drivers set Drv_Password='******'").ExecuteUpdate();
return(true);
}
catch (Exception e)
{
Log(e.Message);
return(false);
}
}
}
}
public Genre Save(Genre genre)
{
var genreRepo = Mapper.Map <GenreRepo>(genre);
NH.Run(s => s.SaveOrUpdate(genreRepo));
return(Mapper.Map <Genre>(genreRepo));
}
public void MedianTest()
{
var median = NH.Median <int>(input);
var median3 = NH.Median <int>(input3);
var median4 = NH.Median <int>(input4);
var median5 = NH.Median <int>(input5);
//DebugLogger.Instance.WriteLine(median);
}
public bool Locate(LocateBody locateBody)//string ident, decimal lat, decimal lng)
{
try
{
using (var session = NH.OpenSession())
{
session.CreateSQLQuery($"update dbo.drivers set Drv_Latitude={locateBody.lat},Drv_Longitude={locateBody.lng},Drv_Timing={DateTime.Now} where Drv_Ident={locateBody.ident}").ExecuteUpdate();
}
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// 保存关系WF_NodePage
/// </summary>
public ActionResult SaveRelation_NodePage(int NodeID, List <string> PageIDS)
{
foreach (var item in PageIDS)
{
var entity = NH.GetSession <WF_Node>().QueryOver <WF_NodePage>().Where(x => x.PageID == item && x.NodeID == NodeID).List().FirstOrDefault();
if (entity == null)
{
entity = new WF_NodePage()
{
NodeID = NodeID,
PageID = item
};
entity.Save();
}
}
return(Json(new { success = true }));
}
/// <summary>
/// 保存关系WF_NodeEmp
/// </summary>
public ActionResult SaveRelation_NodeEmp(int FK_Node, List <string> FK_EmpS)
{
foreach (var item in FK_EmpS)
{
var entity = NH.GetSession <WF_Node>().QueryOver <WF_NodeEmp>().Where(x => x.FK_Emp == item && x.FK_Node == FK_Node).List().FirstOrDefault();
if (entity == null)
{
entity = new WF_NodeEmp()
{
FK_Node = FK_Node,
FK_Emp = item
};
entity.Save();
}
}
return(Json(new { success = true }));
}
/// <summary>
/// 保存关系Auth_Rlt_UserRole
/// </summary>
public ActionResult SaveRelation_UserRole(string RoleID, List <string> UserIDS)
{
foreach (var item in UserIDS)
{
var entity = NH.GetSession <Auth_Role>().QueryOver <Auth_Rlt_UserRole>().Where(x => x.UserID == item && x.RoleID == RoleID).List().FirstOrDefault();
if (entity == null)
{
entity = new Auth_Rlt_UserRole()
{
RoleID = RoleID,
UserID = item
};
entity.Save();
}
}
return(Json(new { success = true }));
}
/// <summary>
/// 保存关系Auth_Rlt_RoleAuthorization
/// </summary>
public ActionResult SaveRelation_RoleAuthorization(string AuthorizationID, List <string> RoleIDS)
{
foreach (var item in RoleIDS)
{
var entity = NH.GetSession <Auth_Authorization>().QueryOver <Auth_Rlt_RoleAuthorization>().Where(x => x.RoleID == item && x.AuthorizationID == AuthorizationID).List().FirstOrDefault();
if (entity == null)
{
entity = new Auth_Rlt_RoleAuthorization()
{
AuthorizationID = AuthorizationID,
RoleID = item
};
entity.Save();
}
}
return(Json(new { success = true }));
}
/// <summary>
/// 保存
/// </summary>
/// <returns></returns>
public ActionResult SaveDirection()
{
try
{
var entity = GetUpdateModel(null, "MYPK");
var list = NH.GetSession <WF_Direction>().QueryOver <WF_Direction>().Where(x => x.MyPK == entity.MyPK).List();
if (list.Count > 0)
{
throw new Exception("重复的连接线！");
}
entity.SaveOrUpdate();
return(Json(new { success = true, entity = entity }));
}
catch (Exception ex)
{
return(Json(new { success = false, msg = "保存失败！" + ex.Message, error = JsonConvert.SerializeObject(ex) }));
}
}
public bool AddOpinion(Opinion opinion)
{
using (ISession session = NH.OpenSession())
{
try
{
using (var transaction = session.BeginTransaction())
{
session.Save(opinion);
transaction.Commit();
}
return(true);//result.FirstOrDefault();
}
catch
{
return(false);
}
}
}
public ActionResult LoadMyForm(string FK_Flow, int NodeID, int ToNodeID)
{
var entity = NH.GetSession <WF_Cond>().QueryOver <WF_Cond>().Where(x => x.NodeID == NodeID && x.ToNodeID == ToNodeID).List().FirstOrDefault();
if (entity == null)
{
entity = new WF_Cond()
{
FK_Flow = FK_Flow,
NodeID = NodeID,
ToNodeID = ToNodeID,
CondType = (int)BP.WF.Template.CondType.Dir,
DataFrom = (int)BP.WF.Template.ConnDataFrom.Paras,
FK_Operator = "=",
ConnJudgeWay = 0,
PRI = 0,
CondOrAnd = 0
};
}
return(Json_Get(entity));
}
protected override string GetColumnName(NH.PropertyPath subject)
{
return GetBaseColumnName(subject) + "Id";
}
public IList <Artist> GetList()
{
return(Mapper.Map <IList <Artist> >(NH.Select(s => s.QueryOver <ArtistRepo>().List())));
}
public OrderDetail GetById(long id)
{
return(Mapper.Map <OrderDetail>(NH.Select(s => s.Get <OrderDetail>(id))));
}
public void Delete(Artist artist)
{
NH.Run(s => s.Delete(Mapper.Map <ArtistRepo>(artist)));
}
public Artist GetById(long id)
{
return(Mapper.Map <Artist>(NH.Select(s => s.Get <AlbumRepo>(id))));
}
public Genre GetById(long id)
{
return(Mapper.Map <Genre>(NH.Select(s => s.Get <GenreRepo>(id))));
}
public void Delete(Genre genre)
{
NH.Run(s => s.Delete(Mapper.Map <GenreRepo>(genre)));
}
protected override string GetIndexColumnName(NH.PropertyPath subject)
{
return base.GetIndexColumnName(subject).Underscore();
}
public IList <Genre> GetList()
{
var genreList = Mapper.Map <IList <Genre> >(NH.Select(s => s.QueryOver <GenreRepo>().List()));
return(genreList.OrderBy(a => a.Name).ToList());
}
public void Median2Test()
{
var median = NH.Median2 <double>(input2);
//DebugLogger.Instance.WriteLine(median);
}
static TaxiService()
{
NH.Init("Server = KAROL-PC\\KAROLSERV; Database = RestDB; User Id = sa; Password = admin");
}
public void Delete(Order order)
{
NH.Run(s => s.Delete(Mapper.Map <OrderRepo>(order)));
}
public IList <Order> GetList()
{
return(Mapper.Map <IList <Order> >(NH.Select(s => s.QueryOver <OrderRepo>().List())));
}
public Order GetById(long id)
{
return(Mapper.Map <Order>(NH.Select(s => s.Get <OrderRepo>(id))));
}
