public TruckBM(IDapperHelper daper, IDbHelper DbHelper) { _daper = daper; _DbHelper = DbHelper; _TruckDA = new TruckDA(_daper); logging = new Logging(_DbHelper); }
public bool AuthorizeEmployee(string userId, string password) { using (IDapperHelper dapper = DapperHelper.GetInstance()) { var trans = dapper.BeginTransaction(); try { using (IRepository repo = new Repository()) { var user = repo.Query <User>(x => x.Password == Encrypt.GetMd5Hash(password)).Find(x => x.IsActive && (x.UserName.Equals(userId, StringComparison.OrdinalIgnoreCase) || x.EmployeeNo.Equals(userId, StringComparison.OrdinalIgnoreCase))); if (user != null) { user.LastLoginDate = DateTime.Now; repo.Update(user); trans.Commit(); return(SetSession(user.ID)); } } } catch { trans.Rollback(); } } return(false); }
public ProjectQueries( IDapperHelper dapper, RedisClient redisClient) { _dapperHelper = dapper; _redisClient = redisClient; }
protected void Logging(string logger, DateTime createTime, LogLevel level, string message, string stackTrace, UserClientInfo userClient = null, IDbTransaction trans = null) { var sql = @"INSERT INTO {0} (Logger, CreateTime, LogLevel, Message, IsException, StackTrace, Thread, Method, UserID, UserIP, UserBrowser, UserOS) VALUES (@logger, @createTime, @logLevel, @message, @isException, @stackTrace, @thread, @method, @userID, @userIP, @userBrowser, @userOS)"; sql = string.Format(sql, Repository.GetTableAttr <Log>().Name); SqlParameter[] para = { new SqlParameter("@logger", logger), new SqlParameter("@createTime", createTime), new SqlParameter("@logLevel", level.ToString()), new SqlParameter("@message", message), new SqlParameter("@isException", !string.IsNullOrEmpty(stackTrace)), new SqlParameter("@stackTrace", stackTrace), new SqlParameter("@thread", string.Empty), new SqlParameter("@method", string.Empty), new SqlParameter("@userID", userClient?.UserID ?? -1), new SqlParameter("@userIP", userClient != null ? userClient.UserIP : "127.0.0.1"), new SqlParameter("@userBrowser", userClient != null ? userClient.UserBrowser : string.Empty), new SqlParameter("@userOS", userClient != null ? userClient.UserOS : string.Empty) }; // no logging method using (IDapperHelper dapper = DapperHelper.GetInstance()) { dapper.Execute(sql, para.ToDapperParameters(), null, ignoreLog: true); } }
public void JArray_GetValue_Test() { // { "UserId":"xudanfu1015","DeviceId":"c90af29b945abf19b1a3cace63ac9d45"} // user: { "errcode":0,"errmsg":"ok","userid":"xudanfu1015","name":"徐旦复","department":[34],"position":"系统开发主任","mobile":"13482045112", // "gender":"1","avatar":"http:\/\/shp.qpic.cn\/bizmp\/sfQa6NT594Qm6CnIQicHUTLTDCib0QlmdrlfI3GIsLxknRhBYc7JFb2Q\/","status":1, // "extattr":{"attrs":[{"name":"班组","value":"信息技术组"},{"name":"出生年月","value":"198509"},{"name":"政治面貌","value":"中共党员"},{"name":"工号","value":"1015"},{"name":"座机","value":""},{"name":"英文名","value":"xudanfu"}]}} var sql = "SELECT ConfigValue FROM Shsict_Config WHERE(ConfigSystem = 'Reservation') AND(ConfigKey = 'JsonDebug')"; using (IDapperHelper dapper = DapperHelper.GetInstance()) { var result = dapper.ExecuteScalar(sql).ToString(); var json = JToken.Parse(result); var errcode = json["errcode"].Value <int>(); var errmsg = json["errmsg"].Value <string>(); var userid = json["userid"].Value <string>(); var name = json["name"].Value <string>(); var department = json["department"].Value <JArray>(); var position = json["position"].Value <string>(); var mobile = json["mobile"].Value <string>(); var gender = json["gender"].Value <string>(); var avatar = json["avatar"].Value <string>(); var status = json["status"].Value <int>(); var extattr = json["extattr"].Value <JToken>(); var attrs = extattr?["attrs"].Value <JArray>(); var userdict = new Dictionary <string, string>(); if (attrs?.Count > 0) { foreach (var kvp in attrs) { userdict.Add(kvp["name"].Value <string>(), kvp["value"].Value <string>()); } } Assert.AreEqual(errcode, 0); Assert.AreEqual(errmsg, "ok"); Assert.AreEqual(userid, "xudanfu1015"); Assert.AreEqual(name, "徐旦复"); Assert.AreEqual(department[0].Value <int>(), 34); Assert.AreEqual(position, "系统开发主任"); Assert.AreEqual(mobile, "13482045112"); Assert.AreEqual(gender, "1"); Assert.AreEqual(avatar, "http://shp.qpic.cn/bizmp/sfQa6NT594Qm6CnIQicHUTLTDCib0QlmdrlfI3GIsLxknRhBYc7JFb2Q/"); Assert.AreEqual(status, 1); Assert.IsTrue(userdict.Count > 0); Assert.AreEqual(userdict["班组"], "信息技术组"); Assert.AreEqual(userdict["出生年月"], "198509"); Assert.AreEqual(userdict["政治面貌"], "中共党员"); Assert.AreEqual(userdict["工号"], "1015"); Assert.AreEqual(userdict["座机"], ""); Assert.AreEqual(userdict["英文名"], "xudanfu"); } }
/// <summary> /// 获取单例 /// </summary> /// <returns></returns> public static IDapperHelper GetInstance() { if (dapperHelperInstance == null) { lock (locker) { if (dapperHelperInstance == null) { dapperHelperInstance = new DapperHelper(); } } } return(dapperHelperInstance); }
public ReportViewFactory(IDapperHelper dapper = null) { _dapper = dapper ?? DapperHelper.GetInstance(); ViewerSql = @"SELECT dp.DeliveryGuid, dp.DeliveryName, o.StapleFood, o.ExtraFood, COUNT(o.ID) AS OrderCount, m.ID, m.MenuDate, m.MenuType, m.MenuFlag, m.Meat, m.MeatSmall, m.Vegetable1, m.Vegetable2 FROM Reservation_Order AS o INNER JOIN Reservation_Menu AS m ON o.MenuID = m.ID AND m.IsActive = 1 AND m.IsApproved =1 LEFT OUTER JOIN Reservation_Delivery AS d ON o.DeliveryGuid = d.DeliveryGuid AND d.IsActive = 1 LEFT OUTER JOIN Reservation_Delivery AS dp ON d.ParentID = dp.DeliveryGuid AND d.IsActive = 1 WHERE (o.IsActive = 1) GROUP BY dp.DeliveryGuid, dp.DeliveryName, o.StapleFood, o.ExtraFood, m.ID, m.MenuDate, m.MenuType, m.MenuFlag, m.Meat, m.MeatSmall, m.Vegetable1, m.Vegetable2"; SplitOn = "DeliveryGuid, ID"; DbSchema = Repository.GetTableAttr <ReportView>(); }
public OrderViewFactory(IDapperHelper dapper = null) { _dapper = dapper ?? DapperHelper.GetInstance(); ViewerSql = @"SELECT o.ID AS OrderID, o.StapleFood, o.ExtraFood, o.CreateTime AS PlaceTime, o.CreateUser AS PlaceUser, u.UserGuid, u.UserName, u.EmployeeName, u.EmployeeNo, m.*, d.DeliveryGuid, d.DeliveryName, d.ParentID FROM Reservation_Order AS o LEFT OUTER JOIN Shsict_User AS u ON o.UserGuid = u.UserGuid LEFT OUTER JOIN Reservation_Menu AS m ON o.MenuID = m.ID LEFT OUTER JOIN Reservation_Delivery AS d ON o.DeliveryGuid = d.DeliveryGuid WHERE (o.IsActive = 1) "; SplitOn = "OrderID, UserGuid, ID, DeliveryGuid"; DbSchema = Repository.GetTableAttr <OrderView>(); }
public async Task CheckUserNameAsync(IDapperHelper db) { if (USER_NAME.IndexOfAny(new char[] { ' ' }) > -1) { throw new Exception("사용할수 없는 문자가 존재합니다"); } if (USER_NAME.In("관리자", "운영자")) { throw new Exception("사용할수 없는 닉네임이 존재합니다"); } //사용중인 UserName 확인 if ((await db.GetQueryFromXmlAsync <int>("User.xml", "GetCheckUserName", this)).FirstOrDefault() > 0) { throw new Exception("이미 사용중인 닉네임 입니다"); } }
internal async Task <int> SignUpAsync(IDapperHelper db) { EMAIL = EmailReplace(EMAIL); if (EMAIL.IsNull()) { throw new Exception("이메일을 정확히 입력해주세요"); } if (PASSWORD.IsNull()) { throw new Exception("비밀번호를 정확히 입력해주세요"); } if (USER_NAME.IsNull()) { throw new Exception("닉네임을 정확히 입력해주세요"); } EMAIL = EMAIL.Trim(); PASSWORD = PASSWORD.Trim(); USER_NAME = USER_NAME.Trim(); if (PASSWORD.Length < 8) { throw new Exception("비밀번호를 8자이상 입력해주세요"); } //이메일 중복 확인 if ((await db.GetQueryFromXmlAsync <int>("User.xml", "GetCheckEmail", this)).FirstOrDefault() > 0) { throw new Exception("이미 사용중인 이메일 입니다"); } await CheckUserNameAsync(db); //U_ID 가져옴 this.U_ID = (await db.GetQueryFromXmlAsync <uint>("User.xml", "GetSignUp_Uid", new { })).FirstOrDefault(); //PASSWORD 암호화 PASSWORD = HMacSha256.GetHMac(PASSWORD, U_ID.ToString()); //Insert return(await db.ExecuteFromXmlAsync("User.xml", "InsertSignUp", this)); }
public ActionResult MenuDelete(MenuDto model) { if (ModelState.IsValid) { using (IDapperHelper dapper = DapperHelper.GetInstance()) { var trans = dapper.BeginTransaction(); try { if (model.ID > 0 && _repo.Delete <Menu>(model.ID) > 0) { var list = _repo.Query <Order>(x => x.MenuID == model.ID); if (list != null && list.Count > 0) { foreach (var o in list) { o.IsActive = false; } } list.Update(); trans.Commit(); Entities.Menu.Cache.RefreshCache(); return(RedirectToAction("MenuManagement", "Console")); } } catch (Exception ex) { trans.Rollback(); ModelState.AddModelError("Warn", ex.Message); } } } return(RedirectToAction("Menu", "Console", new { model.ID })); }
public MessageNotification(IDapperHelper dapperHelper, IErrorServices errorServices) { this.dapperHelper = dapperHelper; this.errorServices = errorServices; }
public Repository(IDapperHelper dapper = null) { _dapper = dapper ?? DapperHelper.GetInstance(); }
public UserRepository(IDapperHelper dbHelper) { _dbHelper = dbHelper; }
public BaseService(IDapperHelper dapperHelper) { _dapperHelper = dapperHelper; }
/// <summary> /// 释放资源 /// </summary> public void Dispose() { dbHelper = null; }
public ProductRepository(ApplicationDbContext context, IDapperHelper dapperHelper) : base(context) { this.dapperHelper = dapperHelper; }
public EmployeeService(IDapperHelper dapperHelper) { this._dapperHelper = dapperHelper; }
public EngineInfoService(IDapperHelper dapperHelper) { this._dapperHelper = dapperHelper; }
public LoginController(IUserInfo loginUser, IDapperHelper db) { _user = loginUser; _db = db; }
public BidRepository(IDapperHelper dapperHelper) { this.dapperHelper = dapperHelper; }
public TaskListServices() { _dapperHelper = new DapperHelper(); }
public ProductManager(IDapperHelper dapperHelper, IRedisHelper redisHelper) { this.dapperHelper = dapperHelper; this.redisHelper = redisHelper; }
/// <summary> /// Initializes a new instance of the <see cref="BaseRepository"/> class. /// </summary> /// <param name="databaseConstants">The database constants.</param> public BaseRepository(IDatabaseConstants databaseConstants) { this.DatabaseConstants = databaseConstants; this.DapperHelper = new DapperHelper("API", "API-DeptEmp"); }
public CollegeService(IDapperHelper dapperHelper) { this._dapperHelper = dapperHelper; }
public JobService(IDapperHelper dapperHelper) { this._dapperHelper = dapperHelper; }
public UserRepository(IDapperHelper dapperHelper) { this.dapperHelper = dapperHelper; }
/// <summary> /// 构造 /// </summary> public BaseModel(bool newInstance = false) { dbHelper = newInstance ? DapperHelper.GetNewInstance() : DapperHelper.GetInstance(); }
public CharacteristicRepository(IDapperHelper dapperHelper) { this.dapperHelper = dapperHelper; }
public HeaderRepository(IDapperHelper dapperHelper, IMessageRepository messageRepository) { this.dapperHelper = dapperHelper; this.messageRepository = messageRepository; }
public DepartmentService(IDapperHelper dapperHelper) { this._dapperHelper = dapperHelper; }