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