/// <summary>
/// Class Constructor
/// </summary>
public DevAuthDetailDialog(OutEmployeeInfo emp)
{
InitializeComponent();
CurOrgEmp = null;
CurOutEmp = emp;
CurDevices = new List <DeviceInfo>();
}
/// <summary>
/// Class Constructor
/// </summary>
public SaveOutEmployeeForm(EnmSaveBehavior Behavior, OutEmployeeInfo Employee)
{
InitializeComponent();
CurBehavior = Behavior;
EmpEntity = new Employee();
CurEmployee = new OutEmployeeInfo();
OriEmployee = Employee;
Common.CopyObjectValues(OriEmployee, CurEmployee);
Text = Behavior == EnmSaveBehavior.Add ? "新增外协人员" : "编辑外协人员";
}
/// <summary>
/// Add Out Employee.
/// </summary>
private void AddBtn_Click(object sender, EventArgs e)
{
try {
var maxId = EmpEntity.GetMaxOutEmployeeID() + 1;
OrgEmployeeInfo Employee = null;
if (EmpTreeView.SelectedNode != null)
{
var tag = (IDValuePair <Int32, String>)EmpTreeView.SelectedNode.Tag;
if (tag != null && tag.ID == 1)
{
Employee = OrgEmployees.Find(oe => oe.EmpId.Equals(tag.Value, StringComparison.CurrentCultureIgnoreCase));
}
}
var obj = new OutEmployeeInfo()
{
ID = maxId,
EmpId = String.Format("{0:D8}", maxId),
EmpName = String.Empty,
Sex = "M",
CardId = String.Empty,
CardAddress = String.Empty,
CardIssue = String.Empty,
Hometown = String.Empty,
CompanyName = String.Empty,
ProjectName = String.Empty,
OfficePhone = String.Empty,
MobilePhone = String.Empty,
Email = String.Empty,
Comment = String.Empty,
DepId = Employee != null ? Employee.DepId : String.Empty,
DepName = Employee != null ? Employee.DepName : String.Empty,
ParentEmpId = Employee != null ? Employee.EmpId : String.Empty,
ParentEmpName = Employee != null ? Employee.EmpName : String.Empty,
Photo = null,
PhotoLayout = (int)ImageLayout.Zoom,
Enabled = true
};
if (new SaveOutEmployeeForm(EnmSaveBehavior.Add, obj).ShowDialog(this) == System.Windows.Forms.DialogResult.OK)
{
OutEmployees.Add(obj);
BindOutEmployeesToGridView();
}
} catch (Exception err) {
Common.WriteLog(DateTime.Now, EnmMsgType.Error, "System", "Delta.MPS.AccessSystem.OutEmployeeManagerForm.AddBtn.Click", err.Message, err.StackTrace);
MessageBox.Show(err.Message, "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// Add Card Button Click Event.
/// </summary>
private void AddBtn_Click(object sender, EventArgs e)
{
try {
OutEmployeeInfo Employee = null;
if (EmpTreeView.SelectedNode != null)
{
var tag = (IDValuePair <Int32, String>)EmpTreeView.SelectedNode.Tag;
if (tag != null && tag.ID == 2)
{
Employee = OutEmployees.Find(oe => oe.EmpId.Equals(tag.Value, StringComparison.CurrentCultureIgnoreCase));
}
}
var obj = new CardInfo()
{
WorkerId = Employee != null ? Employee.EmpId : String.Empty,
WorkerType = EnmWorkerType.WXRY,
WorkerName = Employee != null ? Employee.EmpName : String.Empty,
DepId = Employee != null ? Employee.DepId : String.Empty,
DepName = Employee != null ? Employee.DepName : String.Empty,
CardSn = String.Empty,
CardType = EnmCardType.LSK,
UID = String.Empty,
Pwd = String.Empty,
BeginTime = DateTime.Now,
BeginReason = "员工入职",
Comment = String.Empty,
Enabled = true
};
if (new SaveCardForm(EnmSaveBehavior.Add, obj).ShowDialog(this) == System.Windows.Forms.DialogResult.OK)
{
Cards.Add(obj);
BindCardsToGridView();
}
} catch (Exception err) {
Common.WriteLog(DateTime.Now, EnmMsgType.Error, "System", "Delta.MPS.AccessSystem.OutCardManagerForm.AddBtn.Click", err.Message, err.StackTrace);
MessageBox.Show(err.Message, "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// Get Out Employees By Role Id.
/// </summary>
/// <param name="roleId">role id</param>
/// <returns>Out Employees</returns>
public List <OutEmployeeInfo> GetOutEmployees(Guid roleId)
{
SqlParameter[] parms = { new SqlParameter("@RoleId", SqlDbType.UniqueIdentifier) };
parms[0].Value = ComUtility.DBNullSuperChecker(roleId);
var employees = new List <OutEmployeeInfo>();
using (var rdr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, SQLText.SQL_EE_GetOutEmployees, parms)) {
while (rdr.Read())
{
var employee = new OutEmployeeInfo();
employee.ID = ComUtility.DBNullInt64Handler(rdr["ID"]);
employee.EmpId = ComUtility.DBNullStringHandler(rdr["EmpId"]);
employee.EmpName = ComUtility.DBNullStringHandler(rdr["EmpName"]);
employee.Sex = ComUtility.DBNullStringHandler(rdr["Sex"]);
employee.CardId = ComUtility.DBNullStringHandler(rdr["CardId"]);
employee.CardAddress = ComUtility.DBNullStringHandler(rdr["CardAddress"]);
employee.CardIssue = ComUtility.DBNullStringHandler(rdr["CardIssue"]);
employee.Hometown = ComUtility.DBNullStringHandler(rdr["Hometown"]);
employee.CompanyName = ComUtility.DBNullStringHandler(rdr["CompanyName"]);
employee.ProjectName = ComUtility.DBNullStringHandler(rdr["ProjectName"]);
employee.OfficePhone = ComUtility.DBNullStringHandler(rdr["OfficePhone"]);
employee.MobilePhone = ComUtility.DBNullStringHandler(rdr["MobilePhone"]);
employee.Email = ComUtility.DBNullStringHandler(rdr["Email"]);
employee.Comment = ComUtility.DBNullStringHandler(rdr["Comment"]);
employee.DepId = ComUtility.DBNullStringHandler(rdr["DepId"]);
employee.DepName = ComUtility.DBNullStringHandler(rdr["DepName"]);
employee.ParentEmpId = ComUtility.DBNullStringHandler(rdr["ParentEmpId"]);
employee.ParentEmpName = ComUtility.DBNullStringHandler(rdr["ParentEmpName"]);
employee.Photo = ComUtility.DBNullBytesHandler(rdr["Photo"]);
employee.PhotoLayout = ComUtility.DBNullInt32Handler(rdr["PhotoLayout"]);
employee.Enabled = ComUtility.DBNullBooleanHandler(rdr["Enabled"]);
employees.Add(employee);
}
}
return(employees);
}
/// <summary>
/// Get Out Employee By The Specified ID.
/// </summary>
/// <param name="EmpId">Employee ID</param>
/// <returns>The Specified Out Employee</returns>
public OutEmployeeInfo GetOutEmployee(String EmpId)
{
SqlParameter[] parms = { new SqlParameter("@EmpId", SqlDbType.VarChar, 50) };
parms[0].Value = EmpId;
OutEmployeeInfo employee = null;
using (var rdr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, SQLText.SQL_EE_GetOutEmployee, parms)) {
if (rdr.Read())
{
employee = new OutEmployeeInfo();
employee.ID = ComUtility.DBNullInt64Handler(rdr["ID"]);
employee.EmpId = ComUtility.DBNullStringHandler(rdr["EmpId"]);
employee.EmpName = ComUtility.DBNullStringHandler(rdr["EmpName"]);
employee.Sex = ComUtility.DBNullStringHandler(rdr["Sex"]);
employee.CardId = ComUtility.DBNullStringHandler(rdr["CardId"]);
employee.CardAddress = ComUtility.DBNullStringHandler(rdr["CardAddress"]);
employee.CardIssue = ComUtility.DBNullStringHandler(rdr["CardIssue"]);
employee.Hometown = ComUtility.DBNullStringHandler(rdr["Hometown"]);
employee.CompanyName = ComUtility.DBNullStringHandler(rdr["CompanyName"]);
employee.ProjectName = ComUtility.DBNullStringHandler(rdr["ProjectName"]);
employee.OfficePhone = ComUtility.DBNullStringHandler(rdr["OfficePhone"]);
employee.MobilePhone = ComUtility.DBNullStringHandler(rdr["MobilePhone"]);
employee.Email = ComUtility.DBNullStringHandler(rdr["Email"]);
employee.Comment = ComUtility.DBNullStringHandler(rdr["Comment"]);
employee.DepId = ComUtility.DBNullStringHandler(rdr["DepId"]);
employee.DepName = ComUtility.DBNullStringHandler(rdr["DepName"]);
employee.ParentEmpId = ComUtility.DBNullStringHandler(rdr["ParentEmpId"]);
employee.ParentEmpName = ComUtility.DBNullStringHandler(rdr["ParentEmpName"]);
employee.Photo = ComUtility.DBNullBytesHandler(rdr["Photo"]);
employee.PhotoLayout = ComUtility.DBNullInt32Handler(rdr["PhotoLayout"]);
employee.Enabled = ComUtility.DBNullBooleanHandler(rdr["Enabled"]);
}
}
return(employee);
}
