예제 #1
0
        private static void SaveData()
        {
            BaseDataAccess <FEmployee>    employeeDA    = new BaseDataAccess <FEmployee>();
            BaseDataAccess <FEmpWorkInfo> empWorlInfoDA = new BaseDataAccess <FEmpWorkInfo>();

            string       empID       = "697fb4a2-b640-4b10-969d-db12eea16941";
            string       empNo       = "p666";
            string       deptID      = "3AAC6598-7ECD-479D-9D12-50A8B52536E5";
            string       roleID      = "C374D319-EA6D-411D-8546-14EE9072AA08";
            Guid         workInfoID  = Guid.NewGuid();
            FEmpWorkInfo empWorkInfo = new FEmpWorkInfo();

            empWorkInfo.WorkInfoID  = workInfoID.ToString();
            empWorkInfo.EmpID       = empID;
            empWorkInfo.EmpNo       = empNo;
            empWorkInfo.RoleID      = roleID;
            empWorkInfo.BeginDate   = DateTime.Today;
            empWorkInfo.DeptID      = deptID;
            empWorkInfo.IsOnDuty    = 1;
            empWorkInfo.IsPluralist = 0;
            empWorkInfo.ModDate     = DateTime.Now;

            FEmployee employee = new FEmployee();

            employee.EmpID          = empID;
            employee.EmpName        = "王小小";
            employee.EmpNo          = empNo;
            employee.EmployeeDate   = DateTime.Today;
            employee.DeptID         = deptID;
            employee.RoleID         = roleID;
            employee.Job            = "跑盘人员";
            employee.ADUserID       = empNo;
            employee.Email          = empNo + "@centaline.com.cn";
            employee.DelFlag        = 0;
            employee.UpdateTime     = DateTime.Now;
            employee.Sex            = "女";
            employee.IDCardNo       = "432601198506123215";
            employee.IdentityCardNO = employee.IDCardNo;
            employee.MainWorkInfoID = workInfoID;


            String sql1 = employeeDA.GetSaveEntitySQL(employee);
            String sql2 = empWorlInfoDA.GetSaveEntitySQL(empWorkInfo);

            int a = SqlHelper.ExecTran(new string[] { sql1, sql2 });

            gConsole.WriteLine(a);
        }
 public static void DeleteEmployee(int tc_no)
 {
     FEmployee.DeleteEmployee(tc_no);
 }
 public static void getEmployee(int tc_no, DataTable dt)
 {
     FEmployee.getEmployee(tc_no, dt);
 }
 public static void UpdateEmployee(int tc_no, string name, string surname, string type, string address, int phone)
 {
     FEmployee.UpdateEmployee(tc_no, name, surname, type, address, phone);
 }