private void btnUpdate_Click(object sender, EventArgs e)
{
var id = Convert.ToInt32(this.dataGridView1.CurrentRow.Cells["Id"].Value);
var model = _entitys.FirstOrDefault(n => n.Id == id);
if (model == null)
{
MessageBox.Show("单据不存在");
return;
}
model.Code = model.Code + "0";
_sqliteDB.ExecuteSql("update SaleOrder set Code=@Code where Id=@Id", new { Code = model.Code, Id = id });
var items = _sqliteDB.Query <SaleOrderItem>("select * from SaleOrderItem where SaleOrderId=@Id", new { Id = id }).ToList();
if (items.Count == 0)
{
MessageBox.Show("明细为空");
return;
}
model.Items = items;
// 上传
_syncService.Send(model);
this.lblMsg.Text = model.Code + "执行完成";
}
public int ExecuteCommand(string sql)
{
return(_dbContext.ExecuteSql(sql, null));
}
private void DownloadAccount(object state)
{
MultiThreadResetEvent are = (MultiThreadResetEvent)state;
try
{
string url = string.Format("{0}/PosSync/QueryAccount?{1}", _serverUrl, BuildAccessToken());
// 下载数据
_log.Info("开始下载账户数据，请求{0}", url);
var result = HttpHelper.HttpGet(url);
if (!string.IsNullOrEmpty(result))
{
var rows = JsonConvert.DeserializeObject <List <Account> >(result);
_log.Info("已下载账户数据{0}条", rows.Count);
var sql = "INSERT INTO Account (Id,UserName,Password,StoreId,Status,RoleId,NickName)VALUES (@Id,@UserName,@Password,@StoreId,@Status,@RoleId,@NickName)";
var usql = "update Account set UserName=@UserName,Password=@Password,StoreId=@StoreId,Status=@Status,RoleId=@RoleId,NickName=@NickName where Id=@Id";
foreach (var entity in rows)
{
if (_db.ExecuteScalar <int>("select count(*) from Account where Id=@Id", new { Id = entity.Id }) > 0)
{
_db.ExecuteSql(usql, entity);
}
else
{
_db.ExecuteSql(sql, entity);
}
}
_log.Info("结束账号数据下载");
}
else
{
_log.Info("下载账号数据为空，下载失败.");
}
}
catch (Exception ex)
{
_log.Error(ex, "下载数据失败");
}
are.Set();
}
public void DownloadAccount()
{
try
{
string url = string.Format("{0}/PosSync/QueryAccount?{1}", _serverUrl, BuildAccessToken());
// 下载数据
_log.Info("开始下载账户数据，请求{0}", url);
var result = HttpHelper.HttpGet(url);
if (!string.IsNullOrEmpty(result))
{
var rows = JsonConvert.DeserializeObject <List <Account> >(result);
_log.Info("已下载账户数据{0}条", rows.Count);
var sql = @"Replace INTO Account (Id,UserName,Password,StoreId,Status,RoleId,NickName)VALUES (@Id,@UserName,@Password,@StoreId,@Status,@RoleId,@NickName)";
_db.ExecuteSql(sql, rows.ToArray());
_log.Info("结束账号数据下载");
}
else
{
_log.Info("下载账号数据为空，下载失败.");
}
}
catch (Exception ex)
{
_log.Error(ex, "下载数据失败");
}
}
