private void Show_VS()
{
string sql;
if (Dep.vs1.Row < 0)
{
vs.Rows.Count = 1;
return;
}
if (ck.Checked)
{
if (PublicFunction.GetOption("MONTHADDUP") == "1")
{
sql = "DEP_ID in " + Dep.Get_DepAll() + " and (DEL_BT=0 or DEL_BT is null) and DEP_ID in " + T_String.DEP_ID(this.Tag);
}
else
{
sql = "DEP_ID in " + Dep.Get_DepAll() + " and (DEL_BT=0 or DEL_BT is null) and YYY_MM >='" + dt1.Text + "' and YYY_MM <='" + dt2.Text + "' and DEP_ID in " + T_String.DEP_ID(this.Tag);
}
}
else
{
sql = "DEP_ID in " + Dep.Get_DepAll() + " and (DEL_BT=0 or DEL_BT is null) and DEP_ID in " + T_String.DEP_ID(this.Tag);
}
nav.Show_VS(sql + " and SEQ_NO=" + cb_type.Text);
CheckCols();
}
private void Show_VS()
{
if (Dep.vs1.Row <= 0)
{
vs.Rows.Count = 1;
return;
}
if (optAll.Checked == true)
{
nav.Show_VS("DEP_ID in " + Dep.Get_DepAll() + " and YYY_YY=N'" + dt.Text + "' order by a.EMP_ID");
}
else
{
if (optWorking.Checked == true)
{
nav.Show_VS("DEP_ID in " + Dep.Get_DepAll() + " and YYY_YY=N'" + dt.Text + "' and (VAC_BT=0 or VAC_BT is null) order by a.EMP_ID");
}
else
{
nav.Show_VS("DEP_ID in " + Dep.Get_DepAll() + " and YYY_YY=N'" + dt.Text + "' and VAC_BT=1 order by a.EMP_ID");
}
}
// nav.Show_VS("DEP_ID=N'"+Dep.Get_Data("DEP_ID")+"' and (VAC_BT=0 or VAC_BT is null) and YYY_YY=N'"+ dt.Text+"'");
for (int i = 1; i < vs.Rows.Count; i++)
{
// if(vs.Rows[i]["VAC_BT"]+""=="True")
// {
// for(int c=1;c<vs.Cols.Count;c++)
// vs.SetCellStyle(i,c, vs.Styles["VAC_BT"]);
// }
CAL(i);
}
}
private void Show_VS()
{
if (Dep.vs1.Row <= 0)
{
vs.Rows.Count = 1;
return;
}
nav.Show_VS("DEP_ID in " + Dep.Get_DepAll() + " and DEL_BT=1");
}
private void Show_VS()
{
if (Dep.vs1.Row <= 0)
{
vs.Rows.Count = 1;
return;
}
nav.Show_VS("DEP_ID in " + Dep.Get_DepAll() + " and (VAC_BT=0 or VAC_BT is null)"
+ "and YYY_MM=N'" + ((DateTime)dt3.Value).ToString("yyyyMM") + "'");
}
private void Show_VS()
{
if (Dep.vs1.Row <= 0)
{
vs1.Rows.Count = 1;
return;
}
nav1.Show_VS("DEP_ID in " + Dep.Get_DepAll() + " and (SEX_BT=0 or SEX_BT is null)");
Show_VS1();
}
private void Show_VS()
{
if (Dep.vs1.Row <= 0)
{
vs.Rows.Count = 1;
return;
}
if (optAll.Checked == true)
{
nav.Show_VS("DEP_ID in " + Dep.Get_DepAll() + " and YYY_YY=N'" + dt.Text + "' order by a.EMP_ID");
}
else
{
if (optWorking.Checked == true)
{
nav.Show_VS("DEP_ID in " + Dep.Get_DepAll() + " and YYY_YY=N'" + dt.Text + "' and (VAC_BT=0 or VAC_BT is null) order by a.EMP_ID");
}
else
{
nav.Show_VS("DEP_ID in " + Dep.Get_DepAll() + " and YYY_YY=N'" + dt.Text + "' and VAC_BT=1 order by a.EMP_ID");
}
}
// nav.Show_VS("DEP_ID=N'"+Dep.Get_Data("DEP_ID")+"' and (VAC_BT=0 or VAC_BT is null) and YYY_YY=N'"+ dt.Text+"'");
for (int i = 1; i < vs.Rows.Count; i++)
{
if (vs.Rows[i]["VAC_BT"] + "" == "True")
{
for (int c = 1; c < vs.Cols.Count; c++)
{
vs.SetCellStyle(i, c, vs.Styles["VAC_BT"]);
}
}
CAL(i);
if (PublicFunction.GetOption("TYP_BT") == "1") //quang viet
{
if (T_String.IsNullTo0(T_String.GetDataFromSQL("count(*)", "FILB09A", "EMP_ID='" + vs.Rows[i]["EMP_ID"] + "' AND YEAR(SWI_DT)=" + DateTime.Parse(dt.Value + "").Year)) > 0)
{
vs.Rows[i]["TYP_HIS"] = "...NatureSwitching...";
}
}
}
}
private void Show_VS()
{
string sql;
if (Dep.vs1.Row < 0)
{
vs.Rows.Count = 1;
return;
}
if (ck.Checked)
{
sql = "DEP_ID in " + Dep.Get_DepAll() + " 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 in " + Dep.Get_DepAll() + " and (DEL_BT=0 or DEL_BT is null) and DEP_ID in " + T_String.DEP_ID(this.Tag);
}
nav.Show_VS(sql);
CheckCols();
}
