/// <summary>
/// 评论数据查询
/// </summary>
/// <returns></returns>
public static List <CommentModel> GetCommentData()
{
var sqlStr = new StringBuilder();
sqlStr.Append(@"SELECT C.CommentID
,C.FaBuUserID
,C.OrderID
,C.ComIntor
,C.Status
,C.Memo
,C.CreateDate
,U.NickName
,U.ImgUrl
FROM tb_Comment C
LEFT JOIN tb_User U ON U.ID=C.FaBuUserID");
using (CareCenterEntities entity = new CareCenterEntities())
{
try
{
var CommentList = entity.Database.SqlQuery <CommentModel>(sqlStr.ToString()).ToList();
return(CommentList);
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 新增需求（订单）
/// </summary>
/// <param name="order"></param>
/// <returns></returns>
public static int OwnNeedDataIns(tb_Order order)
{
using (CareCenterEntities entity = new CareCenterEntities())
{
try
{
int count = 0;
var orderdata = entity.tb_Order.FirstOrDefault(item => item.OrderID == order.OrderID);
if (orderdata == null)
{
order.Status = 0;
order.CreateDate = Utility.GetSysDateTime();
entity.Entry(order).State = System.Data.Entity.EntityState.Added;
entity.SaveChanges();
count = 1;
}
return(count);
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 更新订单状态
/// </summary>
/// <param name="orderid"></param>
/// <param name="status"></param>
/// <returns></returns>
public static int UpdOrderStatus(string orderid, int status)
{
using (CareCenterEntities entity = new CareCenterEntities())
{
try
{
int count = 0;
var order = entity.tb_Order.FirstOrDefault(item => item.OrderID == orderid);
if (order != null)
{
order.Status = status;
entity.Entry(order).State = System.Data.Entity.EntityState.Modified;
entity.SaveChanges();
count = 1;
}
return(count);
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 修改文本数据
/// </summary>
/// <param name="con"></param>
/// <returns></returns>
public static int UpdContextData(tb_Context con)
{
using (CareCenterEntities entity = new CareCenterEntities())
{
int count = 0;
try
{
var context = entity.tb_Context.FirstOrDefault(item => item.ContextID == con.ContextID && item.Status == 1);
if (context != null)
{
context.Title = con.Title;
context.Explain = con.Explain;
context.Intro = con.Intro;
context.Title = con.Title;
entity.Entry(context).State = System.Data.Entity.EntityState.Modified;
entity.SaveChanges();
count = 1;
}
return(count);
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 兼职申请
/// </summary>
/// <returns></returns>
public static int SetPartTimeTeacher(tb_PartTime pt)
{
using (CareCenterEntities entity = new CareCenterEntities())
{
try
{
int count = 0;
var teacher = entity.tb_PartTime.FirstOrDefault(item => item.UserID == pt.UserID && item.Status != -1);
if (teacher == null)
{
pt.PartTimeID = Utility.GetNewGUID_Tab();
pt.Status = 1;//待确定
pt.CreateDate = Utility.GetSysDateTime();
entity.Entry(pt).State = System.Data.Entity.EntityState.Added;
entity.SaveChanges();
count = 1;
}
return(count);
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 新增文本数据
/// </summary>
/// <param name="con"></param>
/// <returns></returns>
public static int AddContextData(tb_Context con)
{
using (CareCenterEntities entity = new CareCenterEntities())
{
int count = 0;
try
{
var context = entity.tb_Context.FirstOrDefault(item => item.Type == con.Type && item.Status == 1);
if (context == null)
{
con.ContextID = Utility.GetNewGUID_Tab();
con.Status = 1;
con.CreateDate = DateTime.Now;
entity.Entry(con).State = System.Data.Entity.EntityState.Added;
entity.SaveChanges();
count = 1;
}
return(count);
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 我的需求数据查询
/// </summary>
/// <param name="order"></param>
/// <returns></returns>
public static List <NeedModel> GetOwnNeedData()
{
var sqlStr = new StringBuilder();
sqlStr.Append(@"SELECT N.NeedID
,N.UserID
,N.NeedTitle
,N.NeedType
,N.NeedIntor
,N.NeedClassify
,N.Status
,N.Memo
,N.CreateDate
,P.PicUrl
,U.NickName
FROM tb_Need N
LEFT JOIN tb_Pictuer P ON P.OrderID=N.OrderID
LEFT JOIN tb_User U ON U.ID=N.UserID");
using (CareCenterEntities entity = new CareCenterEntities())
{
try
{
var NeedRecordList = entity.Database.SqlQuery <NeedModel>(sqlStr.ToString()).ToList();
return(NeedRecordList);
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 获取需求数据
/// </summary>
/// <returns></returns>
public static List <OrderModel> GetOrderList()
{
var strSql = new StringBuilder();
strSql.Append(@"SELECT O.OrderID
,O.UserID
,O.OrderTitle
,O.OrderType
,O.OrderIntor
,O.OrderClassify
,O.Status
,O.Memo
,O.CreateDate
,O.AdminUserID
,P.PicUrl
,U.NickName
,AU.NickName AS AdminNickName
,AU.UserPhone AS AdminPhone
,U.UserPhone
,V.VideoUrl
FROM tb_Order O
LEFT JOIN tb_Pictuer P ON P.OrderID=O.OrderID
LEFT JOIN tb_User U ON U.ID=O.UserID
LEFT JOIN tb_User AU ON AU.ID=O.AdminUserID
LEFT JOIN tb_Video V ON V.OrderID=O.OrderID");
using (CareCenterEntities entity = new CareCenterEntities())
{
var orderdata = entity.Database.SqlQuery <OrderModel>(strSql.ToString()).ToList();
return(orderdata);
}
}
/// <summary>
/// 编辑需求数据
/// </summary>
/// <param name="order"></param>
/// <returns></returns>
public static int EditOrderData(tb_Order order)
{
using (CareCenterEntities entity = new CareCenterEntities())
{
try
{
int count = 0;
var orderdata = entity.tb_Order.FirstOrDefault(item => item.OrderID == order.OrderID);
if (orderdata != null)
{
orderdata.Memo = order.Memo;
orderdata.OrderClassify = order.OrderClassify;
orderdata.OrderIntor = order.OrderIntor;
orderdata.OrderTitle = order.OrderTitle;
orderdata.OrderType = order.OrderType;
entity.Entry(orderdata).State = System.Data.Entity.EntityState.Modified;
entity.SaveChanges();
count = 1;
}
return(count);
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 注册
/// </summary>
/// <param name="userInfo"></param>
/// <returns></returns>
public static int SetUserInfo(tb_User userInfo)
{
using (CareCenterEntities entity = new CareCenterEntities())
{
try
{
int count = 0;
var user = entity.tb_User.FirstOrDefault(item => item.UserPhone == userInfo.UserPhone);
if (user == null)
{
userInfo.ID = Utility.GetNewGUID_Tab();
userInfo.LoginID = userInfo.UserPhone;
userInfo.Sex = 1;
userInfo.Status = 1;
userInfo.Role = 0;
userInfo.RoleStatus = 1;
userInfo.ImgUrl = "/Content/img/HeadImg/login.png";
userInfo.LastLognTime = DateTime.Now;
userInfo.CreateDate = DateTime.Now;
entity.Entry(userInfo).State = System.Data.Entity.EntityState.Added;
entity.SaveChanges();
count = 1;
}
return(count);
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 根据用户ID和密码查询
/// </summary>
/// <param name="phone"></param>
/// <param name="LoginPwd"></param>
/// <returns></returns>
public static tb_User GetLoginInfo(string phone, string LoginPwd)
{
using (CareCenterEntities entity = new CareCenterEntities())
{
var user = entity.tb_User.FirstOrDefault(item => item.UserPhone == phone && item.LoginPwd == LoginPwd);
return(user);
}
}
/// <summary>
/// 获取视频
/// </summary>
/// <returns></returns>
public static List <tb_Video> GetVideoList()
{
using (CareCenterEntities entity = new CareCenterEntities())
{
var videodata = entity.tb_Video.ToList();
return(videodata);
}
}
/// <summary>
/// 获取图片
/// </summary>
/// <returns></returns>
public static List <tb_Pictuer> GetPicList()
{
using (CareCenterEntities entity = new CareCenterEntities())
{
var picdata = entity.tb_Pictuer.ToList();
return(picdata);
}
}
/// <summary>
/// 获取所有管理员信息
/// </summary>
/// <returns></returns>
public static List <tb_Admins> GetAlladminInfo()
{
using (CareCenterEntities entity = new CareCenterEntities())
{
var admin = entity.tb_Admins.ToList();
return(admin);
}
}
/// <summary>
/// 根据手机获取信息
/// </summary>
/// <param name="phone"></param>
/// <returns></returns>
public static tb_User GetUserInfoByPhone(string phone)
{
using (CareCenterEntities entity = new CareCenterEntities())
{
var user = entity.tb_User.FirstOrDefault(item => item.UserPhone == phone || item.UserEmail == phone);
return(user);
}
}
/// <summary>
/// 获取服务方
/// </summary>
/// <returns></returns>
public static List <tb_User> GetCareParsonList()
{
using (CareCenterEntities entity = new CareCenterEntities())
{
var parson = entity.tb_User.Where(item => item.Status == 1).ToList();
return(parson);
}
}
/// <summary>
/// 获取文本数据列表
/// </summary>
/// <returns></returns>
public static List <tb_Context> GetAllContext()
{
using (CareCenterEntities entity = new CareCenterEntities())
{
var dataLlist = entity.tb_Context.Where(item => item.Status == 1).ToList();
return(dataLlist);
}
}
/// <summary>
/// 获取前台上传图片
/// </summary>
/// <returns></returns>
public static List <tb_Pictuer> GetPicList()
{
using (CareCenterEntities entity = new CareCenterEntities())
{
var picdata = entity.tb_Pictuer.Where(item => item.Status == 1).ToList();
return(picdata);
}
}
/// <summary>
/// 获取文本数据
/// </summary>
/// <returns></returns>
public static List <tb_Context> GetContextList()
{
using (CareCenterEntities entity = new CareCenterEntities())
{
var cotdata = entity.tb_Context.ToList();
return(cotdata);
}
}
/// <summary>
/// 获取收支记录
/// </summary>
/// <returns></returns>
public static List <tb_MoneyRecord> GetMoneyRecordList()
{
using (CareCenterEntities entity = new CareCenterEntities())
{
try
{
var MoneyRecordList = entity.tb_MoneyRecord.ToList();
return(MoneyRecordList);
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 根据用户ID获取兼职申请
/// </summary>
/// <param name="userid"></param>
/// <returns></returns>
public static List <tb_PartTime> GetPartTimeData(string userid)
{
using (CareCenterEntities entity = new CareCenterEntities())
{
try
{
var teacher = entity.tb_PartTime.Where(item => item.UserID == userid && item.Status != -1).ToList();
return(teacher);
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 根据订单编号获取订单
/// </summary>
/// <param name="orderid"></param>
/// <returns></returns>
public static tb_Order GetOrderDataBYOrderID(String orderid)
{
using (CareCenterEntities entity = new CareCenterEntities())
{
try
{
var Orderdata = entity.tb_Order.FirstOrDefault(item => item.OrderID == orderid);
return(Orderdata);
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 根据用户ID获取兼职申请
/// </summary>
/// <param name="userid"></param>
/// <returns></returns>
public static tb_PartTime GetPartTimeData(string userid)
{
using (CareCenterEntities entity = new CareCenterEntities())
{
try
{
var teacher = entity.tb_PartTime.FirstOrDefault(item => item.UserID == userid && item.Status == 1);
return(teacher);
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 修改登录密码
/// </summary>
/// <param name="phone"></param>
/// <param name="pwd"></param>
/// <param name="newpwd"></param>
/// <returns></returns>
public static int UpdAdminPwd(string phone, string pwd, string newpwd)
{
using (CareCenterEntities entity = new CareCenterEntities())
{
int count = 0;
var admin = entity.tb_Admins.FirstOrDefault(item => item.Mobile == phone && item.AdminPwd == pwd);
if (admin != null)
{
admin.AdminPwd = newpwd;
entity.Entry(admin).State = System.Data.Entity.EntityState.Modified;
entity.SaveChanges();
count = 1;
}
return(count);
}
}
/// <summary>
/// 获取订单记录
/// </summary>
/// <returns></returns>
public static List <OrderModel> GetOrderRecordList()
{
var sqlStr = new StringBuilder();
sqlStr.Append(@"SELECT O.OrderID
,O.UserID
,O.OrderTitle
,O.OrderType
,O.OrderIntor
,O.OrderClassify
,O.Status
,O.Memo
,O.CreateDate
,O.AdminUserID
,P.PicUrl
,U.NickName
,U.UserPhone
,AU.NickName AS AdminNickName
,AU.UserPhone AS AdminPhone
,V.VideoUrl
,O.PersonInro
,O.Address
,O.CarePerson
,O.CareAddress
,O.CeraRange
,O.DateType
FROM tb_Order O
LEFT JOIN tb_Pictuer P ON P.OrderID=O.OrderID
LEFT JOIN tb_User U ON U.ID=O.UserID
LEFT JOIN tb_User AU ON AU.ID=O.AdminUserID
LEFT JOIN tb_Video V ON V.OrderID=O.OrderID");
using (CareCenterEntities entity = new CareCenterEntities())
{
try
{
var OrderRecordList = entity.Database.SqlQuery <OrderModel>(sqlStr.ToString()).ToList();
return(OrderRecordList);
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 根据用户名或手机号码获取信息
/// </summary>
/// <param name="adminid"></param>
/// <returns></returns>
public static tb_Admins GetAdminInfoByAdmin(string adminPhone)
{
using (CareCenterEntities entity = new CareCenterEntities())
{
tb_Admins refAdmin = new tb_Admins();
if (adminPhone.Length == 11)
{
refAdmin = entity.tb_Admins.FirstOrDefault(item => item.Mobile == adminPhone);
}
else
{
refAdmin = entity.tb_Admins.FirstOrDefault(item => item.AdminID == adminPhone);
}
return(refAdmin);
}
}
/// <summary>
/// 根据用户adminID获取菜单
/// </summary>
/// <param name="adminid"></param>
/// <returns></returns>
//public static List<eo_admins_menu> GetAdminMenu(string adminid)
//{
// var strSql = new StringBuilder();
// strSql.Append(@"SELECT M.MenuID
// ,M.MenuName
// ,M.FMenuID
// ,M.FMenuName
// ,M.MenuUrl
// ,M.FMenuUrl
// ,M.Status
// ,M.Memo
// ,M.CreateDate
// FROM eo_admins A
// LEFT JOIN eo_admins_role R ON R.RoleID=A.RoleID AND R.Status=1
// LEFT JOIN eo_admins_menu M ON (SELECT CHARINDEX(M.MenuID,R.MenuID))>0 AND M.Status=1
// WHERE A.AdminID='" + adminid + "' AND A.Status=1");
// using (eo_dbEntities entity = new eo_dbEntities())
// {
// var menu = entity.Database.SqlQuery<eo_admins_menu>(strSql.ToString()).ToList();
// return menu;
// }
//}
#endregion
#region ***后台用户管理***
/// <summary>
/// 禁用/启用管理员
/// </summary>
/// <returns></returns>
public static int UpdAdminStatus(string id, int status)
{
using (CareCenterEntities entity = new CareCenterEntities())
{
var admin = entity.tb_Admins.FirstOrDefault(item => item.ID == id);
if (admin != null)
{
admin.Status = status;
entity.Entry(admin).State = System.Data.Entity.EntityState.Modified;
entity.SaveChanges();
return(1);
}
else
{
return(-1);
}
}
}
/// <summary>
/// 更新登录时间和次数
/// </summary>
/// <param name="userid">用户ID</param>
/// <param name="lastlogintime">登录时间</param>
/// <returns></returns>
public static bool UpdateLastLoginTime(string userid, DateTime lastlogintime)
{
using (CareCenterEntities entity = new CareCenterEntities())
{
var user = entity.tb_User.FirstOrDefault(item => item.ID == userid);
if (user != null)
{
user.LastLognTime = lastlogintime; //时间
entity.Entry(user).State = System.Data.Entity.EntityState.Modified; //修改登录时间
entity.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// 修改登录时间
/// </summary>
/// <param name="adminid"></param>
/// <returns></returns>
public static int UpdateLastDateTime(string adminid)
{
using (CareCenterEntities entity = new CareCenterEntities())
{
var admin = entity.tb_Admins.FirstOrDefault(item => item.AdminID == adminid || item.Mobile == adminid);
if (admin != null)
{
admin.LastLoginTime = DateTime.Now;
entity.Entry(admin).State = System.Data.Entity.EntityState.Modified;
entity.SaveChanges();
return(1);
}
else
{
return(-1);
}
}
}
/// <summary>
/// 验证管理员登录信息
/// </summary>
/// <param name="adminid"></param>
/// <returns></returns>
public static bool ChkAdminInfo(string adminid, string admipwd)
{
using (CareCenterEntities entity = new CareCenterEntities())
{
var admin = entity.tb_Admins.Where(item => item.AdminPwd == admipwd && item.Status == 1).ToList();
if (adminid.Length == 11)
{
admin = admin.Where(item => item.Mobile == adminid).ToList();
}
else
{
admin = admin.Where(item => item.AdminID == adminid).ToList();
}
if (admin.Count > 0)
{
return(true);
}
return(false);
}
}
