void StateChanged_Executed(object sender, ExecutedEventArgs e)
{
string messgae = "불러오기를 완료하였습니다.";
AMR_MST04Model model = new AMR_MST04Model();
model = (AMR_MST04Model)e.Parameter;
MySqlManage crud = new MySqlManage(ConfigurationManager.ConnectionStrings["MySQL"].ConnectionString);
DataSet ds = new DataSet();
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand();
cmd.CommandText = "CALL sp_load(@sno, @datefrom, @dateto);";
cmd.Parameters.AddWithValue("@sno", model.MST04SNO);
cmd.Parameters.AddWithValue("@datefrom", model.From.ToString("yyyy-MM-dd") + " 00");
cmd.Parameters.AddWithValue("@dateto", model.To.ToString("yyyy-MM-dd") + " 00");
ds = crud.CallSPMariaDBTable(crud.Connection, cmd);
if (ds.Tables.Count > 0)
{
model.DataTable = ds.Tables[0];
CurrentForm.SearchComplete(model);
}
CurrentForm.ShowMessage(messgae);
}
static void Main(string[] arguments) {
WindowsFormsSettings.ApplyDemoSettings();
//new DevExpress.DemoReports.ConnectionStringConfigurator(System.Configuration.ConfigurationManager.ConnectionStrings)
// .SelectDbEngine()
// .ExpandDataDirectory(fileName => DevExpress.DemoData.Helpers.DataFilesHelper.FindFile(fileName, DevExpress.DemoData.Helpers.DataFilesHelper.DataPath));
//string path = DevExpress.Utils.FilesHelper.FindingFileName(AppDomain.CurrentDomain.BaseDirectory, @"Data\NWind.mdf", false);
//XtraReportsDemos.ConnectionHelper.ApplyDataDirectory(System.IO.Path.GetDirectoryName(path));
DataHelper.ApplicationArguments = arguments;
//System.Globalization.CultureInfo enUs = new System.Globalization.CultureInfo("en-US");
//System.Threading.Thread.CurrentThread.CurrentCulture = enUs;
//System.Threading.Thread.CurrentThread.CurrentUICulture = enUs;
DevExpress.Utils.LocalizationHelper.SetCurrentCulture(DataHelper.ApplicationArguments);
DevExpress.UserSkins.BonusSkins.Register();
DevExpress.Utils.AppearanceObject.DefaultFont = new Font("Segoe UI", 8);
//DevExpress.LookAndFeel.UserLookAndFeel.Default.SetSkinStyle("Office 2013");
//DevExpress.LookAndFeel.UserLookAndFeel.Default.SetSkinStyle("Visual Studio 2013 Light");
DevExpress.LookAndFeel.UserLookAndFeel.Default.SetSkinStyle("Office 2010 Black");
SkinManager.EnableFormSkins();
EnumProcessingHelper.RegisterEnum<TaskStatus>();
//SplashScreenManager.ShowForm(null, typeof(ssMain), true, true, false, 1000);
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
fmLogin login = new fmLogin();
Application.Run(login);
if( login.DialogResult == DialogResult.OK )
{
//DevExpress.Data.CurrencyDataController.DisableThreadingProblemsDetection = true;
Application.Run(new frmMain());
MySqlManage db = new MySqlManage(ConfigurationManager.ConnectionStrings["MySQL"].ConnectionString);
string sql = string.Format("insert into amr_iqr03 values('{0}', '{1}', '1234', '{2}')", DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), login.User, 14);
db.InsertMariaDB(db.Connection, sql);
db.Dispose();
}
}
void CurrentForm_Onload(object sender, EventArgs e)
{
MySqlManage crud = new MySqlManage(ConfigurationManager.ConnectionStrings["MySQL"].ConnectionString);
string query = "select MST04SNO, MST04CMP, MST04DON, MST04HNO from amr_mst04";
DataSet ds = new DataSet();
ds = crud.SelectMariaDBTable(crud.Connection, query);
AMR_MST04Model model = new AMR_MST04Model();
model.DataTable = ds.Tables[0];
CurrentForm.LoadComplete(model);
}
protected internal override void ButtonClick(string tag)
{
switch (tag)
{
case TagResources.LoginHistorySearch:
this.gcLoingHistoryGrid.SafeInvoke(d => d.DataSource = null);
MySqlManage crud = new MySqlManage(ConfigurationManager.ConnectionStrings["MySQL"].ConnectionString);
string query = "select IQR03DAT, IQR03AID, IQR03MNO from amr_iqr03";
DataSet ds = new DataSet();
ds = crud.SelectMariaDBTable(crud.Connection, query);
this.gcLoingHistoryGrid.DataSource = ds.Tables[0];
break;
case TagResources.ContactNew:
break;
}
}
void GraphSearchChanged_Executed(object sender, ExecutedEventArgs e)
{
string messgae = "불러오기를 완료하였습니다.";
AMR_MST04Model model = new AMR_MST04Model();
model = (AMR_MST04Model)e.Parameter;
MySqlManage crud = new MySqlManage(ConfigurationManager.ConnectionStrings["MySQL"].ConnectionString);
//string query = string.Format("select TOT00DAT, {0} from amr_tot00 " +
// "where TOT00SNO = '{1}' and TOT00DAT between '{2}' and '{3}' " +
// "order by TOT00DAT asc ",
// model.Sensor,
// model.MST04SNO,
// model.From.ToString("yyyy-MM-dd"),
// model.To.ToString("yyyy-MM-dd"));
//ds = crud.SelectMariaDBTable(crud.Connection, query);
DataSet ds = new DataSet();
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand();
cmd.CommandText = "CALL sp_load_G02I02(@sno, @sensor, @datefrom, @dateto);";
cmd.Parameters.AddWithValue("@sno", model.MST04SNO);
cmd.Parameters.AddWithValue("@sensor", model.Sensor);
cmd.Parameters.AddWithValue("@datefrom", model.From.ToString("yyyy-MM-dd") + " 00");
cmd.Parameters.AddWithValue("@dateto", model.To.ToString("yyyy-MM-dd") + " 00");
ds = crud.CallSPMariaDBTable(crud.Connection, cmd);
if (ds.Tables.Count > 0)
{
model.DataTable = ds.Tables[0];
CurrentForm.SearchComplete(model);
}
CurrentForm.ShowMessage(messgae);
}
/// <summary>
/// 테이블 기본값 입력
/// </summary>
void InitGridData()
{
MySqlManage crud = new MySqlManage(ConfigurationManager.ConnectionStrings["MySQL"].ConnectionString);
string query = "select MST04SNO, MST04DON, MST04HNO from amr_mst04";
DataSet ds = new DataSet();
ds = crud.SelectMariaDBTable(crud.Connection, query);
foreach (DataRow row in ds.Tables[0].Rows)
{
mDataTable.Rows.Add(row[0], DateTime.Now.ToString("yyyy-MM-dd hh"), row[1], row[2], "null", "null", "null", "null", "null", "null", "null");
mCommTable.Rows.Add(row[0], DateTime.Now.ToString("yyyy-MM-dd hh"), row[1], row[2], "null", "null", "null", "null", "null", "null", "null");
}
}
protected override void InitMDBData(string connectionString)
{
MariaDbConnection = new MySqlConnection(connectionString);
MariaDbConnection.Open();
MySqlManage sql = new MySqlManage(ConfigurationManager.ConnectionStrings["MySQL"].ConnectionString);
DataSet ds = new DataSet();
ds = sql.SelectMariaDBTable(MariaDbConnection, "SELECT * FROM AMR_MST06");
foreach( DataRow row in ds.Tables[0].Rows)
{
UserInfo contact = new UserInfo();
contact.Id = row["MST06AID"].ToString();
if (row["MST06LEV"].ToString() == "1")
{
contact.Level = UserLevel.Level1;
}
else if (row["MST06LEV"].ToString() == "2")
{
contact.Level = UserLevel.Level2;
}
else if (row["MST06LEV"].ToString() == "3")
{
contact.Level = UserLevel.Level3;
}
contact.Name = row["MST06NAM"].ToString();
contact.Phone = row["MST06PHN"].ToString();
contact.Password = row["MST06PWD"].ToString();
contact.ConfirmPassword = row["MST06PWD"].ToString();
DataHelper.UserInfos.Add(contact);
}
gidControlUserManage.DataSource = DataHelper.UserInfos;
}
/// <summary>
/// 테이블 기본값 입력
/// </summary>
void InitGridData()
{
this.gridControl1.SafeInvoke(d => d.DataSource = null);
crud = new MySqlManage(ConfigurationManager.ConnectionStrings["MySQL"].ConnectionString);
string query = "select MST04SNO, MST04DON, MST04HNO from amr_mst04";
DataSet ds = new DataSet();
ds = crud.SelectMariaDBTable(crud.Connection, query);
foreach (DataRow row in ds.Tables[0].Rows)
{
mDataTable.Rows.Add(row[0], DateTime.Now.ToString("yyyy-MM-dd hh"), row[1], row[2], "null", "null", "null", "null", "null", "null", "null");
mCommTable.Rows.Add(row[0], DateTime.Now.ToString("yyyy-MM-dd hh"), row[1], row[2], "null", "null", "null", "null", "null", "null", "null");
}
//gridControl1.DataSource = mSensorInfoTable;
gridControl1.DataSource = CreateData();
}
public fmLogin() {
InitializeComponent();
db = new MySqlManage(ConfigurationManager.ConnectionStrings["MySQL"].ConnectionString);
}