public OutputPin(SimulationEngine engine, int dataBitWidth)
: base(engine)
{
this.DataBitWidth = dataBitWidth;
this.In = new ReadConnection(this.DataBitWidth);
this.In.DataValueChanged += this.OnInputDataValueChanged;
}
public override Task <IEnumerable <TEntity> > GetAllListAsync()
{
using (ReadConnection)
{
return(ReadConnection.GetAllAsync <TEntity>());
}
}
public async Task <List <People> > GetPeoples()
{
string sql = "Select * From people";
var peoples = ReadConnection.Query <People>(sql).ToList();
return(peoples);
}
public override Task <TEntity> GetAsync(TPrimaryKey id)
{
using (ReadConnection)
{
return(ReadConnection.GetAsync <TEntity>(id));
}
}
public async Task ImportExcel(Queue <DriverVM> listModel)
{
try
{
if (listModel != null && listModel.Count > 0)
{
//Encoding.RegisterProvider(CodePagesEncodingProvider.Instance);
//MySqlConnection con = new MySqlConnection("server=192.168.1.208;userid=root;pwd=lyh888150;database=ccp(latest);sslmode=none;");
foreach (var item in listModel)
{
string sql = $"select * from aspnetusers where PhoneNumber={item.PhoneNumber}";
var user = new Aspnetusers();
using (ReadConnection)
{
user = await ReadConnection.QueryFirstOrDefaultAsync <Aspnetusers>(sql);
}
if (user != null)
{
if (user.UserCategory != UserCategory.JFEmployees)
{
user.UserCategory = UserCategory.JFEmployees;
using (WriteConnection)
{
await WriteConnection.UpdateAsync(user);
}
}
}
else
{
var newuser = new Aspnetusers()
{
PhoneNumber = item.PhoneNumber,
UserName = item.PhoneNumber,
CertificatePhotoCertificationState = CertificationStatus.Uncommitted,
DrivingLicenseKeyCertificationState = CertificationStatus.Uncommitted,
IdentityCardCertificationState = CertificationStatus.Uncommitted,
LockoutEnabled = true,
RealNameStatus = CertificationStatus.Uncommitted,
CertificationStatus = CertificationStatus.Uncommitted,
TrailerLicenseCertificationStatus = CertificationStatus.Uncommitted,
VehiclePhotoCertificationStatus = CertificationStatus.Uncommitted,
RoleType = ApplicationRoleType.Driver,
RoadTransportStatus = CertificationStatus.Uncommitted,
Date = DateTime.Now,
UserCategory = UserCategory.JFEmployees
};
using (WriteConnection)
{
await WriteConnection.InsertAsync(newuser);;
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <Tuple <List <MaintenanceInfoResponse>, int> > GetPageListAsync(MaintenanceInfoPageRequest request)
{
StringBuilder sbSql = new StringBuilder();
StringBuilder sbCount = new StringBuilder();
DynamicParameters parameters = new DynamicParameters();
sbSql.Append(@" SELECT * FROM maintenanceinfo m
LEFT JOIN servicebusiness s ON m.RepairId = s.Id
LEFT JOIN attachment a ON m.Id = a.DataId AND a.IsDeleted = 0 AND a.DataType = 1
WHERE 1=1 ");
sbCount.Append(" SELECT COUNT(*) FROM maintenanceinfo m WHERE 1=1 ");
var where = this.GetWhere(request, parameters);
if (where?.Item1?.Length > 0)
{
sbSql.Append(where.Item1);
sbCount.Append(where.Item1);
}
//添加排序
sbSql.Append(" Order By m.CreationTime DESC ");
if (request.Count.HasValue && request.Count.Value > 0)
{
sbSql.Append(" LIMIT @Skip,@Count ");
parameters.Add("@Skip", request.Skip.Value);
parameters.Add("@Count", request.Count.Value);
}
using (ReadConnection)
{
var lookup = new Dictionary <Guid, MaintenanceInfoResponse>();
var query = ReadConnection.Query <MaintenanceInfoResponse, ServiceBusiness, Attachment, List <MaintenanceInfoResponse> >(sbSql.ToString(), (a, c, b) =>
{
if (!lookup.Keys.Contains(a.Id))
{
if (a != null && c != null)
{
a.ServiceBusiness = c;
}
lookup.Add(a.Id, a);
if (lookup[a.Id].Attachments == null)
{
lookup[a.Id].Attachments = new List <Attachment>();
}
lookup[a.Id].Attachments.Add(b);
}
else
{
lookup[a.Id].Attachments.Add(b);
}
return(lookup.Values.ToList());
}, parameters);
int r2 = 0;
if (request.Count.HasValue && request.Count.Value > 0)
{
r2 = await ReadConnection.QueryFirstAsync <int>(sbCount.ToString(), parameters);
}
return(new Tuple <List <MaintenanceInfoResponse>, int>(lookup.Values.ToList(), r2));
}
}
public Probe(SimulationEngine engine, int dataBitWidth)
: base(engine)
{
this.DataBitWidth = dataBitWidth;
this.DataValue = DataValue.Floating(this.DataBitWidth);
this.In = new ReadConnection(this.DataBitWidth);
this.In.DataValueChanged += this.OnInputDataValueChanged;
}
public void Join(string channel)
{
ReadConnection.WriteLine("JOIN " + channel);
if (!SingleConnection)
{
WriteConnection.WriteLine("JOIN " + channel);
}
}
public void Reconnect()
{
ReadConnection.Reconnect();
if (!SingleConnection)
{
WriteConnection.Reconnect();
}
}
public void Part(string channel)
{
ReadConnection.WriteLine("PART " + channel);
if (!SingleConnection)
{
WriteConnection.WriteLine("PART " + channel);
}
}
public void Connect(string username, string password)
{
ReadConnection.Connect(username, password);
if (!SingleConnection)
{
WriteConnection.Connect(username, password);
}
}
public void Disconnect()
{
ReadConnection.Dispose();
if (!SingleConnection)
{
WriteConnection.Dispose();
}
}
public async Task <List <Users> > GetUsers()
{
using (ReadConnection)
{
string sql = @"select * from Users;";
var res = await ReadConnection.QueryAsync <Users>(sql);
return(res.ToList());
}
}
private IModel GetOrCreateChannel(string @event)
{
if (SubscribeChannels.TryGetValue(@event, out var channel))
{
return(channel);
}
var createChannel = ReadConnection.CreateModel();
SubscribeChannels.TryAdd(@event, createChannel);
return(createChannel);
}
/// <summary>
/// Disconnect disconnects the Client from the Amqp Server.
/// </summary>
/// <param name="code">The status code of the disconnect.</param>
/// <param name="text">The status text of the disconnect.</param>
public void Disconnect(ushort code, string text)
{
lock (PublishChannel)
{
PublishChannel.Close(code, text);
}
foreach (var value in SubscribeChannels.Values)
{
value.Close();
}
WriteConnection.Close(code, text);
ReadConnection.Close(code, text);
}
public async Task <UserInfo> FindByLoginKeyAsync(string keyWord)
{
DynamicParameters param = new DynamicParameters();
string sql = @"select * from userinfo
where PhoneNumber=@keyWord or Email=@KeyWord";
param.Add("@keyWord", keyWord);
param.Add("@KeyWord", keyWord);
using (ReadConnection)
{
var result = await ReadConnection.QueryFirstOrDefaultAsync <UserInfo>(sql, param);
return(result);
}
}
public async Task <UserDO> Login(string username, string password)
{
StringBuilder sql = new StringBuilder();
sql.Append("select * from ums_user u where u.enabled=1 and u.username=@username and u.password=@password");
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@username", username);
parameters.Add("@password", password);
using (ReadConnection)
{
var result = await ReadConnection.QueryAsync <UserDO>(sql.ToString(), parameters);
return(result.FirstOrDefault());
}
}
public async Task <int> GetCodeTotalCount(string tableName, string paramName)
{
int totalCount = 0;
StringBuilder codeSql = new StringBuilder();
codeSql.AppendFormat("SELECT {0} FROM {1} WHERE CreationTime >= @TodayStart AND CreationTime < @TodayEnd ORDER BY {0} DESC LIMIT 0,1;", paramName, tableName);
DateTime TodayStart = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
DateTime TodayEnd = TodayStart.AddDays(1);
var list = ReadConnection.Query <string>(codeSql.ToString(), new { TodayStart = TodayStart, TodayEnd = TodayEnd }).ToList();
if (list?.Count > 0)
{
totalCount = int.Parse(list.FirstOrDefault().Substring(7, 4));
}
return(totalCount);
}
public async override Task <Tuple <int, IList <TEntity> > > GetListAsync(IQueryObject <TEntity> query)
{
var parameters = new DynamicParameters();
var select = ExpressionHelper.Select <TEntity>();
var count = ExpressionHelper.Count <TEntity>();
foreach (var where in query.QueryExpression)
{
select.Where(where);
}
foreach (var where in query.QueryExpression)
{
count.Where(where);
}
select.Where(x => x.IsDeleted == false);
count.Where(x => x.IsDeleted == false);
if (query.OrderSort == SortOrder.ASC)
{
select.OrderBy(query.OrderField);
}
else if (query.OrderSort == SortOrder.DESC)
{
select.OrderByDesc(query.OrderField);
}
else
{
select.OrderByDesc(x => x.CreationTime);
}
if (query.Count >= 0)
{
select.Limit(query.Skip, query.Count);
}
foreach (KeyValuePair <string, object> item in select.DbParams)
{
parameters.Add(item.Key, item.Value);
}
using (Connection)
{
var customerRepresentativeList = await ReadConnection.QueryAsync <TEntity>(select.Sql, parameters);
int totalCount = await ReadConnection.QuerySingleAsync <int>(count.Sql, parameters);
return(new Tuple <int, IList <TEntity> >(totalCount, customerRepresentativeList.ToList()));
}
}
public async Task <List <MachineryInfo> > GetListAsync(MachineryInfoSearchRequest request)
{
StringBuilder sbSql = new StringBuilder();
DynamicParameters parameters = new DynamicParameters();
sbSql.Append(" SELECT * FROM machineryinfo WHERE IsDeleted = 0 ");
var where = this.GetWhere(request, parameters);
if (where?.Item1?.Length > 0)
{
sbSql.Append(where.Item1);
}
//添加排序
sbSql.Append(" Order By CreationTime DESC ");
using (ReadConnection)
{
var r1 = await ReadConnection.QueryAsync <MachineryInfo>(sbSql.ToString(), parameters);
return(r1.ToList());
}
}
/// <summary>
/// 根据查询条件查询总数
/// </summary>
/// <param name="query">查询对象</param>
/// <returns></returns>
public override async Task <int> CountAsync(IQueryObject <TEntity> query)
{
var parameters = new DynamicParameters();
var count = ExpressionHelper.Count <TEntity>();
foreach (var where in query.QueryExpression)
{
count.Where(where);
}
foreach (KeyValuePair <string, object> item in count.DbParams)
{
parameters.Add(item.Key, item.Value);
}
using (ReadConnection)
{
var Count = await ReadConnection.QuerySingleAsync <int>(count.Sql, parameters);
return(Count);
}
}
public override async Task <Tuple <int, IList <GoodsInfo> > > GetListAsync(IQueryObject <GoodsInfo> query)
{
StringBuilder sb = new StringBuilder();
sb.Append("select g.*, u.* from goodsinfo g LEFT JOIN userinfo u ON g.UserId=u.Id WHERE 1=1 and g.IsDelete=0 ");
StringBuilder sbCount = new StringBuilder();
sbCount.Append("select COUNT(g.Id) from goodsinfo g LEFT JOIN userinfo u ON g.UserId=u.Id WHERE 1=1 and g.IsDelete=0 ");
var queryandsort = query.QuerySql.FirstOrDefault();
if (query.QuerySql.Count > 0)
{
sb.Append(queryandsort.Key);
sbCount.Append(queryandsort.Key);
}
if (query.Count <= 0)
{
query.Count = int.MaxValue;
}
sb.Append(" LIMIT " + query.Skip + "," + query.Count);
using (ReadConnection)
{
var GoodsList = await ReadConnection.QueryAsync <GoodsInfo, UserInfo, GoodsInfo>(sb.ToString(), (goodsinfo, usersinfo) =>
{
if (goodsinfo != null)
{
goodsinfo.UserInfo = usersinfo;
}
return(goodsinfo);
}, queryandsort.Value);
int totalCount = await ReadConnection.QuerySingleAsync <int>(sbCount.ToString(), queryandsort.Value);
return(new Tuple <int, IList <GoodsInfo> >(totalCount, GoodsList.ToList()));
}
}
public void ReadConnection()
{
var bitWidth = 2;
var connection = new ReadConnection(bitWidth);
}