static void Main(string[] args)
{
Base_UserBusiness base_UserBusiness = new Base_UserBusiness();
base_UserBusiness.Service.GetDbContext().Database.Log = log =>
{
Console.WriteLine(log);
};
//筛选角色名为“超级管理员”的人员
string roleName = "超级管理员";
var q = (from a in base_UserBusiness.Service.GetIQueryable <Base_User>()
join b in base_UserBusiness.Service.GetIQueryable <Base_UserRoleMap>() on a.UserId equals b.UserId
join c in base_UserBusiness.Service.GetIQueryable <Base_SysRole>() on b.RoleId equals c.RoleId
where c.RoleName == roleName
select a).Distinct();
var data = q.ToList();
Console.WriteLine(data.ToJson());
//base_UserBusiness.GetList();
Console.WriteLine("完成");
Console.ReadLine();
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="condition">查询类型</param>
/// <param name="keyword">关键字</param>
/// <returns></returns>
public List <orderModule> GetDataList(int?special_status, string userId, string product_id, string product_name, string product_area, string start_time1, string start_time2, string create_time1, string create_time2, Pagination pagination)
{
var supplier = new Base_UserBusiness().GetIQueryable().FirstOrDefault(x => x.UserId == userId)?.Supplier;
List <DbParameter> paramters = new List <DbParameter>()
{
new MySqlParameter("@special_status", special_status),
new MySqlParameter("@product_id", product_id),
new MySqlParameter("@product_name", product_name),
new MySqlParameter("@start_time1", start_time1),
new MySqlParameter("@start_time2", start_time2),
new MySqlParameter("@create_time1", create_time1),
new MySqlParameter("@create_time2", create_time2),
new MySqlParameter("@supplier", supplier)
};
DataTable table = GetDataTableWithSql(@"SELECT o.*,
p.title productName,
m.real_name realName,
m.real_name nickName,
py.`status` payStatus
FROM `order` o
INNER JOIN product p ON o.product_id = p.Id
LEFT JOIN members m ON o.member_id = m.oppen_id
LEFT JOIN pay py ON py.order_id = o.Id
WHERE p.special_status = @special_status
AND (@product_id IS NULL OR p.Id = @product_id)
AND (@product_name IS NULL OR p.title LIKE @product_name)
AND (@start_time1 IS NULL OR o.start_time >= @start_time1)
AND (@start_time2 IS NULL OR o.start_time <= @start_time2)
AND (@create_time1 IS NULL OR o.create_time >= @create_time1)
AND (@create_time2 IS NULL OR o.create_time <= @create_time2)
AND (@supplier IS NULL OR p.supplier = @supplier)" , paramters);
return(table.ToList <orderModule>().GetPagination(pagination).ToList());
}
static void Main(string[] args)
{
Base_UserBusiness base_UserBusiness = new Base_UserBusiness();
Console.WriteLine("完成");
Console.ReadLine();
}
/// <summary>
/// 写入日志
/// </summary>
/// <param name="logContent">日志内容</param>
/// <param name="logType">日志类型</param>
public static void WriteSysLog(string logContent, EnumType.LogType logType)
{
string userName = null;
try
{
userName = Base_UserBusiness.GetCurrentUser().UserName;
}
catch
{
}
Base_SysLog newLog = new Base_SysLog
{
Id = Guid.NewGuid().ToSequentialGuid(),
LogType = logType.ToString(),
LogContent = logContent.Replace("\r\n", "<br />").Replace(" ", " "),
OpTime = DateTime.Now,
OpUserName = userName
};
Task.Run(() =>
{
try
{
LoggerFactory.GetLogger().WriteSysLog(newLog);
}
catch
{
}
});
}
/// <summary>
/// 工程领料
/// </summary>
/// <param name="theData"></param>
/// <returns></returns>
public ActionResult ProMaterial(ProMRModel theData)
{
StockOutModel stockOut = new StockOutModel();
stockOut.Id = Guid.NewGuid().ToSequentialGuid();
stockOut.ApplyNo = theData.MaterialRequisitionModel.PMR_No; //物料单编号
stockOut.StoreId = theData.StoreId; //默认仓库
stockOut.Context = theData.Picker; //领料人
stockOut.State = 0;
stockOut.OutNo = $"P-{DateTime.Now.ToString("yyMMddHHmmss.fff")}";
stockOut.OutDate = DateTime.Now;
stockOut.OutOperID = Base_UserBusiness.GetCurrentUser().UserId;
stockOut.OutType = 0;//0 工程领料单
foreach (Pro_MaterialRequisitionItem item in theData.MaterialRequisitionModel.MReqItemList)
{
Sto_StockOutItem stockOutItem = new Sto_StockOutItem();
stockOutItem.Id = Guid.NewGuid().ToSequentialGuid();
stockOutItem.OutNo = stockOut.OutNo;
stockOutItem.MatNo = item.MatNo;
stockOutItem.MatName = item.MatName;
//stockOutItem.Price = 0;
stockOutItem.GuiGe = item.GuiGe;
stockOutItem.UnitNo = item.UnitNo;
stockOutItem.Quantity = item.Quantity;
stockOut.StockOutItems.Add(stockOutItem);
}
this._sto_StockOutBusiness.ProMaterial(stockOut, theData.Picker, theData.MaterialRequisitionModel.ProCode, theData.MaterialRequisitionModel.ProName);
return(Success());
}
static void Main(string[] args)
{
Base_UserBusiness base_UserBusiness = new Base_UserBusiness();
List <string> ids = new List <string>()
{
"Admin"
};
//var list = base_UserBusiness.GetIQueryable().Where("@0.Contains(outerIt.UserId)", ids).ToList();
//List<Base_User> insertList = new List<Base_User>();
//LoopHelper.Loop(100, index =>
//{
// insertList.Add(new Base_User
// {
// Id = GuidHelper.GenerateKey(),
// UserId = GuidHelper.GenerateKey(),
// UserName = $"名字{index}",
// RealName = $"名字{index}"
// });
//});
//base_UserBusiness.Insert(insertList);
Console.WriteLine("完成");
Console.ReadLine();
}
public ActionResult UnAuditorStockIn(string ids)
{
string operName = Base_UserBusiness.GetCurrentUser().RealName;
this._sto_StockInBusiness.UnAuditorStockIn(ids.ToList <String>(), operName);
return(Success());
}
/// <summary>
/// 普通领料
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult FormNormal(string id)
{
var theData = id.IsNullOrEmpty() ? new StockOutModel()
{
OutOperID = Base_UserBusiness.GetCurrentUser().RealName
} : _sto_StockOutBusiness.GetStockOut(id);
return(View(theData));
}
/// <summary>
/// 保存
/// </summary>
/// <param name="theData">保存的数据</param>
public ActionResult SaveOutData(StockOutModel theData)
{
if (theData.Id.IsNullOrEmpty())
{
theData.OutOperID = Base_UserBusiness.GetCurrentUser().UserId;
_sto_StockOutBusiness.NormalMaterial(theData);
}
else
{
_sto_StockOutBusiness.NormalMaterial(theData);
}
return(Success());
}
/// <summary>
/// 更新用户权限缓存
/// </summary>
/// <param name="userId"><用户Id/param>
public static void UpdateUserPermissionCache(string userId)
{
string cacheKey = BuildCacheKey(userId);
List <string> permissions = new List <string>();
BaseBusiness <Base_PermissionUser> _db = new BaseBusiness <Base_PermissionUser>();
var userPermissions = _db.GetIQueryable().Where(x => x.UserId == userId).Select(x => x.PermissionValue).ToList();
var theUser = _db.Service.GetIQueryable <Base_User>().Where(x => x.UserId == userId).FirstOrDefault();
var roleIdList = Base_UserBusiness.GetUserRoleIds(userId);
var rolePermissions = _db.Service.GetIQueryable <Base_PermissionRole>().Where(x => roleIdList.Contains(x.RoleId)).GroupBy(x => x.PermissionValue).Select(x => x.Key).ToList();
var existsPermissions = userPermissions.Concat(rolePermissions).Distinct();
permissions = existsPermissions.ToList();
CacheHelper.Cache.SetCache(cacheKey, permissions);
}
static void Main(string[] args)
{
var bus = new Base_UserBusiness();
bus.Service.GetDbContext().Database.Log = log =>
{
Console.WriteLine(log);
};
var q = bus.GetIQueryable();
var list = GetSelectFields(q, new List <string> {
"Id", "UserName"
});
Console.ReadLine();
}
static void Main(string[] args)
{
Base_UserBusiness bus = new Base_UserBusiness();
bus.Service.HandleSqlLog = log =>
{
Console.WriteLine(log);
};
bus.GetDataList(null, null, new Pagination());
//bus.GetDataList(null, null, new Pagination());
//bus.GetIQueryable().OrderBy(new KeyValuePair<string,string>("Id","asc")).Skip(0).Take(30).ToList();
//bus.GetIQueryable().OrderBy(new KeyValuePair<string, string>("Id", "asc")).Skip(0).Take(30).ToList();
Console.WriteLine("完成");
Console.ReadLine();
}
static void Main(string[] args)
{
Base_UserBusiness base_UserBusiness = new Base_UserBusiness();
List <Base_User> insertList = new List <Base_User>();
LoopHelper.Loop(20, index =>
{
insertList.Add(new Base_User
{
Id = GuidHelper.GenerateKey(),
UserId = GuidHelper.GenerateKey(),
UserName = $"名字{index}",
RealName = $"名字{index}"
});
});
base_UserBusiness.Insert(insertList);
Console.WriteLine("完成");
Console.ReadLine();
}
public Base_UserController(IDbContextCore dbContext)
{
_base_UserBusiness = new Base_UserBusiness(dbContext);
}
