public void DeleteTable(int id)
{
BTable btable = new BTable(id);
TableController tableController = new TableController();
tableController.DeleteTable(btable);
}
public void CreateTable(int seats, bool reserved)
{
BTable btable = new BTable(seats, reserved);
TableController tableController = new TableController();
tableController.CreateTable(btable);
}
public void UpdateTable(int id, int seats, bool reserved)
{
BTable btable = new BTable(id, seats, reserved);
TableController tableController = new TableController();
tableController.UpdateTable(btable);
}
public void Render(RenderTreeBuilder renderTreeBuilder, RenderConfig config)
{
List <KeyValueModel> tableDataSource = new List <KeyValueModel>();
var attributeConfig = (TableAttribute)config.ControlAttribute;
renderTreeBuilder.OpenComponent(0, config.InputControlType);
renderTreeBuilder.AddAttribute(1, nameof(BFormItemObject.EnableAlwaysRender), true);
renderTreeBuilder.AddAttribute(2, nameof(BTable.AutoGenerateColumns), true);
renderTreeBuilder.AddAttribute(3, nameof(BTable.DataType), typeof(KeyValueModel));
if (attributeConfig != null)
{
renderTreeBuilder.AddAttribute(4, nameof(BTable.Height), attributeConfig.Height);
renderTreeBuilder.AddAttribute(5, nameof(BTable.IsEditable), attributeConfig.IsEditable);
if (attributeConfig.IsEditable)
{
renderTreeBuilder.AddAttribute(6, nameof(BTable.DataType), typeof(KeyValueModel));
if (config.Page == null)
{
ExceptionHelper.Throw(ExceptionHelper.CascadingValueNotFound, "表格启用可编辑功能后必须在外面套一层 CascadingValue，值为 this，名称为 Page");
}
renderTreeBuilder.AddAttribute(7, nameof(BTable.OnSave), EventCallback.Factory.Create <TableSaveEventArgs>(config.Page, DefaultSaverAsync));
}
}
renderTreeBuilder.AddAttribute(8, nameof(BTable.DataSourceChanged), EventCallback.Factory.Create <object>(this, dataSource =>
{
tableDataSource = (List <KeyValueModel>)dataSource;
config.EditingValue = dataSource;
}));
renderTreeBuilder.AddAttribute(9, nameof(BTable.DataSource), tableDataSource);
renderTreeBuilder.AddComponentReferenceCapture(10, table => currentTable = (BTable)table);
renderTreeBuilder.CloseComponent();
}
/// <summary>
/// 初始化数据库信息
/// </summary>
/// <returns>结果</returns>
public Result InitDatabaseInfo()
{
Result result = new Result();
try
{
var conInfo = new BConString().GetConString(this.TaskInfo.BusinessKeyID);
if (string.IsNullOrWhiteSpace(conInfo?.KeyID))
{
result.Msg = "获取当前任务信息失败";
return(result);
}
IDBOperator op = new DBOperator();
////获取数据库连接
SqlSugarClient client = null;
///根据链接获取此链接下所有数据库
var dataBases = op.GetAllDataBase(conInfo.ConnectionString, ref client);
///根据数据库获取所有表
if (dataBases == null || dataBases.Count == 0)
{
result.Msg = "当前链接没有数据库";
result.Success = true;
return(result);
}
Dictionary <string, List <Table> > dBAndTables = new Dictionary <string, List <Table> >();
////这里表多了会不会超时，待处理
foreach (var item in dataBases)
{
Thread.Sleep(100);
dBAndTables.Add(item, op.GetAllTables(item, client));
}
///根据规则判断表的生成规则，并生成tables的表信息
var tables = this.BuildTableModel(dBAndTables, conInfo);
var res = new BTable().AddTableBatch(tables);
////筛选需要定期建表的
var cycleTables = tables.FindAll(p => p.SplitType != SplitType.None && p.SplitType != SplitType.HASH);
List <DBTask> tasks = new List <DBTask>();
cycleTables.ForEach(p => tasks.Add(new DBTask()
{
BusinessKeyID = p.TabelKeyID, BusinessType = BusinessType.表建表
}));
var insertRes = new BTask().AddTasks(tasks);
if (insertRes.Success)
{
this.TaskInfo.NextExecuteTime = DateTime.Now.AddDays(1);
}
return(insertRes);
}
catch (Exception e)
{
NLog.LogManager.GetCurrentClassLogger().Error($"{e}");
result.Msg = e.Message;
}
return(result);
}
public void DeleteTable(BTable bTable)
{
using (SqlConnection connection = new SqlConnection(_connectionString))
{
connection.Open();
using (SqlCommand cmdDeleteTable = connection.CreateCommand())
{
cmdDeleteTable.CommandText = "delete from BTable where id = @id";
cmdDeleteTable.Parameters.AddWithValue("Id", bTable.Id);
cmdDeleteTable.ExecuteNonQuery();
}
}
}
public void CreateTable(BTable bTable)
{
using (SqlConnection connection = new SqlConnection(_connectionString))
{
connection.Open();
using (SqlCommand cmdInsertProd = connection.CreateCommand())
{
cmdInsertProd.CommandText = "INSERT INTO BTable(Seats, Reserved) VALUES(@Seats, @Reserved)";
cmdInsertProd.Parameters.AddWithValue("Seats", bTable.Seats);
cmdInsertProd.Parameters.AddWithValue("Reserved", bTable.Reserved);
cmdInsertProd.ExecuteNonQuery();
}
}
}
public void UpdateTable(BTable bTable)
{
using (SqlConnection connection = new SqlConnection(_connectionString))
{
connection.Open();
using (SqlCommand cmdUpdateTable = connection.CreateCommand())
{
cmdUpdateTable.CommandText = "update BTable set seats = @Seats, reserved = @Reserved where id = @id";
cmdUpdateTable.Parameters.AddWithValue("Id", bTable.Id);
cmdUpdateTable.Parameters.AddWithValue("Seats", bTable.Seats);
cmdUpdateTable.Parameters.AddWithValue("Reserved", bTable.Reserved);
cmdUpdateTable.ExecuteNonQuery();
}
}
}
public List <BTable> GetAllFreeTables()
{
List <BTable> tables = new List <BTable>();
BTable tempT;
using (SqlConnection connection = new SqlConnection(_connectionString)) {
connection.Open();
using (SqlCommand cmd = connection.CreateCommand()) {
cmd.CommandText = "select Id, Seats, Reserved from BTable where reserved = 'false'";
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
tempT = new BTable();
tempT.Id = reader.GetInt32(reader.GetOrdinal("Id"));
tempT.Seats = reader.GetInt32(reader.GetOrdinal("Seats"));
tempT.Reserved = reader.GetBoolean(reader.GetOrdinal("Reserved"));
tables.Add(tempT);
}
}
}
return(tables);
}
public BTable GetMainTable(int user_id,int shift_id)
{
BTable res = new BTable();
_cmd = CreateCommand("GetMainTable");
_param = CreateParameter("@user_id", DbType.Int32, 4);
_param.Value = user_id;
_cmd.Parameters.Add(_param);
_param = CreateParameter("@shift_id", DbType.Int32, 4);
_param.Value = shift_id;
_cmd.Parameters.Add(_param);
_DR = ExecuteDataReader(_cmd.ExecuteReader);
while (_DR.Read())
{
BureaRecord br = new BureaRecord();
string address = _DR["address"].ToString();
br = res.GetRecordByAddress(address);
if (br.Address == "-1")
{
br.Address = address;
br.RegisterDate = (DateTime)_DR["created_Date"];
}
if (_DR["reg_time"] != DBNull.Value)
br.RegisterTime = ((DateTime)_DR["reg_time"]).ToShortTimeString();
br.card_id = (int)_DR["card_id"];
br.DeadFIO = _DR["dead_fio"].ToString();
if (_DR["Avans"] != DBNull.Value)
br.Avans = (double)_DR["Avans"];
else
br.Avans = 0;
br.Transport = _DR["transport"].ToString();
br.Agent = _DR["agent_name"].ToString();
br.ShiftId = (int)_DR["shift_id"];
br.PhoneNumber = _DR["phone_number"].ToString();
br.Comments = _DR["Comments"].ToString();
br.Result = _DR["Result"].ToString();
br.Office = _DR["office_name"].ToString();
if (_DR["viewed"] != DBNull.Value)
br.IsCardViewed = true;
else
br.IsCardViewed = false;
res.Add(br);
}
_DR.Close();
return res;
}
public Result ExecuteTableCreateTables()
{
Result result = new Result();
TableInfo tableInfo = null;
try
{
tableInfo = new BTable().GetTableByKeyId(this.TaskInfo.BusinessKeyID)?.Data;
if (string.IsNullOrWhiteSpace(tableInfo?.TabelKeyID))
{
result.Msg = "获取表信息失败";
return(result);
}
var conInfo = new BConString().GetConString(tableInfo?.ConStringKeyID);
if (string.IsNullOrWhiteSpace(conInfo?.KeyID) || string.IsNullOrWhiteSpace(conInfo?.ConnectionString))
{
result.Msg = "获取链接信息失败";
return(result);
}
IDBOperator op = new DBOperator();
var con = ConnectionHelper.GetSqlSugarClientByConString(conInfo.ConnectionString);
var ddl = op.GetTableDDL(tableInfo.DatabaseName, tableInfo.MaxTableName, con);
string nexttable = this.GetNextTableName(tableInfo.SplitType, tableInfo.Format);
string use = $" use {tableInfo.DatabaseName};";
string createRes = use + ddl.Replace(tableInfo.MaxTableName, $"{tableInfo.TableName}{nexttable}");
var res = op.ExecuteSql(createRes, con);
if (res)
{
tableInfo.MaxTableName = $"{ tableInfo.TableName}{ nexttable}";
var upRes = new BTable().UpdateTableByKeyId(tableInfo);
if (upRes.Success == false)
{
result.Msg = "更新最大表失败";
return(result);
}
}
result.Success = res;
return(result);
}
catch (Exception e)
{
NLog.LogManager.GetCurrentClassLogger().Error(e);
result.Msg = e.Message;
if (e.Message.Contains("already exists"))
{
result.Success = true;
result.Msg = string.Empty;
}
return(result);
}
finally
{
if (result.Success)
{
this.TaskInfo.NextExecuteTime = this.GetNextExecuteTime(tableInfo.SplitType);
}
}
}
public void DeleteTable(BTable btable)
{
DBTable dBTable = new DBTable();
dBTable.DeleteTable(btable);
}
public void UpdateTable(BTable btable)
{
DBTable dBTable = new DBTable();
dBTable.UpdateTable(btable);
}
public void CreateTable(BTable btable)
{
DBTable dBTable = new DBTable();
dBTable.CreateTable(btable);
}
