/// <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");
}
}
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;
}
}
/// <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();
}
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;
}
