public static BasicEntity EmployeeEdit(Model.Employees data, Output.OutputBase obj)
{
var retVal = new BasicEntity();
retVal.AddParameter("@ID", data.ID);
retVal.AddParameter("@NIK", data.NIK);
retVal.AddParameter("@FirstName", data.FirstName);
retVal.AddParameter("@LastName", data.LastName);
retVal.AddParameter("@Address", data.Address);
retVal.AddParameter("@Gender", data.Gender);
retVal.AddParameter("@PlaceOfBirth", data.PlaceOfBirth);
retVal.AddParameter("@DateOfBirth", data.DateOfBirth);
retVal.AddParameter("@Email", data.Email);
retVal.AddParameter("@Phone", data.Phone);
retVal.AddParameter("@JobTitleID", data.JobTitleID);
retVal.AddParameter("@HireDate", data.HireDate);
data.SqlDetail = retVal.SQLCommandBuilder("spEditEmployee");
using (SqlDataReader reader = retVal.ExecReader())
{
while (reader.Read())
{
obj.ResultCode = (reader.IsDBNull(0)) ? 0 : reader.GetInt32(0);
obj.ErrorMessage = (reader.IsDBNull(1)) ? string.Empty : reader.GetString(1);
retVal.ResultCode = obj.ResultCode;
}
reader.Close();
}
retVal.Close();
return(retVal);
}
public static BasicEntity EmployeeDelete(Model.Employees data, Output.OutputBase obj)
{
var retVal = new BasicEntity();
retVal.AddParameter("@id", data.ID);
retVal.AddParameter("@nik", data.NIK);
data.SqlDetail = retVal.SQLCommandBuilder("spDeleteEmployee");
using (SqlDataReader reader = retVal.ExecReader())
{
while (reader.Read())
{
obj.ResultCode = (reader.IsDBNull(0)) ? 0 : reader.GetInt32(0);
obj.ErrorMessage = (reader.IsDBNull(1)) ? string.Empty : reader.GetString(1);
retVal.ResultCode = obj.ResultCode;
}
reader.Close();
}
retVal.Close();
return(retVal);
}
protected void Show()
{
if (Session["User"] != null)
{
string No = Session["User"].ToString();
Model.Employees employees = BLL.EmployeesBLL.GetEmployeesList().Where(E => E.Emp_No == No).First();
lblName.Text = employees.Emp_Name;
lblNo.Text = employees.Emp_No;
}
txtStartTime.Text = DateTime.Now.ToString("yyyy-MM-dd");
}
public static BaseHelper EmployeeAdd(Model.Employees data)
{
var retVal = new BaseHelper();
var objJSONPage = new Output.OutputBase();
try
{
var entityPage = GetEmployees.EmployeeAdd(data, objJSONPage);
if (objJSONPage.ResultCode == 1)
{
retVal.SQLElapsed += entityPage.SQLElapsed;
retVal.SQLInfo($"sp : {entityPage.SQLDetail}, elapsed : {entityPage.SQLElapsed}");
retVal.IsError = (entityPage.ResultCode == 1) ? false : true;
}
else
{
objJSONPage.ResultCode = objJSONPage.ResultCode;
objJSONPage.ErrorMessage = objJSONPage.ErrorMessage;
}
}
catch (Exception ex)
{
retVal.Exception = ex;
if (ex is System.Data.SqlClient.SqlException sqlEx)
{
retVal.SQLInfo($"sp:{sqlEx.Procedure}, line:{sqlEx.LineNumber}, detail:{data.SqlDetail}");
retVal.SQLException = true;
objJSONPage.ResultCode = 69998;
objJSONPage.ErrorMessage = "SQL Exception";
}
else
{
objJSONPage.ResultCode = 69999;
objJSONPage.ErrorMessage = "Unknown Error";
}
}
finally
{
retVal.SerializeObject <Output.OutputBase>(objJSONPage);
}
return(retVal);
}
protected void btnLogin_Click(object sender, EventArgs e)
{
string UserName = txtName.Text;
string Password = txtPassword.Text;
Model.Employees employees = new Model.Employees();
employees.Emp_No = UserName;
employees.Password = Password;
if (BLL.EmployeesBLL.UserLogin(UserName, Password) > 0)
{
Session["User"] = UserName; //登入成功 保存到Session
Response.Redirect("BookDinOrder.aspx");
}
else
{
lblMes.Text = "账号或密码错误！";
}
}
protected void btnOrder_Click(object sender, EventArgs e)
{
DateTime dateTime = DateTime.Now;
if (DateTime.TryParse(txtEndTime.Text, out dateTime) == true)
{
Model.Book_Dinner book_Dinner = new Model.Book_Dinner();
string No = Session["User"].ToString();
Model.Employees employees = BLL.EmployeesBLL.GetEmployeesList().Where(E => E.Emp_No == No).First();
book_Dinner.work_no = No;
book_Dinner.Emp_Name = employees.Emp_Name;
book_Dinner.book_time = dateTime;
if (BLL.Book_DinnerBLL.AddOrder(book_Dinner) > 0)
{
Response.Redirect("BookDinList.aspx");
}
else
{
Response.Write("<script>alert('预定出现错误！，请重试')</script>");
}
}
}
public Model.Employees GetEmployees(HttpContext context)
{
Model.Employees emp = new Model.Employees();
emp.UserName = context.Request.Form["txtUserName"].Trim();
emp.Value2 = context.Request.Form["txtAbbr"].Trim();
emp.WorkID = context.Request.Form["txtWorkID"].Trim();
emp.Pwd = string.IsNullOrWhiteSpace(context.Request.Form["hdPwd"])
? string.IsNullOrWhiteSpace(context.Request.Form["txtUserName"])
? string.Empty
: DBUtility.WcSecurity.Des.Encrypt(context.Request.Form["txtUserName"])
: context.Request.Form["hdPwd"];
emp.Name = context.Request.Form["txtName"].Trim();
emp.IDCard = context.Request.Form["txtIDCard"].Trim();
emp.Nativeplace = context.Request.Form["txtNativeplace"].Trim();
emp.RegdResd = context.Request.Form["txtRegdResd"].Trim();
emp.Address = context.Request.Form["txtAddress"].Trim();
emp.Nation = context.Request.Form["txtNation"].Trim();
emp.Major = context.Request.Form["txtMajor"].Trim();
emp.Tel = context.Request.Form["txtTel"].Trim();
emp.Email = context.Request.Form["txtEmail"].Trim();
emp.EmContact = context.Request.Form["txtEmContact"].Trim();
emp.EmContactTel = context.Request.Form["txtEmContactTel"].Trim();
emp.Remark = context.Request.Form["txtRemark"].Trim();
emp.UserID = context.Request["action"] == "edit" ? long.Parse(context.Request.Form["hdID"]) : 0;
try { emp.Permissions = int.Parse(context.Request.Form["cbPermissions"]); }
catch { emp.Permissions = 0; }
try { emp.Value0 = context.Request.Form["Checkbox2"].ToString(); }
catch { emp.Value0 = "0"; }
try { emp.Value1 = context.Request.Form["Checkbox3"].ToString(); }
catch { emp.Value1 = "0"; }
try { emp.EntryDate = Convert.ToDateTime(context.Request.Form["txtEntryDate"]); }
catch { }
try { emp.Positivedates = Convert.ToDateTime(context.Request.Form["txtPositivedates"]); }
catch { }
try { emp.Dataofbirth = Convert.ToDateTime(context.Request.Form["txtDataofbirth"]); }
catch { }
try { emp.Dataofbirth = Convert.ToDateTime(context.Request.Form["txtGraduationDate"]); }
catch { }
if (!string.IsNullOrWhiteSpace(context.Request.Form["txtSex"]))
{
emp.Sex = int.Parse(context.Request.Form["txtSex"]);
}
if (!string.IsNullOrWhiteSpace(context.Request.Form["txtBloodtype"]))
{
emp.Bloodtype = int.Parse(context.Request.Form["txtBloodtype"]);
}
if (!string.IsNullOrWhiteSpace(context.Request.Form["txtPoliticsstatus"]))
{
emp.Politicsstatus = int.Parse(context.Request.Form["txtPoliticsstatus"]);
}
if (!string.IsNullOrWhiteSpace(context.Request.Form["txtMaritalstatus"]))
{
emp.Maritalstatus = int.Parse(context.Request.Form["txtMaritalstatus"]);
}
if (!string.IsNullOrWhiteSpace(context.Request.Form["txtEducation"]))
{
emp.Education = int.Parse(context.Request.Form["txtEducation"]);
}
if (!string.IsNullOrWhiteSpace(context.Request.Form["txtDegree"]))
{
emp.Degree = int.Parse(context.Request.Form["txtDegree"]);
}
if (!string.IsNullOrWhiteSpace(context.Request.Form["txtStateEmployees"]))
{
emp.StateEmployees = int.Parse(context.Request.Form["txtStateEmployees"]);
}
if (!string.IsNullOrWhiteSpace(context.Request.Form["txtDeptID"]))
{
emp.DeptID = int.Parse(context.Request.Form["txtDeptID"]);
}
if (!string.IsNullOrWhiteSpace(context.Request.Form["txtAppRoleID"]))
{
emp.AppRoleID = int.Parse(context.Request.Form["txtAppRoleID"]);
emp.ApprRole = context.Request.Form["txtAppRoleID"];
}
try { emp.CreateUser = ((Model.BaseUser)context.Session["login"]).UserName; }
catch { }
try{ emp.CreateDate = DateTime.Now; }
catch { }
try { emp.UpdateUser = ((Model.BaseUser)context.Session["login"]).UserName; }
catch { }
try { emp.UpdateDate = DateTime.Now; }
catch { }
return(emp);
}
