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