private void Init_vs()
{
PublicFunction.InitNav(this, vs, nav, this.Name + "000_vs");
nav.TBForm = "GP_SYS_SQL_FROM";
nav.TBSelect = "GP_SYS_SQL_SELECT";
nav.Init_Control();
nav.cmd_copy.Visible = false;
nav.cmd_delete.Visible = false;
vs.SelectionMode = C1.Win.C1FlexGrid.SelectionModeEnum.RowRange;
vs.Cols.Frozen = vs.Cols["EMP_NM"].Index;
vs.Cols["EMP_I1"].Style.BackColor = Color.PeachPuff;
vs.Cols["ATT_DY"].Format = "#,##0.0000";
vs.Cols["NIG_DY"].Format = "#,##0.0000";
string sql = "Select FNAME," + PublicFunction.L_Lag + " from SYS_LABEL where [NAME]=N'frmTaMonthAddUpCal' and (FName='1' or FName='2' or FName='3' or FName='4')";
vs.Cols["SEQ_NO"].DataMap = PublicFunction.InitCBForVS(sql);
vs.EnabledChanged += new EventHandler(vs_EnabledChanged);
// nav.ToolBar_Auto=false;
//nav.TBarClick+=new ToolBarButtonClickEventHandler(nav_TBarClick);
vs.AfterEdit += new C1.Win.C1FlexGrid.RowColEventHandler(vs_AfterEdit);
vs.BeforeEdit += new C1.Win.C1FlexGrid.RowColEventHandler(vs_BeforeEdit);
vs.Cols["LOC_B1"].Style.BackColor = Color.Silver;
vs.Styles.Add("VAC_BT");
vs.Styles["VAC_BT"].BackColor = Color.DarkGray;
sql = "Select TYP_ID from GP_SYS_SHIFT";
rs1 = new Func.RecordSet(sql, PublicFunction.C_con);
sql = "Select COL_NM from FILC07A";
rs2 = new Func.RecordSet(sql, PublicFunction.C_con);
nav.ToolBar_Auto = false;
nav.TBarClick += new ToolBarButtonClickEventHandler(nav_TBarClick);
}
private void frmUser_Load(object sender, System.EventArgs e)
{
Func.Fun.ExecuteSQL("Delete from SYS_USER where GROUP_ID not in(Select GROUP_ID from SYS_GROUP)", PublicFunction.C_con, true);
nav1.Grid = vs;
nav1.FormName = this.Name + "_vs";
nav1.Connection = Function.PublicFunction.C_con;
nav1.Init_Control();
nav1.Show_VS("GROUP_ID=N'" + Group_ID + "'");
nav1.Security = (int)this.Tag;
nav1.UserID = PublicFunction.A_UserID;
nav1.ToolBar_Auto = false;
nav1.form = this;
PublicFunction.L_Init_Label(this);
txt1.ReadOnly = txt2.ReadOnly = txt3.ReadOnly = txt4.ReadOnly = true;
//show_txt();
}
private void frmUser_Load(object sender, System.EventArgs e)
{
nav1.cmd_copy.Visible = false;
nav1.cmd_search.Visible = false;
nav1.cmd_report.Visible = false;
nav1.Grid = vs;
nav1.FormName = this.Name + "_vs";
nav1.Connection = Function.PublicFunction.C_con;
nav1.Init_Control();
nav1.Show_VS();
nav1.Security = (int)this.Tag;
nav1.UserID = PublicFunction.A_UserID;
nav1.ToolBar_Auto = false;
nav1.form = this;
PublicFunction.L_Init_Label(this);
txt1.ReadOnly = txt2.ReadOnly = txt3.ReadOnly = txt4.ReadOnly = true;
}
private void frmControlTable_Load(object sender, System.EventArgs e)
{
Func.Fun.ExecuteSQL("Delete from SYS_SQL_SELECT where [ID] not in(Select ID from SYS_SQL_FROM)", PublicFunction.C_con, true);
nav2.cmd_search.Visible = false;
nav2.cmd_report.Visible = false;
nav2.cmd_copy.Visible = false;
nav2.Grid = vs1;
nav2.FormName = this.Name + "_vs1";
nav2.Connection = Function.PublicFunction.C_con;
nav2.Init_Control();
nav2.ToolBar_Auto = false;
nav2.form = this;
nav1.cmd_search.Visible = false;
nav1.cmd_report.Visible = false;
nav1.cmd_copy.Visible = false;
nav1.Grid = vs;
nav1.FormName = this.Name + "_vs";
nav1.Connection = Function.PublicFunction.C_con;
nav1.Init_Control();
nav1.Show_VS();
Show_VS1();
nav3.cmd_copy.Visible = false;
nav3.cmd_report.Visible = false;
nav3.cmd_search.Visible = false;
nav3.Grid = vs2;
nav3.FormName = this.Name + "_vs2";
nav3.Connection = Function.PublicFunction.C_con;
nav3.Init_Control();
nav3.ToolBar_Auto = false;
nav3.TBarClick += new ToolBarButtonClickEventHandler(nav3_TBarClick);
vs2.AfterEdit += new C1.Win.C1FlexGrid.RowColEventHandler(vs2_AfterEdit);
//PublicFunction.L_Init_Label(this);
nav1.Init_PMenu_Color();
nav2.Init_PMenu_Color();
Init_Tree();
c1DockingTab1.SelectedIndex = 0;
}
private void frmSysMenu_Load(object sender, System.EventArgs e)
{
nav1.Grid = vs;
nav1.FormName = this.Name + "_vs";
nav1.Connection = Function.PublicFunction.C_con;
nav1.ConnectionDel = Function.PublicFunction.C_condel;
nav1.UserID = Function.PublicFunction.A_UserID;
nav1.Init_Control();
nav1.Show_VS();
nav1.form = this;
PublicFunction.L_Init_Label(this);
TreeNode node = new TreeNode("Root");
Tree.Nodes.Add(node);
Init_Tree(node, -1);
Tree.SelectedNode = node;
}
private void frmLabel_Load(object sender, System.EventArgs e)
{
nav1.cmd_search.Visible = false;
nav1.cmd_report.Visible = false;
nav1.Grid = vs1;
nav1.FormName = this.Name + "_vs1";
nav1.Connection = PublicFunction.C_con;
nav1.Init_Control();
nav1.Init_PMenu_Color();
nav1.Show_VS();
nav2.cmd_search.Visible = false;
nav2.cmd_report.Visible = false;
nav2.Grid = vs2;
nav2.FormName = this.Name + "_vs2";
nav2.Connection = PublicFunction.C_con;
nav2.Init_Control();
nav2.Init_PMenu_Color();
nav2.Show_VS(LB);
nav3.cmd_search.Visible = false;
nav3.cmd_report.Visible = false;
nav3.Grid = vs3;
nav3.FormName = this.Name + "_vs3";
nav3.Connection = PublicFunction.C_con;
nav3.Init_Control();
nav3.Init_PMenu_Color();
nav3.Show_VS();
nav4.cmd_search.Visible = false;
nav4.cmd_report.Visible = false;
nav4.Grid = vs4;
nav4.FormName = this.Name + "_vs4";
nav4.Connection = PublicFunction.C_con;
nav4.Init_Control();
nav4.Init_PMenu_Color();
nav4.Show_VS(LB);
for (int i = 4; i < vs2.Cols.Count - 1; i++)
{
vs2.Cols[i].Width = 500;
// vs2.AllowResizing();
vs2.AutoSizeRows();
}
for (int i = 4; i < vs1.Cols.Count - 1; i++)
{
vs1.Cols[i].Width = 500;
vs1.AutoSizeRows();
}
for (int i = 4; i < vs4.Cols.Count - 1; i++)
{
vs4.Cols[i].Width = 500;
// vs4.AllowResizing();
vs4.AutoSizeRows();
}
// nav5.cmd_search.Visible=false;
// nav5.cmd_report.Visible=false;
// nav5.Grid=vs5;
// nav5.FormName=this.Name+"_vs5";
// nav5.Connection=PublicFunction.C_con;
//
//// nav5.Init_Control();
//// nav5.Init_PMenu_Color();
//// nav5.Show_VS(RPT);
//
// nav6.cmd_search.Visible=false;
// nav6.cmd_report.Visible=false;
// nav6.Grid=vs6;
// nav6.FormName=this.Name+"_vs6";
// nav6.Connection=PublicFunction.C_con;
// nav6.Init_Control();
// nav6.Init_PMenu_Color();
// nav6.Show_VS(PMENU);
}
private void frmSecurity_Load(object sender, System.EventArgs e)
{
lag = PublicFunction.L_Lag;
Func.Fun.ExecuteSQL("Delete from SYS_SECURITY where MNU_ID not in(Select ID from SYS_MENU)", PublicFunction.C_con, true);
Func.Fun.ExecuteSQL("Delete from SYS_SECURITY where GROUP_ID not in(Select GROUP_ID from SYS_GROUP)", PublicFunction.C_con, true);
nav2.cmd_search.Visible = false;
nav2.cmd_report.Visible = false;
nav2.cmd_copy.Visible = false;
nav2.cmd_delete.Visible = false;
nav2.cmd_add.Visible = false;
nav2.cmd_refresh.Visible = false;
nav2.Grid = vs1;
nav2.FormName = this.Name + "_vs1";
nav2.Connection = Function.PublicFunction.C_con;
// Security
nav2.Security = (int)this.Tag;
nav2.UserID = PublicFunction.A_UserID;
//
//nav2.TableName="SYS_SECURITY";
nav2.Init_Control();
nav2.form = this;
nav1.cmd_search.Visible = false;
nav1.cmd_report.Visible = false;
nav1.cmd_copy.Visible = false;
nav1.cmd_fisrt.Visible = false;
nav1.cmd_last.Visible = false;
nav1.Grid = vs;
nav1.FormName = this.Name + "_vs";
nav1.Connection = Function.PublicFunction.C_con;
// Security
nav1.Security = (int)this.Tag;
nav1.UserID = PublicFunction.A_UserID;
// Security
nav1.Init_Control();
nav1.Show_VS();
init_vs3();
PublicFunction.L_Init_Label(this);
// nav1.Init_PMenu_Color();
// nav2.Init_PMenu_Color();
vs1.Cols["SYSSEL"].Visible = false;
nav2.ToolBar_Auto = true;
vs1.AfterEdit += new C1.Win.C1FlexGrid.RowColEventHandler(vs1_AfterEdit);
vs1.BeforeEdit += new C1.Win.C1FlexGrid.RowColEventHandler(vs1_BeforeEdit);
vs1.SelectionMode = C1.Win.C1FlexGrid.SelectionModeEnum.CellRange;
vs1.CellButtonClick += new C1.Win.C1FlexGrid.RowColEventHandler(vs1_CellButtonClick);
vs1.Styles.Add("DEP_ID");
vs1.Styles["DEP_ID"].Font = new Font(vs1.Font, FontStyle.Bold);
vs1.Styles["DEP_ID"].BackColor = Color.LemonChiffon;
vs1.Styles.Add("POS_BT");
vs1.Styles["POS_BT"].Font = new Font(vs1.Font, FontStyle.Bold);
vs1.Styles["POS_BT"].BackColor = Color.Silver;
vs1.Cols["EN"].ComboList = "...";
vs1.Cols["CH"].ComboList = "...";
vs1.Cols["VN"].ComboList = "...";
vs1.Cols["TYP"].ComboList = "...";
vs1.Cols["EN"].AllowEditing = true;
vs1.Cols["VN"].AllowEditing = true;
vs1.Cols["CH"].AllowEditing = true;
Show_VS1();
}