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