//调整顺序
public JsonResult UpdateIndex(int startIndex, int stopIndex, string GDH)
{
using (var db = new MySqlServer())
try
{
if (HanderDataForXF_SYService.GetOne(T => T.GDH == GDH) != null)
{
db.Database.GetInt(string.Format("update HanderDataForXF_SY set [index]=-1 where [index]={0} and GDH='{1}' ", stopIndex, GDH));
db.Database.GetInt(string.Format("update HanderDataForXF_SY set [index]={0} where [index]={1} and GDH='{2}' ", stopIndex, startIndex, GDH));
db.Database.GetInt(string.Format("update HanderDataForXF_SY set [index]={0} where [index]={1} and GDH='{2}' ", startIndex, -1, GDH));
return(Json(new { state = 1, msg = "排序成功。" }, JsonRequestBehavior.AllowGet));
}
else if (HanderDataForXF_KZService.GetOne(T => T.GDH == GDH) != null)
{
db.Database.GetInt(string.Format("update HanderDataForXF_KZ set [index]=-1 where [index]={0} and GDH='{1}' ", stopIndex, GDH));
db.Database.GetInt(string.Format("update HanderDataForXF_KZ set [index]={0} where [index]={1} and GDH='{2}' ", stopIndex, startIndex, GDH));
db.Database.GetInt(string.Format("update HanderDataForXF_KZ set [index]={0} where [index]={1} and GDH='{2}' ", startIndex, -1, GDH));
return(Json(new { state = 1, msg = "排序成功。" }, JsonRequestBehavior.AllowGet));
}
else
{
throw new Exception("系统出错：数据库中找不到对应数据。");
}
}
catch (Exception ex)
{
return(Json(new { state = 0, msg = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public SqlServerPropertiesDockForm(ref MySqlServer mySqlServer)
{
InitializeComponent();
_mySqlServer = mySqlServer;
var p = Process.GetCurrentProcess();
privateRamCounter = new PerformanceCounter("Process", "Working Set - Private", p.ProcessName, true);
cpuCounter = new PerformanceCounter("Process", "% Processor Time", p.ProcessName, true);
ramCounter = new PerformanceCounter("Process", "Working Set", p.ProcessName, true);
foreach (var item in new System.Management.ManagementObjectSearcher("Select * from Win32_ComputerSystem").Get())
{
physicalCpuCount = int.Parse(item["NumberOfProcessors"].ToString());
logicalCpuCount = int.Parse(item["NumberOfLogicalProcessors"].ToString());
}
foreach (var item in new System.Management.ManagementObjectSearcher("Select * from Win32_Processor").Get())
{
coreCount += int.Parse(item["NumberOfCores"].ToString());
}
// Preinitialize lists
_cpuUsageList = new List <float>();
_ramUsageList = new List <float>();
_privateMemoryUsageList = new List <float>();
for (int i = 0; i < SAMPLE_COUNT; i++)
{
_cpuUsageList.Add(0);
_ramUsageList.Add(0);
_privateMemoryUsageList.Add(0);
}
}
MySqlServer SetupMySqlServer(ErrorResultTO errors)
{
var server = new MySqlServer();
try
{
var connected = server.Connect(Source.ConnectionString, CommandType.StoredProcedure, ProcedureName);
if (!connected)
{
Dev2Logger.Error(string.Format(ErrorResource.FailedToConnectWithConnectionString,
Source.ConnectionString), GlobalConstants.WarewolfError);
}
return(server);
}
catch (MySqlException sex)
{
var errorMessages = new StringBuilder();
errorMessages.Append(sex.Message);
errors.AddError(errorMessages.ToString());
Dev2Logger.Error(errorMessages.ToString(), GlobalConstants.WarewolfError);
}
catch (Exception ex)
{
errors.AddError($"{ex.Message}{Environment.NewLine}{ex.StackTrace}");
Dev2Logger.Error(ex, GlobalConstants.WarewolfError);
}
return(server);
}
//修改尺码表状态
public JsonResult UpdateState(string Code, string state, string Action)
{
using (var db = new MySqlServer())
try
{
switch (Action)
{
case "XF_SY_NAN":
db.Database.GetInt(string.Format("update XF_SY_NAN_ChiMa set status='{0}' where Size_Code='{1}'", state, Code));
return(Json(new { state = 1, msg = "" }, JsonRequestBehavior.AllowGet));
case "XF_SY_NU":
db.Database.GetInt(string.Format("update XF_SY_NU_ChiMa set status='{0}' where Size_Code='{1}'", state, Code));
return(Json(new { state = 1, msg = "" }, JsonRequestBehavior.AllowGet));
case "XF_KZ_NAN":
db.Database.GetInt(string.Format("update XF_KZ_CodeSize set status='{0}' where Size_Code='{1}'", state, Code));
return(Json(new { state = 1, msg = "" }, JsonRequestBehavior.AllowGet));
case "XF_KZ_NU":
db.Database.GetInt(string.Format("update XF_KZ_CodeSize set status='{0}' where Size_Code='{1}'", state, Code));
return(Json(new { state = 1, msg = "" }, JsonRequestBehavior.AllowGet));
default:
throw new Exception("系统出错：没有对应的Action");
}
}
catch (Exception ex)
{
return(Json(new { state = -1, msg = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
//加载尺码表详细信息
public JsonResult BugCodeSize(string Size_Code, string Action)
{
using (var db = new MySqlServer())
try
{
switch (Action)
{
case "XF_SY_NAN":
return(Json(new { state = 1, msg = XF_SY_NAN_ChiMa.Query(T => T.Status == 1 && T.Size_Code == Size_Code, o => o.Id, false).ToList() }, JsonRequestBehavior.AllowGet));
case "XF_SY_NU":
return(Json(new { state = 1, msg = XF_SY_NU_ChiMa.Query(T => T.Status == 1 && T.Size_Code == Size_Code, o => o.Id, false).ToList() }, JsonRequestBehavior.AllowGet));
case "XF_KZ_NAN":
return(Json(new { state = 1, msg = XF_KZ_Service.Query(T => T.Status == 1 && T.Size_Code == Size_Code, o => o.Id, false).ToList() }, JsonRequestBehavior.AllowGet));
case "XF_KZ_NU":
return(Json(new { state = 1, msg = XF_KZ_Service.Query(T => T.Status == 1 && T.Size_Code == Size_Code, o => o.Id, false).ToList() }, JsonRequestBehavior.AllowGet));
default:
throw new Exception("系统出错：没有对应的Action");
}
}
catch (Exception ex)
{
return(Json(new { state = -1, msg = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult Manage(string Code, string Action)
{
using (var db = new MySqlServer())
try
{
switch (Action)
{
case "XF_SY_NAN": //西服上衣 男
return(Json(new { state = 1, msg = XF_SY_NAN_ChiMa.Query(T => T.Size_Code == Code && T.IsDeleted == false, O => O.Id, false) }, JsonRequestBehavior.AllowGet));
case "XF_SY_NU":
return(Json(new { state = 1, msg = XF_SY_NU_ChiMa.Query(T => T.Size_Code == Code && T.IsDeleted == false, O => O.Id, false) }, JsonRequestBehavior.AllowGet));
case "XF_KZ_NAN":
case "XF_KZ_NU":
return(Json(new { state = 1, msg = XF_KZ_CodeSizeService.Query(T => T.Size_Code == Code && T.IsDeleted == false, O => O.Id, false), HeightKuChang = HeightKuChangService.Query(T => T.Size_Code == Code && T.IsDeleted == false, O => O.Id, false) }, JsonRequestBehavior.AllowGet));
default:
throw new Exception("系统出错：没有对应的Action");
}
}
catch (Exception ex)
{
return(Json(new { state = 1, msg = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
//尺码表编号下拉
public JsonResult SizeCodeSelect(string Action)
{
using (var db = new MySqlServer())
try
{
switch (Action)
{
case "XF_SY_NAN": //西服上衣 男
List <XF_SY_NAN_ChiMaDto> XF_SY_NAN = db.Database.GetList <XF_SY_NAN_ChiMaDto>("select Size_Code from XF_SY_NAN_ChiMa where Status=0 Group By Size_Code");
return(Json(new { state = 1, msg = XF_SY_NAN }, JsonRequestBehavior.AllowGet));
case "XF_SY_NU":
List <XF_SY_NU_CodeSizeDto> XF_SY_NU = db.Database.GetList <XF_SY_NU_CodeSizeDto>("select Size_Code from XF_SY_NU_CodeSize where Status=0 Group By Size_Code");
return(Json(new { state = 1, msg = XF_SY_NU }, JsonRequestBehavior.AllowGet));
case "XF_KZ_NAN": //西服裤子
case "XF_KZ_NU":
List <XF_KZ_CodeSizeDto> XF_KZ = db.Database.GetList <XF_KZ_CodeSizeDto>("select Size_Code from XF_KZ_CodeSize where Status=0 Group By Size_Code");
return(Json(new { state = 1, msg = XF_KZ }, JsonRequestBehavior.AllowGet));
default:
throw new Exception("系统出错：没有对应的Action");
}
}
catch (Exception ex)
{
return(Json(new { state = -1, msg = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
private bool MySqlExecution(ErrorResultTO errors)
{
try
{
List <MySqlParameter> parameters = GetMySqlParameters(Service.Method.Parameters);
using (
MySqlServer server = SetupMySqlServer(errors))
{
if (parameters != null)
{
// ReSharper disable CoVariantArrayConversion
using (DataTable dataSet = server.FetchDataTable(parameters.ToArray(), server.GetProcedureOutParams(Service.Method.Name, Source.DatabaseName)))
// ReSharper restore CoVariantArrayConversion
{
ApplyColumnMappings(dataSet);
TranslateDataTableToEnvironment(dataSet, DataObj.Environment);
return(true);
}
}
}
}
catch (Exception ex)
{
errors.AddError(string.Format("{0}{1}{2}", ex.Message, Environment.NewLine, ex.StackTrace));
}
return(false);
}
//验证西服上衣格式(女)
public static bool Verification_XF_SY_NU(DataTable table)
{
using (var db = new MySqlServer())
try
{
var vc = db.Database.GetString(@" select D_Value from Dictionaries where d_Key='ExcelColumnsCount_XF_SY_NU' ");
int count = 0;
if (!int.TryParse(vc, out count))
{
throw new Exception("系统出错，没有配置excel验证条件。");
}
if (table.Columns.Count != count)
{
throw new Exception("Excel格式出错，请检查文件");
}
return(true);
}
catch (Exception ex)
{
throw;
}
}
public void ExampleTest()
{
//Setting up and starting the server
//This can also be done in a AssemblyInitialize method to speed up tests
MySqlServer dbServer = MySqlServer.Instance;
dbServer.StartServer();
//Create a database and select it
MySqlHelper.ExecuteNonQuery(dbServer.GetConnectionString(), string.Format("CREATE DATABASE {0};USE {0};", _testDatabaseName));
//Create a table
MySqlHelper.ExecuteNonQuery(dbServer.GetConnectionString(_testDatabaseName), "CREATE TABLE testTable (`id` INT NOT NULL, `value` CHAR(150) NULL, PRIMARY KEY (`id`)) ENGINE = MEMORY;");
//Insert data (large chunks of data can of course be loaded from a file)
MySqlHelper.ExecuteNonQuery(dbServer.GetConnectionString(_testDatabaseName), "INSERT INTO testTable (`id`,`value`) VALUES (1, 'some value')");
MySqlHelper.ExecuteNonQuery(dbServer.GetConnectionString(_testDatabaseName), "INSERT INTO testTable (`id`, `value`) VALUES (2, 'test value')");
//Load data
using (MySqlDataReader reader = MySqlHelper.ExecuteReader(dbServer.GetConnectionString(_testDatabaseName), "select * from testTable WHERE id = 2"))
{
reader.Read();
Assert.AreEqual("test value", reader.GetString("value"), "Inserted and read string should match");
}
//Shutdown server
dbServer.ShutDown();
}
static void Main(string[] args)
{
Console.WriteLine("connecting to database");
var svr = MySqlServer.GetMySqlServer("test.water.usbr.gov", "timeseries", "");
TimeSeriesDatabase db = new TimeSeriesDatabase(svr);
Console.WriteLine("reading sitecatalog");
var sites = db.GetSiteCatalog();
var sc = db.GetSeriesCatalog("isfolder=0");
var prop = db.GetSeriesProperties(true);
for (int i = 0; i < sc.Count; i++)
{
var s = db.GetSeries(sc[i].id);
var por = s.GetPeriodOfRecord();
if (por.Count > 0)
{
s.Properties.Set("t1", por.T1.ToString("yyyy-MM-dd"));
s.Properties.Set("t2", por.T2.ToString("yyyy-MM-dd"));
Console.WriteLine(s.Name);
}
}
db.Server.SaveTable(prop);
//SetRegioninSiteTable(db, sites);
// UpdateGPSiteInfo(sites);
svr.SaveTable(sites);
Console.WriteLine();
}
//导出裁单
public JsonResult LoadOrder(string Action, string GDH)
{
using (var db = new MySqlServer())
try
{
if (HanderDataForXF_SYService.GetOne(T => T.GDH == GDH) != null)
{
var orderlist = db.Database.GetList <DictionariesDto>("select * from Dictionaries where D_Key='HanderDataForXF_SYOrder'");
return(Json(new { state = 1, msg = orderlist }, JsonRequestBehavior.DenyGet));
}
else
{
var orderlist = db.Database.GetList <DictionariesDto>("select * from Dictionaries where D_Key='HanderDataForXF_KZOrder'");
return(Json(new { state = 1, msg = orderlist }, JsonRequestBehavior.DenyGet));
}
}
catch (Exception ex)
{
return(Json(new
{
state = 0,
msg = ex.Message
}, JsonRequestBehavior.AllowGet));
}
}
private MySqlServer SetupMySqlServer(ErrorResultTO errors)
{
var server = new MySqlServer();
try
{
bool connected = server.Connect(Source.ConnectionString, CommandType.StoredProcedure,
String.IsNullOrEmpty(Service.Method.ExecuteAction)
? Service.Method.Name
: Service.Method.ExecuteAction);
if (!connected)
{
Dev2Logger.Log.Error(string.Format("Failed to connect with the following connection string: '{0}'",
Source.ConnectionString));
}
return(server);
}
catch (MySqlException sex)
{
// 2013.06.24 - TWR - added errors logging
var errorMessages = new StringBuilder();
errorMessages.Append(sex.Message);
errors.AddError(errorMessages.ToString());
Dev2Logger.Log.Error(errorMessages.ToString());
}
catch (Exception ex)
{
// 2013.06.24 - TWR - added errors logging
errors.AddError(string.Format("{0}{1}{2}", ex.Message, Environment.NewLine, ex.StackTrace));
Dev2Logger.Log.Error(ex);
}
return(server);
}
public void OpenNoPropertiesTest()
{
// Test the MySQL server connection
using (MySqlServer target = new MySqlServer())
{
target.Open();
}
}
public void TestMySQL()
{
var svr = MySqlServer.GetMySqlServer("localhost", "timeseries");
var db = new TimeSeriesDatabase(svr, false);
BasicDatabaseTest(db);
}
public void StartServerOnSpecifiedPort()
{
MySqlServer server = MySqlServer.Instance;
server.StartServer(3366);
MySqlHelper.ExecuteNonQuery(server.GetConnectionString(), "CREATE DATABASE testserver; USE testserver;");
server.ShutDown();
}
public DataPreviewDockForm(ref MySqlServer mySqlServer)
{
InitializeComponent();
_mySqlServer = mySqlServer;
this.richTextBox1.Text = AppSettings.Default.NoObjectSelectedDefaultText;
this.Enabled = false;
}
public void KillProcess()
{
int previousProcessCount = Process.GetProcessesByName("mysqld").Length;
MySqlServer database = MySqlServer.Instance;
database.StartServer();
database.ShutDown();
Assert.AreEqual(previousProcessCount, Process.GetProcessesByName("mysqld").Length, "should kill the running process");
}
public ObjectDefinitionDockForm(ref MySqlServer mySqlServer)
{
InitializeComponent();
_mySqlServer = mySqlServer;
this.richTextBoxObjectName.Text = AppSettings.Default.NoObjectSelectedDefaultText;
this.Enabled = false;
_defaultSelectionColor = richTextBoxObjectDef.SelectionColor;
_defaultSelectionFont = richTextBoxObjectDef.Font;
}
//加载列表
public JsonResult GetList(string GDH)
{
using (var db = new MySqlServer())
try
{
return(Json(new { state = 1, msg = db.Database.GetList <DCL_DataDto>(string.Format("select * from DCL_Data where GDH='{0}'", GDH)) }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { state = 1, msg = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public BackupMySql(string server, int port, string user, string password, string database, string pasta)
{
VariaveisGeral.NomeAssembly = GetType().Name;
//1) Primeiro a ser inicializado devido do IoC
InicializarBootstrapper();
//2) Segundo a ser inicializado devido aos dados do Banco de dados
InicializarConnectionString(server, port, user, password, database);
InicializarPastas(pasta);
MySqlDatabase = VariaveisGeral.Container.GetInstance <MySqlDatabase>();
MySqlServer = VariaveisGeral.Container.GetInstance <MySqlServer>();
}
/// <summary>
/// Main entry form
/// </summary>
/// <param name="args"></param>
public static void startRwisUiMain(string[] args)
{
if (jrDebug)
{
// Connect to DB Server
string dbname = ConfigurationManager.AppSettings["MySqlDatabase"];
string server = ConfigurationManager.AppSettings["MySqlServer"];
string user = ConfigurationManager.AppSettings["MySqlUser"];
BasicDBServer svr = MySqlServer.GetMySqlServer(server, dbname, user);
db = new TimeSeriesDatabase(svr);
siteCat = db.GetSiteCatalog();
parCat = db.GetParameterCatalog();
}
// Starts the application.
Application.Run(new rwisForm());
}
public static TimeSeriesDatabase InitDatabase(Arguments args, bool readOnly = false)
{
if (args.Contains("database"))
{
if (File.Exists(args["database"]))
{
SQLiteServer svr = new SQLiteServer(args["database"]);
var db = new TimeSeriesDatabase(svr, LookupOption.TableName, readOnly);
return(db);
}
int idx = args["database"].IndexOf(":");
if (idx > 0)
{// postgresql
}
throw new NotImplementedException("Please use app.config file");
}
else if (ConfigurationManager.AppSettings["PostgresDatabase"] != null)
{// use config file (postgresql is default)
Logger.WriteLine("using postgresql");
var dbname = ConfigurationManager.AppSettings["PostgresDatabase"];
var svr = PostgreSQL.GetPostgresServer(dbname);
var db = new TimeSeriesDatabase(svr, LookupOption.TableName, readOnly);
db.Parser.RecursiveCalculations = false;
Logger.WriteLine("database initilized..");
return(db);
}
else if (ConfigurationManager.AppSettings["MySqlDatabase"] != null)
{// use config file (postgresql is default)
Logger.WriteLine("using mysql");
var dbname = ConfigurationManager.AppSettings["MySqlDatabase"];
var server = ConfigurationManager.AppSettings["MySqlServer"];
var user = ConfigurationManager.AppSettings["MySqlUser"];
string pass = "";
if (ConfigurationManager.AppSettings["MySqlPassword"] != null)
{
pass = ConfigurationManager.AppSettings["MySqlPassword"];
}
var svr = MySqlServer.GetMySqlServer(server, dbname, user, pass);
var db = new TimeSeriesDatabase(svr, LookupOption.TableName, readOnly);
db.Parser.RecursiveCalculations = false;
Logger.WriteLine("database initilized..");
return(db);
}
throw new NotImplementedException("Please use app.config file to configure database");
}
public void ConnectToServer(string server, string database, DatabaseType t)
{
string cs = ""; // connection string
BasicDBServer svr = null;
if (t == DatabaseType.PostgreSql)
{
cs = PostgreSQL.CreateADConnectionString(server, database);
svr = new PostgreSQL(cs);
}
if (t == DatabaseType.SqlServer)
{
svr = new SqlServer(server, database);
}
if (t == DatabaseType.MySQL)
{
svr = MySqlServer.GetMySqlServer(server, database);
}
Connect(svr);
}
// =========================================
public DatabaseBrowserDockForm(ref MySqlServer mySqlServer)
{
_mySqlServer = mySqlServer;
int normalIdx = 0;
int linkedIdx = 100000;
InitializeComponent();
objectListView1.Groups.Clear();
olvColumnDatabaseName.GroupKeyGetter = delegate(object x)
{
return(((MySqlDatabase)x).ServerObjectName);
};
olvColumnDatabaseName.GroupFormatter = delegate(OLVGroup group, GroupingParameters parms)
{
var svr = _mySqlServer.SqlServerObjects.First(x => x.ServerObjectName.Equals(group.Key.ToString(), StringComparison.InvariantCultureIgnoreCase));
if (!svr.IsValid)
{
group.TitleImage = 2;
}
else
{
group.TitleImage = (svr.IsLinked) ? 1 : 0;
}
group.Subtitle = string.Format("{0} {1}{2}", svr.ProductVersionName, svr.ProductLevel, ((svr.IsLinked) ? " (Linked)" : string.Empty));
group.Task = "Server Properties";
@group.SortValue = svr.IsLinked ? linkedIdx++ : normalIdx++;
};
olvColumnDatabaseName.ImageGetter = delegate(object x)
{
return(((MySqlDatabase)x).Image);
};
}
private BasicDBServer GetServer(string server, string database, DatabaseType t, string password = "", string user = "")
{
BasicDBServer svr = null;
if (user == "")
{
user = Environment.UserName.ToLower();
}
if (t == DatabaseType.PostgreSql)
{
svr = PostgreSQL.GetPostgresServer(database, server, user, password);
}
if (t == DatabaseType.SqlServer)
{
svr = new SqlServer(server, database);
}
if (t == DatabaseType.MySQL)
{
svr = MySqlServer.GetMySqlServer(server, database, "", password);
}
return(svr);
}
static void Main(string[] args)
{
Console.WriteLine("connecting to database");
var svr = MySqlServer.GetMySqlServer("140.215.104.92", "timeseries", "");
TimeSeriesDatabase db = new TimeSeriesDatabase(svr);
Console.WriteLine("reading site catalog");
var sites = db.GetSiteCatalog();
sites.AddsitecatalogRow("schwind", "Schwind", "CA",
"39.34752", "-121.80084", "", "", "", "", "", 0, "", "", "", "", "", "");
sites.AddsitecatalogRow("cassidy", "Cassidy", "CA",
"39.33243", "-121.78971", "", "", "", "", "", 0, "", "", "", "", "", "");
sites.AddsitecatalogRow("risingriver", "Rising River", "CA",
"39.33097", "-121.76636", "", "", "", "", "", 0, "", "", "", "", "", "");
svr.SaveTable(sites);
Console.WriteLine("reading series catalog");
var series = db.GetSeriesCatalog();
int grayLodge = series.GetOrCreateFolder("water.usbr.gov", "MP", "Gray Lodge");
string fn = @"U:\water.usbr.gov\2016\GrayLodgeData.xlsx";
var s = new ExcelDataReaderSeries(fn, "Rising River", "A", "B", "cfs");
s.Name = "Flow";
s.Table.TableName = "mpgraylodge_instant_rising_" + s.Name;;
s.Read();
// db.AddSeries()
svr.SaveTable(series);
Console.WriteLine();
}
//public void SetInMemoryDatabase(ref InMemoryDatabase inMemoryDatabase)
//{
// this._inMemoryDatabase = inMemoryDatabase;
// textBox2.Text = string.Join(", ", inMemoryDatabase.LoadedDatabases.Select(d => "[" + d.DatabaseName + "]"));
//}
//public DependencyBrowserDockForm(string title, bool isTopDown)
public DependencyBrowserDockForm(ref MySqlServer mySqlServer, string title, string[] objectTypes, bool isTopDown, int windowId)
{
InitializeComponent();
this._mySqlServer = mySqlServer;
//_objectDepParentDictionary = new Dictionary<MySqlObjectParentKey, MySqlObject>();
//_objectDepChildDictionary = new Dictionary<MySqlObjectChildKey, MySqlObject>();
_dependencyObjectList = new List <MySqlObject>();
_recommendedDatabases = new List <KeyValuePair <MySqlObject, MySqlDatabase> >();
this.Text = string.Format("New Dependency {0}", windowId);
this.treeListView1.CanExpandGetter = delegate(object x)
{
return(_dependencyObjectList.Any(m => m.SystemParentId == ((MySqlObject)x).SystemId));
};
this.treeListView1.ChildrenGetter = delegate(object x)
{
return(_dependencyObjectList.Where(m => m.SystemParentId == ((MySqlObject)x).SystemId).OrderBy(m => m.ObjectName));
};
olvColumnObjectName.ImageGetter = delegate(object x)
{
return(((MySqlObject)x).Image);
};
treeListView1.UseAlternatingBackColors = UserSettings.Default.UseAlternatingBackColors;
//
//pictureBox1.too
pictureBox1.Image = (isTopDown) ? Resources._112_DownArrowLong_Blue_32x32_72 : Resources._112_UpArrowLong_Orange_32x42_72;
textBox1.Text = (isTopDown) ? string.Format("Objects on which '{0}' depends on", title) : string.Format("Objects that depend on '{0}'", title);
textBox2.Text = string.Join(", ", _mySqlServer.SqlLoadedDatabases.Select(d => "[" + d.DatabaseName + "]"));
}
internal void ExportHeaderDatabase()
{
var iqueryexpress = new QueryExpress();
var mySqlServer = new MySqlServer(iqueryexpress);
ExportWriteComment(string.Format("Dump Begin : {0}", DateTime.Now.ToString(VariaveisGeral.FormatoData)));
ExportWriteComment("--------------------------------------");
ExportWriteComment(string.Format(" Backup Gerado por : {0}", VariaveisGeral.NomeAssembly));
ExportWriteComment(string.Format(" Database: {0}", VariaveisGeral.Database));
ExportWriteComment(string.Format(" VersionNumber: {0}", mySqlServer.VersionNumber));
ExportWriteComment(string.Format(" Edition: {0}", mySqlServer.Edition));
ExportWriteComment(string.Format(" MajorVersionNumber: {0}", mySqlServer.MajorVersionNumber));
// ExportWriteComment(string.Format(" CurrentUser: {0}", mySqlServer.CurrentUser));
ExportWriteComment("--------------------------------------");
ExportWriteLine();
}
//获取初排数据
public JsonResult GetListForHanderData(string GDH, string Order, string type)
{
using (var db = new MySqlServer())
try
{
Order = Order.TrimEnd(',');
if (HanderDataForXF_SYService.GetOne(T => T.GDH == GDH) != null)
{
string xxxxdsadsax = string.Format("select ROW_NUMBER()over(order by {0}) rownum,* from (select * from HanderDataForXF_SY ) as list order by {0}", Order);
//list.Height,list.Sleeve,list.Bust
var SYList = db.Database.GetDataTable(string.Format("select ROW_NUMBER()over(order by {0}) rownum,* from (select * from HanderDataForXF_SY ) as list order by {0}", Order));
if (type != "NotOrder")
{
for (int i = 0; i < SYList.Rows.Count; i++)
{
var xxxxx = db.Database.GetInt(string.Format("update HanderDataForXF_SY set [index]={0} where id={1}", SYList.Rows[i]["rownum"].ToString(), SYList.Rows[i]["Id"].ToString()));
}
}
return(Json(new { state = 1, action = "HanderDataForXF_SY", msg = HanderDataForXF_SYService.Query(T => T.GDH == GDH, O => O.Index, false) }, JsonRequestBehavior.AllowGet));
}
else if (HanderDataForXF_KZService.GetOne(T => T.GDH == GDH) != null)
{
return(Json(new { state = 1, action = "HanderDataForXF_KZ", msg = HanderDataForXF_KZService.Query(T => T.GDH == GDH, O => O.Index, false) }, JsonRequestBehavior.AllowGet));
}
else
{
throw new Exception("系统出错：数据库中找不到对应数据。");
}
}
catch (Exception ex)
{
return(Json(new { state = 0, msg = ex.Message }, JsonRequestBehavior.AllowGet));
}
}