public DataTable CT_EMPLOYEE_GetListBirthdayByMonth(int _Month)
{
string procname = "CT_EMPLOYEE_GetListBirthdayByMonth";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@Month", _Month);
DataTable dt = db.ExecuteDataTable(procname);
dt.Columns.Add("Day", Type.GetType("System.String"));
for (int i = 0; i < dt.Rows.Count; i++)
{
string txt = ((DateTime)dt.Rows[i]["BirthDay"]).Day.ToString();
if (txt.Length == 1)
{
txt = "0" + txt;
}
dt.Rows[i]["Day"] = txt;
}
DataView dv = dt.DefaultView;
dv.Sort = "Day ASC";
dt = dv.ToTable();
return(dt);
}
public string GetNewCode()
{
string procname = "HRM_EMPLOYEE_SEASON_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
DataTable dt = db.ExecuteDataTable(procname);
if (dt.Rows.Count > 0)
{
string _strCode = dt.Rows[dt.Rows.Count - 1][0].ToString();
_strCode = _strCode.Substring(2, _strCode.Length - 2);
int next_id = int.Parse(_strCode) + 1;
switch (next_id.ToString().Length)
{
case 1:
return("TV00" + next_id.ToString());
case 2:
return("TV0" + next_id.ToString());
case 3:
return("TV" + next_id.ToString());
}
}
return("TV001");
}
public DataTable CT_TIMEKEEPER_TABLE_GetList()
{
string procname = "CT_TIMEKEEPER_TABLE_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@TimeKeeperTableListID", TimeKeeperTableListID);
DataTable dt = db.ExecuteDataTable(procname);
// tinh tong phep theo thang
dt.Columns.Add("PN", typeof(float));
dt.Columns.Add("HL", typeof(float));
dt.Columns.Add("BH", typeof(float));
dt.Columns.Add("KL", typeof(float));
dt.Columns.Add("KP", typeof(float));
dt.Columns.Add("LD", typeof(float));
dt.Columns.Add("NB", typeof(float));
dt.Columns.Add("OFF", typeof(float));
dt.Columns.Add("PB", typeof(float));
dt.Columns.Add("TD", typeof(float));
dt.Columns.Add("NC", typeof(float));
dt.Columns.Add("IsUpdate");
dt.Columns.Add("PrintAllow", typeof(bool));
return(dt);
}
public DataTable Loaddanhsachquocgia()
{
string Proced = "CT_NATIONALITY_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(Proced));
}
public DataTable GetAllList_RELATIVE()
{
string procname = "CT_RELATIVE_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(procname));
}
public DataTable LoadDanhSachChiNhanh()
{
string procname = "CT_BRANCH_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(procname));
}
public DataTable HRM_EMPLOYEE_SEASON_GetList()
{
string procname = "HRM_EMPLOYEE_SEASON_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(procname));
}
public DataTable GetAllList_PROFESSIONAL()
{
string procname = "CT_PROFESSIONAL_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(procname));
}
public DataTable Laydanhsachhocvan()
{
string procedname = "CT_EDUCATION_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(procedname));
}
public DataTable Laydanhsachngoaingu()
{
string procedname = "CT_LANGUAGE_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(procedname));
}
public DataTable CT_EMPLOYEE_GetStatistical()
{
string procname = "CT_EMPLOYEE_GetStatistical";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(procname));
}
public DataTable CT_OPTION_LATEOFWORK_GetListEmployee()
{
string procname = "CT_OPTION_LATEOFWORK_GetListEmployee";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(procname));
}
public DataTable GetAlllist_Position()
{
string Procname = "CT_POSITION_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(Procname));
}
public DataTable CHECKINOUT_GetList()
{
string procname = "CHECKINOUT_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(procname));
}
public DataTable Get_All_CT_Province()
{
string procname = "CT_PROVINCE_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(procname));
}
public DataTable GetAllList_GROUP()
{
string procname = "HRM_GROUP_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(procname));
}
public DataTable CT_EMPLOYEE_DEACTIVE_GetList()
{
string procname = "CT_EMPLOYEE_DEACTIVE_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(procname));
}
public DataTable Loadbangcap()
{
string procedname = "CT_DEGREE_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(procedname));
}
public DataTable Danhsachchinhanh()
{
string proced = "CT_BRANCH_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(proced));
}
public static DataTable Log_HeThong()
{
string procname = "CT_LOG_Getlist";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(procname));
}
public DataTable HRM_CONTRACT_SEASON_GetListExpiration()
{
string procname = "HRM_CONTRACT_SEASON_GetListExpiration";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(procname));
}
public DataTable CT_TIMEKEEPER_TABLELIST_GetList()
{
string procname = "CT_TIMEKEEPER_TABLELIST_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(procname));
}
public DataTable CT_CONTRACT_GetCurrentList()
{
string procname = "CT_CONTRACT_GetCurrentList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(procname));
}
public DataTable CT_TIMEKEEPER_SYNTHESIS_GetList(string Thang)
{
string procname = "CT_TIMEKEEPER_SYNTHESIS_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@TimeKeeperTableListID", Thang);
DataTable dt = db.ExecuteDataTable(procname);
// bảo trì không chấm ra -----/// ---- khai thac dich vu
#region bao tri ko cham cong
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// if (dt.Rows[i]["Position"].ToString().ToLower().Contains("bảo trì") || dt.Rows[i]["Position"].ToString().ToLower().Contains("quản lý chung cư"))
// {
// // loai nhung nhan vien van tinh ra trong phong do
// if (dt.Rows[i]["EmployeeCode"].ToString().Contains("LBC0699")) // nhan vien bang trong khai thac dich vu
// {
// }
// else
// {
// for (int j = 0; j < dt.Columns.Count; j++)
// {
// if (dt.Columns[j].ColumnName.StartsWith("D") && dt.Columns[j].ColumnName.Length < 4)
// {
// if (dt.Rows[i][j].ToString().Equals("KR"))
// {
// dt.Rows[i][j] = "1";
// }
// if (dt.Rows[i][j].ToString().StartsWith("S"))
// {
// dt.Rows[i][j] = "1"; // chi co som ko, thi van tinh 1 ca du vi chi cham vao
// }
// if (dt.Rows[i][j].ToString().EndsWith("-KR"))
// {
// dt.Rows[i][j] = dt.Rows[i][j].ToString().Replace("-KR", ""); // bo ko ra o phia sau
// }
// }
// }
// }
// }
//}
#endregion
dt.Columns.Add("Total15");
dt.Columns.Add("TotalNgay15");
dt.Columns.Add("TotalTren15");
dt.Columns.Add("TotalNgayTren15");
return(dt);
}
public DataTable CT_EMPLOYEE_DEACTIVE_GetByEmployeeCode()
{
string procname = "CT_EMPLOYEE_DEACTIVE_GetByEmployeeCode";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@EmployeeCode", EmployeeCode);
return(db.ExecuteDataTable(procname));
}
public DataTable CT_EMPLOYEE_DEACTIVE_GetByYear()
{
string procname = "CT_EMPLOYEE_DEACTIVE_GetByYear";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@Year", Year);
return(db.ExecuteDataTable(procname));
}
public DataTable GetBranchByCode(string strCode)
{
string procname = "CT_BRANCH_Get";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@BranchCode", strCode);
return(db.ExecuteDataTable(procname));
}
public DataTable HRM_CONTRACT_SEASON_GetByEmployee()
{
string procname = "HRM_CONTRACT_SEASON_GetByEmployee";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@EmployeeCode", EmployeeCode);
return(db.ExecuteDataTable(procname));
}
public DataTable HRM_CONTRACT_SEASON_GetByYear()
{
string procname = "HRM_CONTRACT_SEASON_GetByYear";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@ContractYear", ContractYear);
return(db.ExecuteDataTable(procname));
}
public DataTable GetDegreeByCode(string strCode)
{
string procname = "CT_DEGREE_Get";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@DegreeCode", strCode);
return(db.ExecuteDataTable(procname));
}