/// <summary>
/// 重置数据配置信息
/// </summary>
/// <param name="config">原始数据配置信息</param>
/// <returns>重置后的数据配置信息</returns>
public DataConfig Reset(DataConfig config)
{
//没有上下文，添加默认上下文
if (!config.ContextConfigs.Any())
{
DbContextConfig contextConfig = GetDefaultDbContextConfig();
config.ContextConfigs.Add(contextConfig);
}
return(config);
}
protected override void ConfigureApplicationContainer(TinyIoCContainer container)
{
base.ConfigureApplicationContainer(container);
var cfg = DataConfig.FromJson(File.ReadAllText("data-config.json"));
var conn = cfg.CreateConnection();
conn.EstablishEnvironment(cfg.Database).GetAwaiter().GetResult();
container.Register(conn);
}
////ham tim kiem
//public DataTable TimKiem(string chuoi)
//{
// DataTable result = new DataTable();
// DataConfig config = new DataConfig();//tao ket noi
// string strQuery = "select * from PHIEUPHANCONG Where MaPhieuPC like'%" + chuoi + "%'"; // tim kiem theo ma
// result = config.GetData(strQuery);// form load len thi thuc hien load data
// return result;
//}
//them csdl
public int Insert(PhieuPhanCong obj)
{
int result = 0;
string strQuery = "insert into PHIEUPHANCONG (MaPhieuPC,NgayPC,FK_MaQuyenDA,FK_MaGV,FK_MaChucVu) values ('" + obj.MaPhieuPC
+ "','" + obj.NgayPC + "','" + obj.MaQuyenDA + "','" + obj.MaGV + "','" + obj.MaChucVu + "')";
DataConfig config = new DataConfig();
result = config.excuteNoneQuery(strQuery);
return(result); //tra ve so ghi nhan thuc hien
}
public int AddDataConfig()
{
int iRet = 0;
DataConfig dtConfig = new DataConfig();
_dataConfigs.ListDataConfig.Add(dtConfig);
return(iRet);
}
public ActionResult Load()
{
var session = DataConfig.GetSession();
var settings = session.Load <Domain.Settings>(1);
return(Json(new
{
DateFormat = settings.DateFormat
}));
}
public DataTable GetData()
{
DataTable result = new DataTable();
DataConfig config = new DataConfig();
//lua chon toan bo cac bang
string strQuery = "select * from dbo.LuongNhanVien";
result = config.GetData(strQuery);
return(result);
}
//ham getdata get du lieu vao
public DataTable GetData()
{
DataTable result = new DataTable();
DataConfig config = new DataConfig();
//lua chon toan bo cac bang
//string strQuery = "select dbo.NhanVien.*,dbo.PhongBan.TenPhongBan as TenPB*fromdbo.NhanVien,dbo.PhongBan where dbo.NhanVen.PhongBanMa=dbo.PhongBan.MaPhongBan";
string strQuery = @"select * from dbo.NhanVien";
result = config.GetData(strQuery);
return(result);
}
/// <summary>
/// map db
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public string MapDb(string name, bool isMapDb = false)
{
if (string.IsNullOrEmpty(this.query.Data.Key) && isMapDb == false)
{
return(DbCache.Get(DataConfig.Get().CacheType, string.Format("{0}.db", name.ToLower())));
}
else
{
return(this.query.Data.Key);
}
}
public void loadConfigData()
{
Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
ed.WriteMessage("Start loading config data\n");
DataConfig.loadData();
ed.WriteMessage("Current Version: " + DataConfig.getCurrentVersion());
ed.WriteMessage("Finish loading config data\n");
}
public static string UpdateAuditContentFileProcessStatus(DataConfig providerConfig, POCO.O365.AuditContentEntity contentFile)
{
switch (providerConfig.ProviderType)
{
// AZURE
case "azure.tableservice":
// Create an update object
POCO.O365.AuditContentEntityUpdateStatus updateStatus = new AuditContentEntityUpdateStatus();
updateStatus.PartitionKey = contentFile.PartitionKey;
updateStatus.RowKey = contentFile.RowKey;
updateStatus.ProcessStatus = contentFile.ProcessStatus;
AzureAuditContentEntityUpdateStatus az = new AzureAuditContentEntityUpdateStatus(updateStatus);
az.ETag = "*";
CloudTable table = Utils.GetCloudTable(providerConfig, AzureTableNames.AuditContentFiles);
TableOperation merge = TableOperation.InsertOrMerge(az);
// Execute the insert operation.
Task tResult = table.ExecuteAsync(merge);
tResult.Wait();
break;
// MONGO
case "internal.mongodb":
// Create the update filter
List <DataFactory.Filter> filters = new List <DataFactory.Filter>();
DataFactory.Filter pkFilter = new DataFactory.Filter("PartitionKey", Utils.CleanTableKey(contentFile.PartitionKey), "eq");
DataFactory.Filter rkFilter = new DataFactory.Filter("RowKey", Utils.CleanTableKey(contentFile.RowKey), "eq");
filters.Add(pkFilter);
filters.Add(rkFilter);
FilterDefinition <MongoAuditContentEntityUpdateStatus> filter = Utils.GenerateMongoFilter <MongoAuditContentEntityUpdateStatus>(filters);
IMongoCollection <MongoAuditContentEntityUpdateStatus> collection = Utils.GetMongoCollection <MongoAuditContentEntityUpdateStatus>(providerConfig, MongoTableNames.AuditContentFiles);
var update = Builders <MongoAuditContentEntityUpdateStatus> .Update
.Set("ProcessStatus", contentFile.ProcessStatus);
// Update the batch status
UpdateResult result = collection.UpdateOne(filter, update);
return(string.Empty);
default:
throw new ApplicationException("Data provider not recognised: " + providerConfig.ProviderType);
}
//TODO return id of new object if supported
return(string.Empty);
}
/// <summary>
/// 多种数据库类型切换
/// </summary>
/// <param name="key"></param>
/// <returns></returns>
public IFastRepository SetKey(string key)
{
this.query.Data.Config = DataConfig.Get(key);
this.query.Data.Key = key;
this.query.Data.Config.IsChangeDb = true;
this.data.Config = DataConfig.Get(key);
this.data.Key = key;
this.data.Config.IsChangeDb = true;
return(this);
}
public static void SetUpMigration()
{
var primaryConnectionStringKey = DataConfig.GetPrimaryConnectionStringKey();
DataConfig.EnsureDatabaseIsAvailable(connectionStringKey: primaryConnectionStringKey,
applicationName: typeof(Program).Assembly.GetName().Name,
createLocalDbIfMissing: true,
migrationsAssembly:
MigrationsAssembly.FromClass
<_2014112901_Init>());
}
public ActionResult List(int taskId)
{
var session = DataConfig.GetSession();
var task = session.Load <Domain.Task>(taskId);
return(Json(task.Attachments.Select(a => new
{
Id = a.Id,
FileName = a.FileName
})));
}
public WorldMapAreaDB(ILogger logger, DataConfig dataConfig)
{
this.logger = logger;
var list = JsonConvert.DeserializeObject <List <WorldMapArea> >(File.ReadAllText(Path.Join(dataConfig.WorldToMap, "WorldMapArea.json")));
list.ForEach(x =>
{
areas.Add(x.UIMapId, x);
});
}
public GoalFactory(ILogger logger, AddonReader addonReader, ConfigurableInput input, DataConfig dataConfig, NpcNameFinder npcNameFinder, NpcNameTargeting npcNameTargeting, IPPather pather, ExecGameCommand execGameCommand)
{
this.logger = logger;
this.addonReader = addonReader;
this.input = input;
this.dataConfig = dataConfig;
this.npcNameFinder = npcNameFinder;
this.npcNameTargeting = npcNameTargeting;
this.pather = pather;
this.exec = execGameCommand;
}
public ActionResult Drop()
{
FormsAuthentication.SignOut();
var dbName = ConfigurationManager.AppSettings["dbName"];
var server = new MongoClient().GetServer();
var database = server.GetDatabase(dbName);
database.Drop();
DataConfig.Initialize();
return(Redirect("/"));
}
public Search(string continent, Logger logger, DataConfig dataConfig)
{
this.logger = logger;
this.continent = continent;
this.dataConfig = dataConfig;
if (PathGraph == null)
{
CreatePathGraph(continent);
}
}
// tab 2
public DataTable LoadDataTongThang(string _Thang)
{
DataTable dt = new DataTable();
string query = "SELECT nv.MaNV,count (*) AS Tua,SUM(thang.ThoiGianDV) AS ThoiGian, SUM(thang.TienCer) AS TienCer, SUM(thang.TienMat) AS TienMat,SUM(thang.TienCer) + SUM(thang.TienMat) AS TongTien FROM " + _Thang + " AS thang, dbo.NhanVien AS nv WHERE thang.MaNV = nv.MaNV GROUP BY nv.MaNV";
string query1 = "SELECT nv.MaNV,count (*) AS Tua,SUM(thang.ThoiGianDV) AS ThoiGian, SUM(thang.TienCer) AS TienCer, SUM(thang.TienMat) AS TienMat,SUM(thang.TienCer) + SUM(thang.TienMat) AS TongTien FROM " + _Thang + " AS thang, dbo.NhanVien AS nv WHERE thang.MaNV = nv.MaNV GROUP BY nv.MaNV";
DataConfig config = new DataConfig();
dt = config.GetData(query);
return(dt);
}
/// <summary>
/// Gets the connection string settings.
/// </summary>
/// <param name="connectionStringName">Name of the connection string.</param>
/// <returns></returns>
private static IConnectionStringSettings GetConnectionStringSettings(string connectionStringName)
{
DataConfig dataConfig = Config.Get <DataConfig>();
if (!dataConfig.ConnectionStrings.ContainsKey(connectionStringName))
{
throw new KeyNotFoundException(connectionStringName);
}
return(dataConfig.ConnectionStrings[connectionStringName]);
}
public DataTable LocNhanVien(string _TenBang, string _Ngay, string _TenNhanVien)
{
//Ngay = '" + _Ngay + "' and
DataTable dt = new DataTable();
string query = "SELECT * FROM " + _TenBang + " WHERE Ngay = '" + _Ngay + "' and MaNV LIKE '%" + _TenNhanVien + "%'";
DataConfig config = new DataConfig();
dt = config.GetData(query);
return(dt);
}
public ActionResult Update(int id, string name)
{
var session = DataConfig.GetSession();
var category = session.Load <Domain.Category>(id);
category.Name = name;
session.SaveOrUpdate(category);
session.Transaction.Commit();
return(Json(new
{
}));
}
public MainWindow()
{
InitializeComponent();
DataConfig data = DeserializeBinary();
opayid.Text = data.OpayID;
channelname.Text = data.ChannelID;
username.Text = data.TwitchID;
twitchoauth.Text = data.TwitchOauth;
messagetemplate.Text = data.MessageTemplate;
}
private static List <WorldMapArea> CreateWorldMapAreaJson(DataConfig dataConfig)
{
var list = File.ReadAllLines(Path.Join(dataConfig.WorldToMap, "WorldMapArea.csv")).ToList().Skip(1).Select(l => l.Split(","))
.Select(l => CreateV1(l))
.ToList();
var uimapLines = File.ReadAllLines(Path.Join(dataConfig.WorldToMap, "uimap.csv")).ToList().Select(l => l.Split(","));
list.ForEach(wmp => PopulateUIMap(wmp, uimapLines));
System.IO.File.WriteAllText(Path.Join(dataConfig.WorldToMap, "WorldMapArea2.json"), JsonConvert.SerializeObject(list));
return(list);
}
//「登録」ボタンの押下
private void btnReg_Click(object sender, EventArgs e)
{
if (txtName.Text == "")
{
MessageBox.Show("すべての情報を入力してください");
txtName.Focus();
return;
}
if (txtLoginID.Text == "")
{
MessageBox.Show("すべての情報を入力してください");
txtLoginID.Focus();
return;
}
if (txtPass.Text == "")
{
MessageBox.Show("すべての情報を入力してください");
txtPass.Focus();
return;
}
//DB確認
string StoreName = "SP_INSERT_USERS";
DialogResult result = MessageBox.Show("登録して欲しいですか。", "確認", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
DataTable _mchek = new DataConfig().getTable("select * from EMPLOYEE where Employee_LoginID='" + txtLoginID.Text + "'");
if (_mchek != null && _mchek.Rows.Count > 0)
{
MessageBox.Show("ユーザが存在しました。");
txtLoginID.Focus();
return;
}
else
{
DataConfig clins = new DataConfig();
if (cmbBumon.SelectedIndex == -1)
{
cmbBumon.SelectedIndex = 0;
}
GlobalVariables.Item it = (GlobalVariables.Item)cmbBumon.SelectedItem;
string SQL = "exec " + StoreName + " 0,N'" + txtName.Text.ToString() + "',N'" + txtLoginID.Text + "',N'" + txtPass.Text + "',N'" + txtSiteName.Text + "'," + it.Value + ",0";
clins.Excute(SQL);
lblInf.Text = "登録に成功しました。";
btnReg.Enabled = false;
}
}
}
public void AddCategory(Category category)
{
using (DbConnection connection = new SqlConnection(DataConfig.GetPrimaryConnectionString()))
{
if (connection.State == System.Data.ConnectionState.Closed)
{
connection.Open();
}
//TODO: SqlMapperExtensions 这里还没有测试通过
SqlMapperExtensions.Insert <Category>(connection, category);
}
}
public ActionResult Create([Bind(Include = "FirstName,LastName,EmailAddress,PhoneNumbers")] Contact contact)
{
try
{
DataConfig.saveUpdateContact(contact, Operation.Add);
return(Redirect("Index"));
}
catch (Exception e)
{
return(View());
}
}
public ActionResult Edit([Bind(Include = "ContactId,FirstName,LastName,EmailAddress,PhoneNumbers")] Contact contact)
{
try
{
DataConfig.saveUpdateContact(contact, Operation.Update);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public int TaoThangMoi(TaoThangDTO obj)
{
int result = 0;
int result1 = 0;
string query = "CREATE TABLE " + obj.TenBang + " ( STT INT PRIMARY KEY IDENTITY(1,1), Ngay DATETIME DEFAULT(GETDATE()), MaNV VARCHAR(20) FOREIGN KEY REFERENCES dbo.NhanVien(MaNV), MaDV VARCHAR(20) FOREIGN KEY REFERENCES dbo.DichVu(MaDV), ThoiGianDV INT DEFAULT(0), TienCer INT DEFAULT (0), TienMat INT DEFAULT(0), )";
string query1 = "INSERT INTO dbo.ThongKeThang VALUES ('" + obj.TenBang + "')";
DataConfig config = new DataConfig();
result = config.fExecuteNoneQuery(query);
result1 = config.fExecuteNoneQuery(query1);
return(result);
}
public PathGraph(string continent,
ChunkedTriangleCollection triangles,
TriangleCollection paint, Logger logger, DataConfig dataConfig)
{
this.logger = logger;
this.Continent = continent;
this.triangleWorld = triangles;
this.paint = paint;
this.dataConfig = dataConfig;
BaseDir = dataConfig.PathInfo;
Clear();
}
public int XoaThang(string id)
{
int result = 0;
int result1 = 0;
string query = "DROP TABLE " + id + "";
string query1 = "DELETE dbo.ThongKeThang WHERE TenBang = '" + id + "'";
DataConfig config = new DataConfig();
result = config.fExecuteNoneQuery(query);
result1 = config.fExecuteNoneQuery(query1);
return(result);
}
