private void NewEmp()
{
string en_use_yn = WebUtility.GetConfig("ENCRYPTION_USE_YN").ToUpper();
string encryption_oneway_mode = WebUtility.GetConfig("ENCRYPTION_ONEWAY_MODE").ToUpper();
string encryption_key = WebUtility.GetConfig("ENCRYPTION_KEY").ToUpper();
string pw = "";
string emp_email;
string emp_cellphone;
if (en_use_yn.Equals("Y"))
{
//pw = GetEncriptString(DEFAULT_PASS);
pw = FormsAuthentication.HashPasswordForStoringInConfigFile(DEFAULT_PASS, encryption_oneway_mode);
emp_email = DataTypeUtility.Encrypt(GetValue(txtEmail.Text), encryption_key);
emp_cellphone = DataTypeUtility.Encrypt(GetValue(txtCell.Text), encryption_key);
}
else
{
pw = DEFAULT_PASS;
emp_email = GetValue(txtEmail.Text);
emp_cellphone = GetValue(txtCell.Text);
}
Biz_ctl_ctl2101 biz = new Biz_ctl_ctl2101();
int iRet = biz.AddEmpInfo(
Convert.ToInt32(GetRequest("txtDeptID"))
, GetValue(txtLoginID.Text)
, GetValue(txtLoginIP.Text)
, pw
, GetValue(txtName.Text)
, PageUtility.GetByValueDropDownList(ddlPositionClass)
, PageUtility.GetByValueDropDownList(ddlPositionGrp)
, PageUtility.GetByValueDropDownList(ddlPositionRank)
, PageUtility.GetByValueDropDownList(ddlPositionDuty)
, "-1"
, PageUtility.GetByValueDropDownList(ddlPositionKind)
, emp_email
, GetValue(txtDaily.Text)
, emp_cellphone
, GetValue(txtFax.Text)
, 0
, GetValue(Utils.GetZipCode(txtZipcode1.Text, txtZipcode2.Text))
, GetValue(txtAddr1.Text)
, GetValue(txtAddr2.Text)
, Utils.UploadFile(fileSign.Value, "EmpInfo.UploadImages.Sign")
, Utils.UploadFile(fileStamp.Value, "EmpInfo.UploadImages.Stamp")
, 0
, gUserInfo.Emp_Ref_ID
, 0
, 0
);
}
private void ModifyEmp(int empId)
{
Biz_ctl_ctl2101 biz = new Biz_ctl_ctl2101();
string en_use_yn = WebUtility.GetConfig("ENCRYPTION_USE_YN").ToUpper();
string encryption_key = WebUtility.GetConfig("ENCRYPTION_KEY").ToUpper();
string emp_email;
string emp_cellphone;
if (en_use_yn.Equals("Y"))
{
emp_email = DataTypeUtility.Encrypt(GetValue(txtEmail.Text), encryption_key);
emp_cellphone = DataTypeUtility.Encrypt(GetValue(txtCell.Text), encryption_key);
}
else
{
emp_email = GetValue(txtEmail.Text);
emp_cellphone = GetValue(txtCell.Text);
}
int iRet = biz.EditEmpInfo(
Convert.ToInt32(GetValue(hfPrevDeptID.Value))
, Convert.ToInt32(GetRequest("txtDeptID"))
, Convert.ToInt32(empId)
, GetValue(txtLoginID.Text)
, GetValue(txtLoginIP.Text)
, GetValue(txtName.Text)
, PageUtility.GetByValueDropDownList(ddlPositionClass)
, PageUtility.GetByValueDropDownList(ddlPositionGrp)
, PageUtility.GetByValueDropDownList(ddlPositionRank)
, PageUtility.GetByValueDropDownList(ddlPositionDuty)
, "-1"
, PageUtility.GetByValueDropDownList(ddlPositionKind)
, emp_email
, GetValue(txtDaily.Text)
, emp_cellphone
, GetValue(txtFax.Text)
, 0
, GetValue(Utils.GetZipCode(txtZipcode1.Text, txtZipcode2.Text))
, GetValue(txtAddr1.Text)
, GetValue(txtAddr2.Text)
, Utils.UploadFile(fileSign.Value, "EmpInfo.UploadImages.Sign")
, Utils.UploadFile(fileStamp.Value, "EmpInfo.UploadImages.Stamp")
, 0
, 0
, 0
, gUserInfo.Emp_Ref_ID
);
}
public bool Sync_Emp_IF(string LOGIN_ID)
{
Dac_Com_IF dacComIF = new Dac_Com_IF();
Dac_Com_Emp_Info dacComEmpInfo = new Dac_Com_Emp_Info();
string en_use_yn = WebUtility.GetConfig("ENCRYPTION_USE_YN", "N").ToUpper();
string encryption_oneway_mode = WebUtility.GetConfig("ENCRYPTION_ONEWAY_MODE").ToUpper();
string encryption_key = WebUtility.GetConfig("ENCRYPTION_KEY").ToUpper();
int cntEmp = 0;
int cntRel = 0;
//EMP_INFO에 인서트할 정보
string EMP_REF_ID;
string EMP_CODE;
string LOGINID;
string LOGINIP;
string PASSWD;
string EMP_NAME;
string EMP_EMAIL;
string POSITION_CLASS_CODE;
string POSITION_GRP_CODE;
string POSITION_RANK_CODE;
string POSITION_DUTY_CODE;
string POSITION_STAT_CODE;
string POSITION_KIND_CODE;
string DAILY_PHONE;
string CELL_PHONE;
string FAX_NUMBER;
string JOB_STATUS;
string ZIPCODE;
string ADDR_1;
string ADDR_2;
string SIGN_PATH;
string STAMP_PATH;
string CREATE_TYPE;
string CREATE_EMP_ID = dacComEmpInfo.Select_EMP_REF_ID(LOGIN_ID);
string MODIFY_TYPE;
string MODIFY_EMP_ID = CREATE_EMP_ID;
//REL에 인서트할 정보
string DEPT_REF_ID;
string REL_STATUS;
string BOSS_FLAG;
string REL_DATE;
string REL_EMP_ID;
//임시로 사용할 정보
string DEPT_CODE;
int firstRow = 1;
int lastRow = dacComIF.Select_Diff_EmpInfo_IF_Count("N");
DataSet DS = dacComIF.Select_Diff_EmpInfo_IF("N", firstRow, lastRow);
string expression = @" SRC_EMP_CODE IS NOT NULL
AND TARGET_EMP_CODE IS NULL
AND SRC_DEPT_USEYN = 'Y'";
//인서트할 데이터
DataTable inputDT = DataTypeUtility.FilterSortDataTable(DS.Tables[0], expression);
//DataRow[] DR = DS.Tables[0].Select(expression);
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
if (inputDT.Rows.Count > 0)
{
for (int i = 0; i < inputDT.Rows.Count; i++)
{
#region 직원정보 인서트
EMP_REF_ID = dacComEmpInfo.SelectNextEmpRefID(conn, trx);
EMP_CODE = DataTypeUtility.GetString(inputDT.Rows[i]["SRC_EMP_CODE"]);
LOGINID = EMP_CODE;
LOGINIP = "";
PASSWD = "1111";
EMP_NAME = DataTypeUtility.GetString(inputDT.Rows[i]["SRC_EMP_NAME"]);
EMP_EMAIL = DataTypeUtility.GetString(inputDT.Rows[i]["E_MAIL"]);
POSITION_CLASS_CODE = DataTypeUtility.GetString(inputDT.Rows[i]["SRC_POSITION_CLASS_CODE"]);
POSITION_GRP_CODE = DataTypeUtility.GetString(inputDT.Rows[i]["SRC_POSITION_GRP_CODE"]);
POSITION_RANK_CODE = DataTypeUtility.GetString(inputDT.Rows[i]["SRC_POSITION_RANK_CODE"]);
POSITION_DUTY_CODE = DataTypeUtility.GetString(inputDT.Rows[i]["SRC_POSITION_DUTY_CODE"]);
POSITION_STAT_CODE = "-1";
POSITION_KIND_CODE = "99";
DAILY_PHONE = "";
CELL_PHONE = DataTypeUtility.GetString(inputDT.Rows[i]["CELL_PHONE"]);
FAX_NUMBER = "";
JOB_STATUS = "0";
ZIPCODE = "";
ADDR_1 = "";
ADDR_2 = "";
SIGN_PATH = "";
STAMP_PATH = "";
CREATE_TYPE = "0";
CREATE_EMP_ID = dacComEmpInfo.Select_EMP_REF_ID(conn, trx, LOGIN_ID);
MODIFY_TYPE = "0";
MODIFY_EMP_ID = CREATE_EMP_ID;
if (en_use_yn.Equals("Y"))
{
PASSWD = FormsAuthentication.HashPasswordForStoringInConfigFile(PASSWD, encryption_oneway_mode);
EMP_EMAIL = DataTypeUtility.Encrypt(EMP_EMAIL, encryption_key);
CELL_PHONE = DataTypeUtility.Encrypt(CELL_PHONE, encryption_key);
}
cntEmp += dacComEmpInfo.Insert_EmpInfo(conn, trx
, EMP_REF_ID
, EMP_CODE
, LOGINID
, LOGINIP
, PASSWD
, EMP_NAME
, EMP_EMAIL
, POSITION_CLASS_CODE
, POSITION_GRP_CODE
, POSITION_RANK_CODE
, POSITION_DUTY_CODE
, POSITION_STAT_CODE
, POSITION_KIND_CODE
, DAILY_PHONE
, CELL_PHONE
, FAX_NUMBER
, JOB_STATUS
, ZIPCODE
, ADDR_1
, ADDR_2
, SIGN_PATH
, STAMP_PATH
, CREATE_TYPE
, CREATE_EMP_ID
, MODIFY_TYPE
, MODIFY_EMP_ID);
#endregion
#region REL_DEPT_EMP 인서트
Dac_Com_Dept_Info dacComDeptIno = new Dac_Com_Dept_Info();
DEPT_CODE = inputDT.Rows[i]["SRC_DEPT_CODE"].ToString();
DEPT_REF_ID = dacComDeptIno.Select_DEPT_REF_ID(conn, trx, DEPT_CODE);
REL_STATUS = "1";
BOSS_FLAG = "0";
REL_DATE = System.DateTime.Now.ToString("yyyy-MM-dd");
REL_EMP_ID = dacComEmpInfo.Select_EMP_REF_ID(conn, trx, LOGIN_ID);
cntRel += dacComIF.Insert_Rel_Dept_Emp(conn, trx
, EMP_REF_ID
, DEPT_REF_ID
, REL_STATUS
, BOSS_FLAG
, REL_DATE
, REL_EMP_ID);
#endregion
}
}
else
{
cntEmp++;
}
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
return(false);
}
finally
{
conn.Close();
}
if (cntEmp > 0)
{
return(true);
}
else
{
return(false);
}
}
