private void frmTaBonusAndFined_Load(object sender, System.EventArgs e)
{
nav.cmd_copy.Visible = false;
nav.cmd_report.Visible = false;
nav.cmd_search.Visible = false;
PublicFunction.InitNav(this, vs, nav);
nav.Msg_ExitSave = true;
nav.Show_VS();
nav1.cmd_copy.Visible = false;
nav1.cmd_report.Visible = false;
nav1.cmd_search.Visible = false;
PublicFunction.InitNav(this, vs1, nav1);
nav.Msg_ExitSave = true;
show_vs1();
nav.ToolBar_Auto = false;
Basic.Function.PublicFunction.L_Init_Label(this);
nav.TBarClick += new ToolBarButtonClickEventHandler(nav_TBarClick);
nav1.TBarClick += new ToolBarButtonClickEventHandler(nav1_TBarClick);
vs1.Cols["AMT_QT"].Format = "#,###";
nav1.ToolBar_Auto = false;
string sql = "Select VAC_ID,VAC_NM from FILA06A";
vs1.Cols["VAC_ID"].DataMap = PublicFunction.InitCBForVS(sql);
vs.AfterRowColChange += new C1.Win.C1FlexGrid.RangeEventHandler(vs_AfterRowColChange);
vs1.Cols["TPE_ID"].DataType = typeof(Boolean);
}
private void Show_VS1()
{
if (vs.Row > 0 && nav1.State)
{
nav2.Show_VS("[ID]=N'" + vs.Rows[vs.Row]["ID"] + "' ORDER BY SEQ");
}
}
private void Init_VS()
{
PublicFunction.InitNav(this, vs, nav);
nav.Show_VS(" 1=1 order by TRN_DT DESC");
vs.Cols["ATT_DT"].Format = PublicFunction.GetOption("DATE");
vs.Cols["INN_NO"].ComboList = "In1|In2|In3|In4";
System.Data.SqlClient.SqlConnection con = PublicFunction.connect(PublicFunction.DTGP_server, PublicFunction.DTGP_database
, PublicFunction.DTGP_username, PublicFunction.DTGP_password);
string sql = "Select SHI_ID from FILC02A";
Func.RecordSet rs = new Func.RecordSet(sql, con);
sql = "";
for (int i = 0; i < rs.rows; i++)
{
if (sql != "")
{
sql += "|";
}
sql += rs.record(i, 0);
}
vs.Cols["SHI_ID"].ComboList = sql;
this.vs.AfterRowColChange += new C1.Win.C1FlexGrid.RangeEventHandler(this.vs_AfterRowColChange);
nav.ToolBar_Auto = false;
nav.TBarClick += new ToolBarButtonClickEventHandler(nav_TBarClick);
con.Close();
}
private void frmTaRace_Load(object sender, System.EventArgs e)
{
nav.cmd_copy.Visible = false;
nav.cmd_report.Visible = false;
nav.cmd_search.Visible = false;
PublicFunction.InitNav(this, vs, nav);
nav.Msg_ExitSave = true;
nav.Show_VS();
nav.ToolBar_Auto = false;
Basic.Function.PublicFunction.L_Init_Label(this);
nav.TBarClick += new ToolBarButtonClickEventHandler(nav_TBarClick);
if (a)
{
try
{
vs.Cols["LEA_DY"].Visible = false;
vs.Cols["STR_DT"].Visible = false;
vs.Cols["WAG_MM"].Visible = false;
// vs.Cols["SEN_YY"].Visible=false;
vs.Cols["SEN_DY"].Visible = false;
}
catch (Exception) {}
}
else
{
vs.Cols["NEW_OD"].AllowEditing = false;
nav.cmd_add.Visible = false;
nav.cmd_delete.Visible = false;
//vs.Cols["LEA_DY"].AllowEditing=false;
}
vs.AfterEdit += new C1.Win.C1FlexGrid.RowColEventHandler(vs_AfterEdit);
this.Closed += new EventHandler(frmTaRace_Closed);
}
private void nav_TBarClick(object sender, ToolBarButtonClickEventArgs e)
{
if (e.Button.Equals(nav.cmd_refresh))
{
if (nav.wh != "")
{
nav.ToolBar_Click(e);
}
else
{
nav.Show_VS("YYY_MM=N'" + dt3.Text + "' and DEP_ID in " + T_String.DEP_ID(this.Tag));
}
show_cn();
return;
}
nav.ToolBar_Click(e);
}
private void init_vs()
{
PublicFunction.InitNav(this, vs, nav);
vs.SelectionMode = C1.Win.C1FlexGrid.SelectionModeEnum.CellRange;
nav.Show_VS();
nav.cmd_copy.Visible = nav.cmd_report.Visible = nav.cmd_search.Visible = false;
vs.AfterEdit += new C1.Win.C1FlexGrid.RowColEventHandler(vs_AfterEdit);
}
private void Show_VS()
{
string sql, wh;
if (Dep.vs1.Row < 0)
{
vs.Rows.Count = 1;
return;
}
string dk = Dep.Get_Data("DEP_ID");
if (ck.Checked)
{
if (dk + "" != "")
{
sql = "b.DEP_ID=N'" + Dep.Get_Data("DEP_ID") + "' and (DEL_BT=0 or DEL_BT is null) and (ATT_DT Between '"
+ ((DateTime)dt1.Value).ToString("yyyy/MM/dd") + "' and '"
+ ((DateTime)dt2.Value).ToString("yyyy/MM/dd") + "')";
}
else
{
sql = "b.DEP_ID in " + T_String.DEP_ID(this.Tag) + " and (DEL_BT=0 or DEL_BT is null) and (ATT_DT Between '"
+ ((DateTime)dt1.Value).ToString("yyyy/MM/dd") + "' and '"
+ ((DateTime)dt2.Value).ToString("yyyy/MM/dd") + "')";
}
}
else
{
if (dk + "" != "")
{
sql = "b.DEP_ID=N'" + Dep.Get_Data("DEP_ID") + "' and (DEL_BT=0 or DEL_BT is null)";
}
else
{
sql = "b.DEP_ID in " + T_String.DEP_ID(this.Tag) + " and (DEL_BT=0 or DEL_BT is null)";
}
}
wh = GetWh();
if (wh != "")
{
sql += " and (" + wh + ")";
}
nav.Show_VS(sql);
CheckCols();
}
private void show_vs1()
{
if (vs.Row < 1)
{
vs1.Rows.Count = 1;
return;
}
nav1.Show_VS("a.BAF_ID=N'" + vs.Rows[vs.Row]["BAF_ID"] + "'");
}
private void frmTaLB_Load(object sender, System.EventArgs e)
{
//nav.cmd_copy.Visible=false;
nav.cmd_report.Visible = false;
nav.cmd_search.Visible = false;
PublicFunction.InitNav(this, vs, nav);
nav.Show_VS();
Basic.Function.PublicFunction.L_Init_Label(this);
}
private void Show_VS1()
{
if (vs1.Row <= 0)
{
vs.Rows.Count = 1;
return;
}
nav.Show_VS("EMP_ID=N'" + vs1.Rows[vs1.Row]["EMP_ID"] + "' ");
}
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 button1_Click(object sender, System.EventArgs e)
{
if (vs1.Row <= 0)
{
vs2.Rows.Count = 1;
return;
}
nav3.Show_VS("NAME=N'" + vs1.Rows[vs1.Row]["ID"] + "'");
}
private void Show_vs1()
{
if (vs.Row <= 0)
{
vs1.Rows.Count = 1;
return;
}
nav1.Show_VS("STY_NO=N'" + vs.Rows[vs.Row]["STY_NO"] + "' Order BY SEQ_NO");
CAL_TT();
}
private void show_vs1()
{
if (vs.Row <= 0)
{
vs1.Rows.Count = 1;
return;
}
nav1.Show_VS("SHI_ID=N'" + vs.Rows[vs.Row]["SHI_ID"] + "' ORDER BY SEQ_NO");
lb.Text = vs.Rows[vs.Row]["SHI_NM"] + "";
}
private void frmTaAddNote_Load(object sender, System.EventArgs e)
{
nav.cmd_fisrt.Visible = false;
nav.cmd_last.Visible = false;
nav.cmd_next.Visible = false;
nav.cmd_previous.Visible = false;
nav.cmd_copy.Visible = false;
nav.cmd_report.Visible = false;
nav.cmd_search.Visible = false;
PublicFunction.InitNav(this, vs, nav);
nav.Msg_ExitSave = true;
nav.Show_VS("1=1 ORDER BY MON_QT");
vs.Cols["MON_QT"].Format = "#,###";
nav.ToolBar_Auto = false;
Basic.Function.PublicFunction.L_Init_Label(this);
nav.TBarClick += new ToolBarButtonClickEventHandler(nav_TBarClick);
}
private void Show_VS()
{
string sql;
if (Dep.vs1.Row < 0)
{
vs.Rows.Count = 1;
return;
}
if (ck.Checked)
{
sql = "DEP_ID=N'" + Dep.Get_Data("DEP_ID") + "' and (DEL_BT=0 or DEL_BT is null) and YYY_MM='" + dt1.Text + "' and DEP_ID in " + T_String.DEP_ID(this.Tag);
}
else
{
sql = "DEP_ID=N'" + Dep.Get_Data("DEP_ID") + "' and (DEL_BT=0 or DEL_BT is null) and DEP_ID in " + T_String.DEP_ID(this.Tag);
}
nav.Show_VS(sql);
CheckCols();
}
private void frmTaSetting_Load(object sender, System.EventArgs e)
{
PublicFunction.InitNav(this, vs, nav);
nav.Show_VS();
vs.EnabledChanged += new EventHandler(vs_EnabledChanged);
nav.TBarClick += new ToolBarButtonClickEventHandler(nav_TBarClick);
nav.ToolBar_Auto = false;
show_data();
Basic.Function.PublicFunction.L_Init_Label(this);
tinhgio();
}
private void Init_vs()
{
nav.cmd_copy.Visible = false;
nav.cmd_report.Visible = false;
nav.cmd_search.Visible = false;
PublicFunction.InitNav(this, vs, nav);
nav.Show_VS();
nav.ToolBar_Auto = false;
nav.TBarClick += new ToolBarButtonClickEventHandler(nav_TBarClick);
vs.AfterRowColChange += new C1.Win.C1FlexGrid.RangeEventHandler(vs_AfterRowColChange);
}
private void Init_vs()
{
nav.cmd_copy.Visible = false;
nav.cmd_report.Visible = false;
nav.cmd_search.Visible = false;
nav.cmd_delete.Visible = false;
nav.cmd_add.Visible = false;
nav.cmd_save.Visible = false;
PublicFunction.InitNav(this, vs, nav);
vs.Cols["COL"].DataType = typeof(Boolean);
nav.Show_VS("BAS_BT=0 or BAS_BT is null order by SEQ_NO");
}
private void frmTaSetting_Load(object sender, System.EventArgs e)
{
PublicFunction.InitNav(this, vs, nav);
nav.Show_VS("EMP_ID=N'" + EMP_ID + "'");
nav.ToolBar_Auto = false;
show_data();
Basic.Function.PublicFunction.L_Init_Label(this);
TextBoxAndVS.L_GetLabelFromVS(groupBox1, vs);
dt_PAS_ED.CustomFormat = dt_PAS_ST.CustomFormat = dt_VIS_ED.CustomFormat = dt_VIS_ST.CustomFormat =
dt_WRK_ED.CustomFormat = dt_WRK_ST.CustomFormat = dt_PAS_ED.CustomFormat = PublicFunction.GetOption("DATE");
}
private void Init_vs()
{
nav.cmd_report.Visible = false;
nav.cmd_copy.Visible = false;
nav.cmd_search.Visible = false;
nav.cmd_add.Visible = false;
nav.cmd_add.Visible = false;
PublicFunction.InitNav(this, vs, nav);
nav.Show_VS();
nav.ToolBar_Auto = false;
nav.TBarClick += new ToolBarButtonClickEventHandler(nav_TBarClick);
}
private void frmTaHRReport_Load(object sender, System.EventArgs e)
{
PublicFunction.InitNav(this, vs, nav);
vs.EnabledChanged += new EventHandler(vs_EnabledChanged);
Basic.Function.PublicFunction.L_Init_Label(this);
nav.Show_VS("[NAME]=N'MAN_" + PublicFunction.CUS_ID + "' or [NAME]=N'MAN_0'");
dt_dt1.CustomFormat = dt_dt2.CustomFormat = PublicFunction.GetOption("DATE");
control1.InitCB(this.Tag);
control1.Initlabel();
vs.AfterRowColChange += new C1.Win.C1FlexGrid.RangeEventHandler(vs_AfterRowColChange);
Show_con();
}
private void Init_vs()
{
nav.cmd_copy.Visible = false;
nav.cmd_report.Visible = false;
nav.cmd_search.Visible = false;
nav.cmd_delete.Visible = false;
nav.cmd_add.Visible = false;
nav.cmd_save.Visible = false;
PublicFunction.InitNav(this, vs, nav);
nav.Show_VS("BAS_BT=1 order by SEQ_NO");
vs.DoubleClick += new EventHandler(vs_DoubleClick);
}
private void frmTaJuryType_Load(object sender, System.EventArgs e)
{
nav.cmd_copy.Visible = false;
nav.cmd_report.Visible = false;
nav.cmd_search.Visible = false;
PublicFunction.InitNav(this, vs, nav);
nav.Msg_ExitSave = true;
nav.Show_VS();
nav.ToolBar_Auto = false;
Basic.Function.PublicFunction.L_Init_Label(this);
nav.TBarClick += new ToolBarButtonClickEventHandler(nav_TBarClick);
}
private void txt1_KeyDown(object sender, System.Windows.Forms.KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
if (txt1.Text == "")
{
string sql = "ONN_01>0 and a.EMP_ID is not null and a.EMP_ID<>'' and (ATT_DT Between '"
+ ((DateTime)dt1.Value).ToString("yyyy/MM/dd") + "' and '"
+ ((DateTime)dt2.Value).ToString("yyyy/MM/dd") + "') order by a.EMP_ID,ATT_DT";
nav.Show_VS(sql);
Show_VS();
}
else
{
string sql = "ONN_01>0 and a.EMP_ID is not null and a.EMP_ID<>'' and (ATT_DT Between '"
+ ((DateTime)dt1.Value).ToString("yyyy/MM/dd") + "' and '"
+ ((DateTime)dt2.Value).ToString("yyyy/MM/dd") + "' and a.EMP_ID='" + txt1.Text + "') order by a.EMP_ID,ATT_DT";
nav.Show_VS(sql);
Show_VS();
}
}
}
private void show_vs()
{
string sql = "";
if (ck.Checked)
{
sql = "(ATT_DT between '" + DateTime.Parse(dt1.Value + "").ToString("yyyy/MM/dd") + "' and '" +
DateTime.Parse(dt2.Value + "").ToString("yyyy/MM/dd") + "') ";
}
if (ck1.Checked)
{
if (sql != "")
{
sql += " and ";
}
sql += " INN_NO=N'" + cb.Text + "' ";
}
if (ck3.Checked)
{
if (sql != "")
{
sql += " and ";
}
sql += "( WOK_TM=0 or WOK_TM is null)";
}
if (sql != "")
{
sql += " and ";
}
if (Dep.Get_Data("DEP_ID") + "" != "")
{
sql += "DEP_ID=N'" + Dep.Get_Data("DEP_ID") + "' and (DEL_BT=0 or DEL_BT is null)";
}
else
{
sql += "b.DEP_ID in " + T_String.DEP_ID(this.Tag) + " and (DEL_BT=0 or DEL_BT is null)";
}
nav.Show_VS(sql);
}
private void frmTaViewNatureSwitching_Load(object sender, System.EventArgs e)
{
PublicFunction.InitNav_dlg(this, vs, nav);
Basic.Function.PublicFunction.L_Init_Label(this);
vs.Cols["SWI_DT"].DataType = typeof(System.DateTime);
vs.Cols["SWI_DT"].Format = PublicFunction.GetOption("DATE");
//Nature
string sql = "Select TYP_ID,TYP_NM from FILA11A";
vs.Cols["TYP_I1"].DataMap = PublicFunction.InitCBForVS(sql, false);
vs.Cols["TYP_I2"].DataMap = PublicFunction.InitCBForVS(sql, false);
nav.Show_VS("a.EMP_ID='" + EMP_ID + "' AND YEAR(SWI_DT)=" + dtt.Year);
}
private void Init_vs()
{
nav.cmd_copy.Visible = false;
nav.cmd_report.Visible = false;
nav.cmd_search.Visible = false;
nav.cmd_delete.Visible = false;
nav.cmd_add.Visible = false;
nav.cmd_save.Visible = false;
PublicFunction.InitNav(this, vs, nav);
vs.Cols["COL"].DataType = typeof(Boolean);
nav.Show_VS("(BAS_BT=0 or BAS_BT is null) and QIN_BT=1 order by SEQ_NO");
//nav.Show_VS("(ACC_BT=0 or ACC_BT is null) AND (HUR_BT=0 OR HUR_BT IS NULL) order by SEQ_NO");
}
private void frmTaSecurityByDep_Load(object sender, System.EventArgs e)
{
string sql;
sql = "Delete from SYS_SECURITY_TYP where TYP_ID not in (Select TYP_ID from FILA11A )";
PublicFunction.SQL_Execute(sql);
sql = "Delete from SYS_SECURITY_TYP where USER_ID not in (Select USER_ID from SYS_USER )";
PublicFunction.SQL_Execute(sql);
sql = "Delete from SYS_SECURITY_TYP where MNU_ID not in (Select ID as MNU_ID from SYS_MENU where DEP_BT=1)";
PublicFunction.SQL_Execute(sql);
nav.cmd_copy.Visible = false;
nav.cmd_report.Visible = false;
nav.cmd_search.Visible = false;
PublicFunction.InitNav(this, vs, nav);
nav.Show_VS("GROUP_ID=N'" + GROUP_ID + "'");
vs1.Cols.Count = 3;
vs1.Cols[1].Name = "TYP_NM";
vs1.Cols[0].Name = "TYP_ID";
vs1.Cols[0].Visible = false;
vs1.Cols[2].Name = "ALL_BT";
vs1.Cols[1].AllowEditing = false;
vs1.Cols[2].DataType = typeof(System.Boolean);
vs1.Tree.Column = 1;
PublicFunction.L_Init_Label(this);
nav1.form = this;
nav1.TBarClick += new ToolBarButtonClickEventHandler(nav1_TBarClick);
nav1.cmd_add.Visible = nav1.cmd_copy.Visible = nav1.cmd_delete.Visible =
nav1.cmd_fisrt.Visible = nav1.cmd_last.Visible = nav1.cmd_next.Visible =
nav1.cmd_previous.Visible = nav1.cmd_refresh.Visible = nav1.cmd_report.Visible =
nav1.cmd_refresh.Visible = nav1.cmd_search.Visible = false;
Init_Tree();
edit = false;
vs.AfterRowColChange += new RangeEventHandler(vs_AfterRowColChange);
vs1.AfterEdit += new RowColEventHandler(vs1_AfterEdit);
label5.Text = label5.Text + " - " + label;
this.Text = label5.Text;
for (int i = 1; i < vs.Rows.Count; i++)
{
if ((vs.Rows[i]["USER_ID"] + "").ToUpper() == PublicFunction.A_UserID.ToUpper())
{
vs.Row = i;
break;
}
}
}
private void frmTaHoliday_Load(object sender, System.EventArgs e)
{
dt.Value = T_String.GetDate();
nav.cmd_add.Visible = false;
nav.cmd_delete.Visible = false;
nav.cmd_copy.Visible = false;
nav.cmd_report.Visible = false;
nav.cmd_search.Visible = false;
PublicFunction.InitNav(this, vs, nav);
nav.Msg_ExitSave = true;
nav.Show_VS("YYY_YY=N'" + dt.Text + "'");
Basic.Function.PublicFunction.L_Init_Label(this);
for (int i = 3; i < vs.Cols.Count; i++)
{
vs.Cols[i].Caption = vs.Cols[i].Name.Replace("h", "");
}
insert();
dt.TextChanged += new EventHandler(dt_TextChanged);
vs.SelectionMode = C1.Win.C1FlexGrid.SelectionModeEnum.CellRange;
vs.AfterEdit += new C1.Win.C1FlexGrid.RowColEventHandler(vs_AfterEdit);
}