private void GridGroupCount_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt.Columns.Add("C1");
dt.Columns.Add("C2");
dt.Columns.Add("C3");
dt.Rows.Add("A", "D", 1);
dt.Rows.Add("A", "D", 1);
dt.Rows.Add("A", "F", 1);
dt.Rows.Add("A", "F", 1);
dt.Rows.Add("B", "J", 1);
dt.Rows.Add("B", "J", 1);
dt.Rows.Add("B", "H", 1);
dt.Rows.Add("B", "H", 1);
this.gridControl1.DataSource = dt;
Cls.Grid.GridStyle gs = new Cls.Grid.GridStyle(this.gridControl1, this.gridView1);
gs.AddColumn("C1", "C1", Cls.Grid._ColumnType.Default, 80, Cls.Grid._ColumnAlign.Center);
gs.AddColumn("C2", "C2", Cls.Grid._ColumnType.Default, 80, Cls.Grid._ColumnAlign.Center);
gs.AddColumn("C3", "C3", Cls.Grid._ColumnType.Default, 80, Cls.Grid._ColumnAlign.Center);
}
private void frmBiz_Load(object sender, EventArgs e)
{
try
{
Cls.Grid.GridStyle gs = new Cls.Grid.GridStyle(this.grid, this.gridView);
gs.AddColumn("사업장코드", "BIZ_CODE", Cls.Grid._ColumnType.Default, 100, Cls.Grid._ColumnAlign.Center, true);
gs.AddColumn("사업장이름", "BIZ_NAME", Cls.Grid._ColumnType.Default, 120, Cls.Grid._ColumnAlign.Left, true);
gs.AddColumn("사업장코드", "BIZ_NO", Cls.Grid._ColumnType.Default, 100, Cls.Grid._ColumnAlign.Center, true);
Cls.Grid.Options.SelectedRow(this.gridView);
Cls.Grid.Options.EmbeddedNavigater(this.grid);
this.grid.DataSource = dtBizs;
}
catch (Exception ex)
{
throw ex;
}
}
private void frmGridStyle_RTF_Load(object sender, EventArgs e)
{
this.gridView1.OptionsView.RowAutoHeight = true;
this.gridView1.OptionsView.ColumnAutoWidth = true;
dt.Columns.Add("CNT", typeof(decimal));
//dt.Columns.Add("STREAM" , typeof(byte[]));
dt.Columns.Add("STREAM");
Cls.Grid.GridStyle gs = new Cls.Grid.GridStyle(this.gridControl1, this.gridView1);
gs.AddColumn("카운트", "CNT", Cls.Grid._ColumnType.Numbers, 60, Cls.Grid._ColumnAlign.Right, true);
gs.AddColumn("문서", "STREAM", Cls.Grid._ColumnType.RichEdit, 300, Cls.Grid._ColumnAlign.Left, true);
RepositoryItemRichTextEdit rich = ( RepositoryItemRichTextEdit)this.gridView1.Columns["STREAM"].ColumnEdit;
rich.CustomHeight = -1;
//rich.DocumentFormat = DocumentFormat.Rtf;
//rich.CustomDisplayText += new DevExpress.XtraEditors.Controls.CustomDisplayTextEventHandler(rich_CustomDisplayText);
this.gridControl1.DataSource = dt;
}
private void Grid_ColumnType_Load(object sender, EventArgs e)
{
try
{
DataTable dt = new DataTable();
dt.Columns.Add("C1");
dt.Columns.Add("C2", typeof(string), "C1");
dt.Rows.Add(new object[] { "20" });
this.gridControl1.DataSource = dt;
Cls.Grid.GridStyle gs = new Cls.Grid.GridStyle(this.gridControl1, gridView1);
gs.AddColumn("C1", "C1", Cls.Grid._ColumnType.Default, 120, Cls.Grid._ColumnAlign.Center, true, true);
gs.AddColumn("C2", "C2", Cls.Grid._ColumnType.Progressbar, 120, Cls.Grid._ColumnAlign.Center);
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
}
/// <summary>
/// 그리드를 셋팅합니다.
/// </summary>
/// <param name="grd">그리드 컨트롤.</param>
/// <param name="gridview">그리드뷰컨트롤.</param>
/// <param name="dt">데이터소스</param>
private void SetDataTable(DevExpress.XtraGrid.GridControl grd,
DevExpress.XtraGrid.Views.Grid.GridView gridview,
CodeType type)
{
try
{
string code = "";
if (type == CodeType.L)
{
code = "TYPE_CODE_L";
}
else if (type == CodeType.M)
{
code = "TYPE_CODE_M";
}
else if (type == CodeType.S)
{
code = "TYPE_CODE_S";
}
Cls.Grid.GridStyle gs = new Cls.Grid.GridStyle(grd, gridview);
gs.AddColumn("코드", "CUST_TYPE_CODE", Cls.Grid._ColumnType.Default, 50, Cls.Grid._ColumnAlign.Center, false);
gs.AddColumn("코드", code, Cls.Grid._ColumnType.Default, 50, Cls.Grid._ColumnAlign.Center);
gs.AddColumn("코드명", "CUST_TYPE_NAME", Cls.Grid._ColumnType.Default, 100, Cls.Grid._ColumnAlign.Left);
gs.AddColumn("정렬순서", "USE_SORT", Cls.Grid._ColumnType.Default, 80, Cls.Grid._ColumnAlign.Center);
gs.AddColumn("사용여부", "USE_YN_NAME", Cls.Grid._ColumnType.Default, 80, Cls.Grid._ColumnAlign.Center);
Cls.Grid.Options.SelectedRow(gridview);
Cls.Grid.Options.EmbeddedNavigater(grd);
Cls.Grid.Options.FilterRow(gridview, true);
}
catch (Exception ex)
{
throw ex;
}
}
private void timer1_Tick(object sender, EventArgs e)
{
try
{ this.gridControl1.Visible = false;
this.timer1.Enabled = false;
Basic.SetCursor(this, true);
DataTable dtParm = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
dtParm.Rows.Add(new object[] { "V_RECE_PAY_NO", _recepayno });
DataSet dsTmp = DataLayer.ExecuteSpDataset("PKG_JFAAI01.PR_04", dtParm, DataLayer.MessageEncoding.Default);
/*
* dt.Columns.Add("RECE_PAY_NO" );
* dt.Columns.Add("CARD_NO" );
* dt.Columns.Add("VAILD_THRU" );
* dt.Columns.Add("INSTALLMENT_CNT" ,typeof(decimal));
* dt.Columns.Add("AGREE_YN" );
* dt.Columns.Add("AGREE_NO" );
* dt.Columns.Add("CARD_CO_CODE" );
* dt.Columns.Add("CARD_CO_NAME" );
* dt.Columns.Add("AGREE_DATE" );
* ;
*/
DataTable dt = new DataTable();
dt.Columns.Add("TEXT");
dt.Columns.Add("VALUE");
for (int i = 0; i < dsTmp.Tables[0].Columns.Count; i++)
{
string txt = dsTmp.Tables[0].Columns[i].ColumnName.ToString().Trim();
string val = dsTmp.Tables[0].Rows[0][i].ToString().Trim();
dt.Rows.Add(new object[] { txt, val });
}
Cls.Grid.GridStyle gs = new Cls.Grid.GridStyle(this.gridControl1, this.gridView1);
gs.AddColumn("항목", "TEXT", Cls.Grid._ColumnType.Default, 120, Cls.Grid._ColumnAlign.Left);
gs.AddColumn("내역", "VALUE", Cls.Grid._ColumnType.Default, 120, Cls.Grid._ColumnAlign.Left);
this.gridControl1.DataSource = dt;
cardinfo.orgagreeno = dsTmp.Tables[0].Rows[0]["승인일자"].ToString().Trim();
cardinfo.cardcocode = dsTmp.Tables[0].Rows[0]["매입사코드"].ToString().Trim();
cardinfo.cardconame = dsTmp.Tables[0].Rows[0]["매입사명"].ToString().Trim();
cardinfo.cardno = dsTmp.Tables[0].Rows[0]["카드번호"].ToString().Trim();
cardinfo.installmentcnt = dsTmp.Tables[0].Rows[0]["할부개월"].ToString().Trim();
cardinfo.validthru = dsTmp.Tables[0].Rows[0]["유효기간"].ToString().Trim(); }
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
this.Close();
}
finally
{
this.gridControl1.Visible = true;
Basic.SetCursor(this, true);
}
}
private void btnCheck_Click(object sender, EventArgs e)
{
try
{
if (txtPwd.Text.Trim() == "")
{
return;
}
if (!Basic.GetAdminPwdCheck(txtPwd.Text.Trim()))
{
Basic.ShowMessage(1, "비밀번호가 틀렸습니다.=[5]= ");
return;
}
this.gridControl2.Visible = true;
this.gridControl1.Visible = true;
this.panelControl2.Visible = true;
this.panelControl1.Visible = false;
this.panelControl3.Visible = true;
Cls.Grid.GridStyle gs = new Cls.Grid.GridStyle(this.gridControl1, this.gridView1);
gs.AddColumn("코드", "BIZ_CODE", Cls.Grid._ColumnType.Default, 40, Cls.Grid._ColumnAlign.Center);
gs.AddColumn("사업장", "BIZ_NAME", Cls.Grid._ColumnType.Default, 100, Cls.Grid._ColumnAlign.Left);
gs.AddColumn("다운로드 URL", "FILE_URI", Cls.Grid._ColumnType.Default, 200, Cls.Grid._ColumnAlign.Left, true, true);
gs.AddColumn("통신서버 URL", "DB_URI", Cls.Grid._ColumnType.Default, 200, Cls.Grid._ColumnAlign.Left, true, true);
Cls.Grid.GridStyle gs1 = new Cls.Grid.GridStyle(this.gridControl2, this.gridView2);
gs1.AddColumn("코드", "VAN_TYPE", Cls.Grid._ColumnType.Default, 40, Cls.Grid._ColumnAlign.Center);
gs1.AddColumn("코드명", "VAN_NAME", Cls.Grid._ColumnType.Default, 60, Cls.Grid._ColumnAlign.Left);
gs1.AddColumn("리얼서버IP", "SERVER_IP", Cls.Grid._ColumnType.Default, 200, Cls.Grid._ColumnAlign.Left, true, true);
gs1.AddColumn("리얼서버Port", "SERVER_PORT", Cls.Grid._ColumnType.Default, 60, Cls.Grid._ColumnAlign.Left, true, true);
gs1.AddColumn("테스트서버IP", "TEST_IP", Cls.Grid._ColumnType.Default, 200, Cls.Grid._ColumnAlign.Left, true, true);
gs1.AddColumn("테스트서버Port", "TEST_PORT", Cls.Grid._ColumnType.Default, 60, Cls.Grid._ColumnAlign.Left, true, true);
gs1.AddColumn("테스트서버TID", "TEST_TID", Cls.Grid._ColumnType.Default, 60, Cls.Grid._ColumnAlign.Left, true, true);
DataTable dts = Parm.mDataTable.dtConnectInfo.Copy();
this.gridControl1.DataSource = dts;
DataTable dty = Parm.mDataTable.dtVanInfo.Copy();
this.gridControl2.DataSource = dty;
//dts.Columns.Add("DownLoad");
//dts.Columns.Add("DataBase");
//dts.Columns.Add("Change");
//for(int i = 0; i < dts.Rows.Count; i++)
//{
// dts.Rows[i]["DownLoad"] = "파일수정";
// dts.Rows[i]["DataBase"] = "파일수정";
// dts.Rows[i]["Change"] = "변수할당";
//}
//Cls.Grid.Options.FixedColumn(this.gridView1,new string[]{ "DownLoad" ,"DataBase" , "Change"}, Cls.Grid.PositionStyle.Left);
//Cls.Grid.Options.SetColumnColor( this.gridView1, Cls.Grid.StyleFormatConditionType.Column ,
// this.gridView1.Columns["DataBase"], DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual , Color.Pink, null);
//Cls.Grid.Options.SetColumnColor( this.gridView1, Cls.Grid.StyleFormatConditionType.Column ,
// this.gridView1.Columns["DownLoad"], DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual , Color.Pink, null);
//Cls.Grid.Options.SetColumnColor( this.gridView1, Cls.Grid.StyleFormatConditionType.Column ,
// this.gridView1.Columns["Change"], DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual , Color.LightBlue, null);
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
}
