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); } }