/// <summary>
/// Save Out Employees.
/// </summary>
/// <param name="employees">Out Employees</param>
public void SaveOutEmployees(List <OutEmployeeInfo> employees)
{
using (var conn = new SqlConnection(SQLHelper.ConnectionStringLocalTransaction)) {
conn.Open();
using (var tran = conn.BeginTransaction(IsolationLevel.ReadCommitted)) {
try {
SqlParameter[] parms = { new SqlParameter("@EmpId", SqlDbType.VarChar, 50),
new SqlParameter("@EmpName", SqlDbType.NVarChar, 50),
new SqlParameter("@Sex", SqlDbType.VarChar, 10),
new SqlParameter("@CardId", SqlDbType.VarChar, 50),
new SqlParameter("@CardAddress", SqlDbType.NVarChar, 200),
new SqlParameter("@CardIssue", SqlDbType.NVarChar, 200),
new SqlParameter("@Hometown", SqlDbType.NVarChar, 200),
new SqlParameter("@CompanyName", SqlDbType.NVarChar, 100),
new SqlParameter("@ProjectName", SqlDbType.NVarChar, 100),
new SqlParameter("@OfficePhone", SqlDbType.VarChar, 20),
new SqlParameter("@MobilePhone", SqlDbType.VarChar, 20),
new SqlParameter("@Email", SqlDbType.VarChar, 50),
new SqlParameter("@Comment", SqlDbType.NVarChar, 1024),
new SqlParameter("@ParentEmpId", SqlDbType.VarChar, 50),
new SqlParameter("@Photo", SqlDbType.Image),
new SqlParameter("@PhotoLayout", SqlDbType.Int),
new SqlParameter("@Enabled", SqlDbType.Bit) };
foreach (var employee in employees)
{
parms[0].Value = employee.EmpId;
parms[1].Value = employee.EmpName;
parms[2].Value = employee.Sex;
parms[3].Value = ComUtility.DBNullStringChecker(employee.CardId);
parms[4].Value = ComUtility.DBNullStringChecker(employee.CardAddress);
parms[5].Value = ComUtility.DBNullStringChecker(employee.CardIssue);
parms[6].Value = ComUtility.DBNullStringChecker(employee.Hometown);
parms[7].Value = ComUtility.DBNullStringChecker(employee.CompanyName);
parms[8].Value = ComUtility.DBNullStringChecker(employee.ProjectName);
parms[9].Value = ComUtility.DBNullStringChecker(employee.OfficePhone);
parms[10].Value = employee.MobilePhone;
parms[11].Value = employee.Email;
parms[12].Value = ComUtility.DBNullStringChecker(employee.Comment);
parms[13].Value = employee.ParentEmpId;
parms[14].Value = ComUtility.DBNullBytesChecker(employee.Photo);
parms[15].Value = employee.PhotoLayout;
parms[16].Value = employee.Enabled;
SQLHelper.ExecuteNonQuery(tran, CommandType.Text, SQLText.SQL_EE_SaveOutEmployee, parms);
}
tran.Commit();
} catch {
tran.Rollback();
throw;
}
}
}
}
/// <summary>
/// Save Organization Employees.
/// </summary>
/// <param name="employees">employees</param>
public void SaveOrgEmployees(List <OrgEmployeeInfo> employees)
{
using (var conn = new SqlConnection(SQLHelper.ConnectionStringLocalTransaction)) {
conn.Open();
using (var tran = conn.BeginTransaction(IsolationLevel.ReadCommitted)) {
try {
SqlParameter[] parms = { new SqlParameter("@EmpId", SqlDbType.VarChar, 50),
new SqlParameter("@EmpType", SqlDbType.Int),
new SqlParameter("@EmpName", SqlDbType.NVarChar, 50),
new SqlParameter("@EnglishName", SqlDbType.VarChar, 50),
new SqlParameter("@Sex", SqlDbType.VarChar, 10),
new SqlParameter("@CardID", SqlDbType.VarChar, 50),
new SqlParameter("@Hometown", SqlDbType.NVarChar, 200),
new SqlParameter("@BirthDay", SqlDbType.DateTime),
new SqlParameter("@Marriage", SqlDbType.Int),
new SqlParameter("@HomeAddress", SqlDbType.NVarChar, 200),
new SqlParameter("@HomePhone", SqlDbType.VarChar, 20),
new SqlParameter("@EntryDay", SqlDbType.DateTime),
new SqlParameter("@PositiveDay", SqlDbType.DateTime),
new SqlParameter("@DepId", SqlDbType.VarChar, 50),
new SqlParameter("@DutyName", SqlDbType.NVarChar, 50),
new SqlParameter("@OfficePhone", SqlDbType.VarChar, 20),
new SqlParameter("@MobilePhone", SqlDbType.VarChar, 20),
new SqlParameter("@Email", SqlDbType.VarChar, 50),
new SqlParameter("@Comment", SqlDbType.NVarChar, 1024),
new SqlParameter("@Photo", SqlDbType.Image),
new SqlParameter("@PhotoLayout", SqlDbType.Int),
new SqlParameter("@ResignationDate", SqlDbType.DateTime),
new SqlParameter("@ResignationRemark", SqlDbType.NVarChar, 1024),
new SqlParameter("@Enabled", SqlDbType.Bit) };
foreach (var employee in employees)
{
parms[0].Value = employee.EmpId;
parms[1].Value = (Int32)employee.EmpType;
parms[2].Value = employee.EmpName;
parms[3].Value = ComUtility.DBNullStringChecker(employee.EnglishName);
parms[4].Value = employee.Sex;
parms[5].Value = ComUtility.DBNullStringChecker(employee.CardId);
parms[6].Value = ComUtility.DBNullStringChecker(employee.Hometown);
parms[7].Value = employee.BirthDay;
parms[8].Value = (Int32)employee.Marriage;
parms[9].Value = ComUtility.DBNullStringChecker(employee.HomeAddress);
parms[10].Value = ComUtility.DBNullStringChecker(employee.HomePhone);
parms[11].Value = employee.EntryDay;
parms[12].Value = employee.PositiveDay;
parms[13].Value = employee.DepId;
parms[14].Value = ComUtility.DBNullStringChecker(employee.DutyName);
parms[15].Value = ComUtility.DBNullStringChecker(employee.OfficePhone);
parms[16].Value = employee.MobilePhone;
parms[17].Value = employee.Email;
parms[18].Value = ComUtility.DBNullStringChecker(employee.Comment);
parms[19].Value = ComUtility.DBNullBytesChecker(employee.Photo);
parms[20].Value = employee.PhotoLayout;
parms[21].Value = ComUtility.DBNullDateTimeChecker(employee.ResignationDate);
parms[22].Value = ComUtility.DBNullStringChecker(employee.ResignationRemark);
parms[23].Value = employee.Enabled;
SQLHelper.ExecuteNonQuery(tran, CommandType.Text, SQLText.SQL_EE_SaveOrgEmployee, parms);
}
tran.Commit();
} catch {
tran.Rollback();
throw;
}
}
}
}