public void insert_fund()
{
string table = "tab_info_fund";
string[] Columns = { "fund_name", "fund_submit_date", "fund_admin_id", "event_status", "fund_code" };
string[] Value = { fund_name, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", en), "1", "S", fund_code };
db.insert_db(table, Columns, Value);
}
public void insert_pay()
{
string table = "tab_emp_pay";
string[] Columns = { "pay_ref_income_id", "pay_amount", "pay_ref_emp_id", "pay_admin_id", "pay_submit_date", "pay_start_date", "pay_end_date", "pay_status", "event_status" };
string[] Value = { pay_ref_income_id, pay_amount, pay_ref_emp_id, "1", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", EN), Convert.ToDateTime(pay_start_date).ToString("yyyy-MM-dd HH:mm:ss", EN), Convert.ToDateTime(pay_end_date).ToString("yyyy-MM-dd HH:mm:ss", EN), "Y", "S" };
db.insert_db(table, Columns, Value);
}
public void insert_minus()
{
string table = "tab_info_minus";
string[] Columns = { "minus_name", "minus_submit_date", "minus_admin_id", "event_status" };
string[] Value = { minus_name, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", en), "1", "S" };
db.insert_db(table, Columns, Value);
}
public void insertPosition()
{
string table = "tab_position";
string[] Columns = { "post_name", "post_admin", "post_submit_date", "event_status" };
string[] Value = { post_name, "1", DateTime.Now.ToString("yyyy-MM-dd", en), "S" };
db.insert_db(table, Columns, Value);
}
public void insertMinusSqlary()
{
CultureInfo en = new CultureInfo("EN");
string table = "tab_emp_minusSalary";
string[] Columns = { "ms_ref_minus_id", "ms_amount", "ms_ref_emp_id", "ms_admin_id", "ms_submit_date", "ms_start_date", "ms_end_date", "ms_status", "event_status" };
string[] Value = { ms_ref_minus_id, ms_amount, ms_ref_emp_id, "1", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", en), Convert.ToDateTime(ms_start_date).ToString("yyyy-MM-dd HH:mm:ss", en), Convert.ToDateTime(ms_end_date).ToString("yyyy-MM-dd HH:mm:ss", en), "Y", "S" };
db.insert_db(table, Columns, Value);
}
public void insertFundRegis()
{
DateTime dt = new DateTime(3000, 01, 01);
string table = "tab_emp_fundRegis";
string[] Columns = { "fr_ref_fund_id", "fr_date_start", "fr_date_end", "fr_ref_emp_id", "fr_admin_id", "fr_submit_date", "fr_status", "event_status" };
string[] Value = { fr_ref_fund_id, Convert.ToDateTime(fr_date_start).ToString("yyyy-MM-dd", en), Convert.ToDateTime(dt).ToString("yyyy-MM-dd", en), fr_ref_emp_id, "1", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", en), "Y", "S" };
db.insert_db(table, Columns, Value);
}
public void insertAdmonish()
{
DateTime dt = Convert.ToDateTime(adm_date);
adm_date = dt.Year + "-" + dt.Month + "-" + dt.Day;
string table = "tab_emp_admonish";
string[] Columns = { "adm_date", "adm_title", "adm_detail", "adm_ref_emp_id", "adm_admin_id", "adm_submit_date" };
string[] Value = { adm_date, adm_title, adm_detail, adm_ref_emp_id, "1", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") };
db.insert_db(table, Columns, Value);
}
public void insertCommend()
{
DateTime dt = Convert.ToDateTime(comm_date);
comm_date = dt.Year + "-" + dt.Month + "-" + dt.Day;
string table = "tab_emp_commend";
string[] Columns = { "comm_date", "comm_title", "comm_detail", "comm_ref_emp_id", "comm_admin_id", "comm_submit_date" };
string[] Value = { comm_date, comm_title, comm_detail, comm_ref_emp_id, "1", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") };
db.insert_db(table, Columns, Value);
}
public void insert_position()
{
check_position();
if (num > 0)
{
pos_active = "N";
}
else
{
pos_active = "Y";
}
string table = "tab_emp_position";
string[] Columns = { "position_emp_id", "position_comp_id", "position_sect_id", "position_dept_id", "position_posit_id", "position_type", "position_start_date", "position_resign_date", "position_admin_id", "position_submit_date", "position_status", "position_active", "event_status" };
string[] Value = { pos_emp_id, pos_comp_id, pos_sect_id, pos_dept_id, pos_position_id, pos_type, pos_start_date, pos_resign_date, "1", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", en), "Y", pos_active, "S" };
db.insert_db(table, Columns, Value);
}