/// <summary>
/// 是否登录成功
/// </summary>
/// <param name="name"></param>
/// <param name="password"></param>
/// <returns></returns>
public DataTable GetUserAndRoleModel(string name, string password)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" select top(1) Emp_UserRole,Emp_Name,Emp_Password from T_Empolyee ");
strSql.Append(" where Emp_Name=@Emp_Name and Emp_Password=@Emp_Password ");
SqlParameter[] parameters =
{
new SqlParameter("@User_Name", SqlDbType.NVarChar, 512),
new SqlParameter("@User_Password", SqlDbType.NVarChar, 512)
};
parameters[0].Value = name;
parameters[1].Value = password;
Empolyee model = new Empolyee();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(ds.Tables[0]);
}
else
{
return(null);
}
}
public bool SaveJuniorEmployee(Empolyee empolyee)
{
try
{
using (IDbConnection con = new SqlConnection(strConnectionString))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@EmployeeName", empolyee.EmployeeName);
parameters.Add("@Role", empolyee.Role);
parameters.Add("@Age", empolyee.Age);
//int rows= con.Execute("SaveSeniorEmployee",)
SqlMapper.Execute(con, "SaveJuniorEmployee", parameters, null, null, CommandType.StoredProcedure);
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
public IHttpActionResult PutEmpolyee(int id, Empolyee empolyee)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != empolyee.ID)
{
return(BadRequest());
}
db.Entry(empolyee).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!EmpolyeeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
/// <summary>
/// 根据工号查询信息
/// </summary>
/// <param name="Emp_Code">工号</param>
/// <returns></returns>
public Empolyee SelEmpolyeeByCode(string Emp_Code)
{
string sql = string.Format("select * from T_Empolyee where Emp_Code='{0}' and Emp_Clear=1", Emp_Code);
SqlDataReader read = DbHelperSQL.ExecuteReader(sql);
while (read.Read())
{
Empolyee emp = new Empolyee();
emp.Emp_ID = Convert.ToInt32(read["Emp_ID"]);
emp.Emp_Name = XYEEncoding.strHexDecode(read["Emp_Name"].ToString());
emp.Emp_Code = XYEEncoding.strHexDecode(read["Emp_Code"].ToString());
emp.Emp_Card = XYEEncoding.strHexDecode(read["Emp_Card"].ToString());
emp.Emp_Area = XYEEncoding.strHexDecode(read["Emp_Area"].ToString());
emp.Emp_Bank = XYEEncoding.strHexDecode(read["Emp_Bank"].ToString());
emp.Emp_Birthday = Convert.ToDateTime(read["Emp_Birthday"]);
emp.Emp_CardCode = XYEEncoding.strHexDecode(read["Emp_CardCode"].ToString());
emp.Emp_Clear = Convert.ToInt32(read["Emp_Clear"]);
emp.Emp_Depid = XYEEncoding.strHexDecode(read["Emp_Depid"].ToString());
emp.Emp_Education = XYEEncoding.strHexDecode(read["Emp_Education"].ToString());
emp.Emp_Email = XYEEncoding.strHexDecode(read["Emp_Email"].ToString());
emp.Emp_Enable = Convert.ToInt32(read["Emp_Enable"]);
emp.Emp_Entry = Convert.ToDateTime(read["Emp_Entry"]);
emp.Emp_OpenBank = XYEEncoding.strHexDecode(read["Emp_OpenBank"].ToString());
emp.Emp_Password = XYEEncoding.strHexDecode(read["Emp_Password"].ToString());
emp.Emp_Phone = XYEEncoding.strHexDecode(read["Emp_Phone"].ToString());
emp.Emp_School = XYEEncoding.strHexDecode(read["Emp_School"].ToString());
emp.Emp_Sex = XYEEncoding.strHexDecode(read["Emp_Sex"].ToString());
emp.Emp_State = Convert.ToInt32(read["Emp_State"]);
emp.Emp_UserRole = XYEEncoding.strHexDecode(read["Emp_UserRole"].ToString());
emp.Emp_zhiwen = XYEEncoding.strHexDecode(read["Emp_zhiwen"].ToString());
return(emp);
}
return(null);
}
public ActionResult DeleteConfirmed(int id)
{
Empolyee empolyee = db.Empolyees.Find(id);
db.Empolyees.Remove(empolyee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public DataService()
{
Empolyee empolyee = new Empolyee();
empolyee.Id = 1;
empolyee.FirstName = "Sam";
empolyee.LastName = "Fisher";
empolyee.Address = "Canada";
lstEmployee.Add(empolyee);
}
public ActionResult Edit([Bind(Include = "ID,Fullname,Department")] Empolyee empolyee)
{
if (ModelState.IsValid)
{
db.Entry(empolyee).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(empolyee));
}
public List <Empolyee> SelEmpList()
{
List <Empolyee> list = new List <Empolyee>();
string sql = @"select Emp_Code,
Emp_Name,
r.Role_Name,
Emp_Area,
Emp_CardCode,
dep.Dt_Name,
Emp_Sex,
Emp_Card,
Emp_Phone,
Emp_Bank,
Emp_OpenBank,
Emp_Birthday,
Emp_Email,
Emp_Education,
Emp_School,
Emp_Entry,
Emp_State,
Emp_Enable
from T_Empolyee emp,
T_Role r,
T_Department dep
where Emp_Clear=1
and emp.Emp_Depid=dep.Dt_Code
and emp.Emp_UserRole=r.Role_Code";
SqlDataReader read = DbHelperSQL.ExecuteReader(sql);
while (read.Read())
{
Empolyee emp = new Empolyee()
{
Emp_CardCode = XYEEncoding.strHexDecode(read["Emp_CardCode"].ToString()),
Emp_Area = XYEEncoding.strHexDecode(read["Emp_Area"].ToString()),
Emp_Code = XYEEncoding.strHexDecode(read["Emp_Code"].ToString()),
Emp_Sex = XYEEncoding.strHexDecode(read["Emp_Sex"].ToString()),
Emp_Card = XYEEncoding.strHexDecode(read["Emp_Card"].ToString()),
Emp_Phone = XYEEncoding.strHexDecode(read["Emp_Phone"].ToString()),
Emp_Bank = XYEEncoding.strHexDecode(read["Emp_Bank"].ToString()),
Emp_OpenBank = XYEEncoding.strHexDecode(read["Emp_OpenBank"].ToString()),
Emp_Birthday = Convert.ToDateTime(read["Emp_Birthday"].ToString()),
Emp_Email = XYEEncoding.strHexDecode(read["Emp_Email"].ToString()),
Emp_Education = XYEEncoding.strHexDecode(read["Emp_Education"].ToString()),
Emp_School = XYEEncoding.strHexDecode(read["Emp_School"].ToString()),
Emp_Entry = Convert.ToDateTime(read["Emp_Entry"].ToString()),
Emp_State = Convert.ToInt32(read["Emp_State"].ToString()),
Emp_Enable = Convert.ToInt32(read["Emp_Enable"].ToString()),
Roles = new RoleService().GetModel(read["Emp_UserRole"] == null ? "" : read["Emp_UserRole"].ToString()),
Departments = new DepartmentService().SelDepartmentByCode(read["Emp_Depid"] == null ? "" : read["Emp_Depid"].ToString())
};
list.Add(emp);
}
return(list);
}
public IHttpActionResult GetEmpolyee(int id)
{
Empolyee empolyee = db.Empolyees.Find(id);
if (empolyee == null)
{
return(NotFound());
}
return(Ok(empolyee));
}
static void Main(string[] args)
{
Person Person1 = new Person();
Empolyee Person = new Empolyee();
Person1.SetPerson("Pablo", "Wozniak", 22);
Person1.GetPerson();
Person.SetEmployee("cook", 4);
Console.WriteLine(Person.GetEmplyee());
}
public ActionResult Create([Bind(Include = "ID,Fullname,Department")] Empolyee empolyee)
{
if (ModelState.IsValid)
{
db.Empolyees.Add(empolyee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(empolyee));
}
public IHttpActionResult PostEmpolyee(Empolyee empolyee)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Empolyees.Add(empolyee);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = empolyee.ID }, empolyee));
}
public ActionResult Delete(int id)
{
Empolyee delEmp = context.Empolyees.FirstOrDefault(e => e.Id == id);
if (delEmp != null)
{
context.Empolyees.Remove(delEmp);
context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View("Index"));
}
/// <summary>
/// 根据工号修改信息
/// </summary>
/// <param name="empolyee"></param>
/// <returns></returns>
public int UpdateEmpolyee(Empolyee empolyee)
{
string sql = @"update T_Empolyee set
Emp_Name=@Emp_Name
,Emp_Password=@Emp_Password
,Emp_UserRole=@Emp_UserRole
,Emp_Area=@Emp_Area
,Emp_zhiwen=@Emp_zhiwen
,Emp_CardCode=@Emp_CardCode
,Emp_Depid=@Emp_Depid
,Emp_Sex=@Emp_Sex
,Emp_Card=@Emp_Card
,Emp_State=@Emp_State
,Emp_Phone=@Emp_Phone
,Emp_Bank=@Emp_Bank
,Emp_OpenBank=@Emp_OpenBank
,Emp_Birthday=@Emp_Birthday
,Emp_Email=@Emp_Email
,Emp_Education=@Emp_Education
,Emp_School=@Emp_School
,Emp_Entry=@Emp_Entry
,Emp_Enable=@Emp_Enable
,Emp_Clear=@Emp_Clear
where Emp_Code=@Emp_Code";
SqlParameter[] sps =
{
new SqlParameter("@Emp_Code", XYEEncoding.strCodeHex(empolyee.Emp_Code)),
new SqlParameter("@Emp_Name", XYEEncoding.strCodeHex(empolyee.Emp_Name)),
new SqlParameter("@Emp_Password", XYEEncoding.strCodeHex(empolyee.Emp_Password)),
new SqlParameter("@Emp_UserRole", XYEEncoding.strCodeHex(empolyee.Emp_UserRole)),
new SqlParameter("@Emp_Area", XYEEncoding.strCodeHex(empolyee.Emp_Area)),
new SqlParameter("@Emp_zhiwen", empolyee.Emp_zhiwen),
new SqlParameter("@Emp_CardCode", XYEEncoding.strCodeHex(empolyee.Emp_CardCode)),
new SqlParameter("@Emp_Depid", XYEEncoding.strCodeHex(empolyee.Emp_Depid)),
new SqlParameter("@Emp_Sex", XYEEncoding.strCodeHex(empolyee.Emp_Sex)),
new SqlParameter("@Emp_Card", XYEEncoding.strCodeHex(empolyee.Emp_Card)),
new SqlParameter("@Emp_State", empolyee.Emp_State),
new SqlParameter("@Emp_Phone", XYEEncoding.strCodeHex(empolyee.Emp_Phone)),
new SqlParameter("@Emp_Bank", XYEEncoding.strCodeHex(empolyee.Emp_Bank)),
new SqlParameter("@Emp_OpenBank", XYEEncoding.strCodeHex(empolyee.Emp_OpenBank)),
new SqlParameter("@Emp_Birthday", empolyee.Emp_Birthday),
new SqlParameter("@Emp_Email", XYEEncoding.strCodeHex(empolyee.Emp_Email)),
new SqlParameter("@Emp_Education", XYEEncoding.strCodeHex(empolyee.Emp_Education)),
new SqlParameter("@Emp_School", XYEEncoding.strCodeHex(empolyee.Emp_School)),
new SqlParameter("@Emp_Entry", empolyee.Emp_Entry),
new SqlParameter("@Emp_Enable", empolyee.Emp_Enable),
new SqlParameter("@Emp_Clear", empolyee.Emp_Clear),
};
return(DbHelperSQL.ExecuteSql(sql, sps));
}
private static void Main(string[] args)
{
Empolyee empolyee = new Empolyee();
Console.WriteLine("請輸入底薪");
int baseSalary = int.Parse(Console.ReadLine());
empolyee.SetBaseSalary = baseSalary;
Console.WriteLine("請輸入獎金");
int benefit = int.Parse(Console.ReadLine());
empolyee.SetBenefit = benefit;
Console.WriteLine(empolyee.SetSalary);
}
// private static Empolyee empolyee = new Empolyee();
private static void Main(string[] args)
{
Empolyee empolyee = new Empolyee();
Console.Write("請輸入員工姓名: ");
empolyee.Name = Console.ReadLine();
Console.Write("請輸入底薪: ");
empolyee.BaseSalary = double.Parse(Console.ReadLine());
Console.Write("請輸入獎金: ");
empolyee.Benefit = double.Parse(Console.ReadLine());
Console.WriteLine("-----------------------");
Console.WriteLine("{0}的薪水為 : {1}", empolyee.Name, empolyee.Salary);
Console.WriteLine("-----------------------");
}
private void button1_Click(object sender, EventArgs e)
{
Empolyee emp = new Empolyee();
emp.id = int.Parse(Id.Text);
emp.name = NAME.Text;
emp.position = Position.Text;
emp.salary = int.Parse(Salary.Text);
emp.officehour = int.Parse(Officehour.Text);
emp.phone = Phone.Text;
emp.department = Depart.Text;
listemp.Add(emp);
MessageBox.Show("aDD " + listemp.Count);
}
public IHttpActionResult DeleteEmpolyee(int id)
{
Empolyee empolyee = db.Empolyees.Find(id);
if (empolyee == null)
{
return(NotFound());
}
db.Empolyees.Remove(empolyee);
db.SaveChanges();
return(Ok(empolyee));
}
// GET: Empolyees/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Empolyee empolyee = db.Empolyees.Find(id);
if (empolyee == null)
{
return(HttpNotFound());
}
return(View(empolyee));
}
public ActionResult Edit(int id)
{
Empolyee emp = context.Empolyees.FirstOrDefault(e => e.Id == id);
if (emp != null)
{
ViewBag.Action = "Edit";
EmployeeViewModel empVM = new EmployeeViewModel();
empVM.Empolyee = emp;
empVM.Departments = context.Departments.ToList();
return(View("AddEdit", empVM));
}
return(RedirectToAction("Index"));
}
public bool SaveEmployee(string EmployeeName, string Role, int Age)
{
Empolyee empolyee = new Empolyee();
empolyee.EmployeeName = EmployeeName;
empolyee.Role = Role;
empolyee.Age = Age;
if (Age > 40)
{
return(da.SaveSeniorEmployee(empolyee));
}
else
{
return(da.SaveJuniorEmployee(empolyee));
}
}
public ActionResult Edit(Empolyee empolyee)
{
if (ModelState.IsValid)
{
var prevEmp = context.Empolyees.FirstOrDefault(e => e.Id == empolyee.Id);
if (prevEmp != null)
{
prevEmp.Name = empolyee.Name;
prevEmp.Age = empolyee.Age;
prevEmp.Email = empolyee.Email;
context.SaveChanges();
}
return(RedirectToAction("Index"));
}
return(View("AddEdit", empolyee));
}
private void SetSalary_Click(object sender, EventArgs e)
{
int baseSalay;
int benefit;
Empolyee 吳漢武 = new Empolyee();
if (BaseSalaryTextBox.Text == "")
{
BaseSalaryTextBox.Text = 吳漢武.BaseSalary.ToString();
}
baseSalay = int.Parse(BaseSalaryTextBox.Text);
吳漢武.BaseSalary = baseSalay;
benefit = int.Parse(BenefitTextBox.Text);
吳漢武.Benefit = benefit;
MessageBox.Show("吳漢武的薪水:\n" + 吳漢武.Salary.ToString());
}
static void Main(string[] args)
{
try
{
Empolyee tom = new Empolyee("湯姆");
tom.Salary = 50000;
tom.ShowSalary();
Console.WriteLine("=================================");
Empolyee peter = new Empolyee("彼得");
// 設定Peter物件的薪水為負數，因此會產生SalaryException例外類別
peter.Salary = -10000;
peter.ShowSalary();
}
catch (SalaryException ex) // 補捉 SalaryException 例外
{
// 呼叫 SalaryException 的 ToString() 方法
Console.WriteLine(ex.ToString());
// 呼叫 SalaryException 的 Message 屬性
Console.WriteLine(ex.Message);
// 呼叫 SalaryException 的ShowMsg()方法
ex.ShowMsg();
}
Console.Read();
}
/// <summary>
/// 根据工号修改信息
/// </summary>
/// <param name="emp"></param>
/// <returns></returns>
public int UpdateEmpolyee(Empolyee emp)
{
return(es.UpdateEmpolyee(emp));
}
/// <summary>
/// 添加人员信息
/// </summary>
/// <param name="empolyee">参数实体类</param>
/// <returns></returns>
public int InsEmpolyee(Empolyee empolyee)
{
return(es.InsEmpolyee(empolyee));
}
public IActionResult Create(Empolyee empolyee)
{
employees.Save(empolyee);
return(RedirectToAction("Index"));
}
public IActionResult Edit(Empolyee empolyee)
{
employees.Update(empolyee);
return(RedirectToAction("Index"));
}
/// <summary>
/// 添加人员信息
/// </summary>
/// <param name="empolyee">参数实体类</param>
/// <returns></returns>
public int InsEmpolyee(Empolyee empolyee)
{
string sql = @"INSERT INTO T_Empolyee
(Emp_Code
,Emp_Name
,Emp_Password
,Emp_UserRole
,Emp_Area
,Emp_zhiwen
,Emp_CardCode
,Emp_Depid
,Emp_Sex
,Emp_Card
,Emp_State
,Emp_Phone
,Emp_Bank
,Emp_OpenBank
,Emp_Birthday
,Emp_Email
,Emp_Education
,Emp_School
,Emp_Entry
,Emp_Enable
,Emp_Clear
)
VALUES
(@Emp_Code
,@Emp_Name
,@Emp_Password
,@Emp_UserRole
,@Emp_Area
,@Emp_zhiwen
,@Emp_CardCode
,@Emp_Depid
,@Emp_Sex
,@Emp_Card
,@Emp_State
,@Emp_Phone
,@Emp_Bank
,@Emp_OpenBank
,@Emp_Birthday
,@Emp_Email
,@Emp_Education
,@Emp_School
,@Emp_Entry
,@Emp_Enable
,@Emp_Clear
)";
SqlParameter[] sps =
{
new SqlParameter("@Emp_Code", XYEEncoding.strCodeHex(empolyee.Emp_Code)),
new SqlParameter("@Emp_Name", XYEEncoding.strCodeHex(empolyee.Emp_Name)),
new SqlParameter("@Emp_Password", XYEEncoding.strCodeHex(empolyee.Emp_Password)),
new SqlParameter("@Emp_UserRole", XYEEncoding.strCodeHex(empolyee.Emp_UserRole)),
new SqlParameter("@Emp_Area", XYEEncoding.strCodeHex(empolyee.Emp_Area)),
new SqlParameter("@Emp_zhiwen", empolyee.Emp_zhiwen),
new SqlParameter("@Emp_CardCode", XYEEncoding.strCodeHex(empolyee.Emp_CardCode)),
new SqlParameter("@Emp_Depid", XYEEncoding.strCodeHex(empolyee.Emp_Depid)),
new SqlParameter("@Emp_Sex", XYEEncoding.strCodeHex(empolyee.Emp_Sex)),
new SqlParameter("@Emp_Card", XYEEncoding.strCodeHex(empolyee.Emp_Card)),
new SqlParameter("@Emp_State", empolyee.Emp_State),
new SqlParameter("@Emp_Phone", XYEEncoding.strCodeHex(empolyee.Emp_Phone)),
new SqlParameter("@Emp_Bank", XYEEncoding.strCodeHex(empolyee.Emp_Bank)),
new SqlParameter("@Emp_OpenBank", XYEEncoding.strCodeHex(empolyee.Emp_OpenBank)),
new SqlParameter("@Emp_Birthday", empolyee.Emp_Birthday),
new SqlParameter("@Emp_Email", XYEEncoding.strCodeHex(empolyee.Emp_Email)),
new SqlParameter("@Emp_Education", XYEEncoding.strCodeHex(empolyee.Emp_Education)),
new SqlParameter("@Emp_School", XYEEncoding.strCodeHex(empolyee.Emp_School)),
new SqlParameter("@Emp_Entry", empolyee.Emp_Entry),
new SqlParameter("@Emp_Enable", empolyee.Emp_Enable),
new SqlParameter("@Emp_Clear", empolyee.Emp_Clear)
};
return(DbHelperSQL.ExecuteSql(sql, sps));
}
public ActionResult Show(int id)
{
Empolyee Emp = context.Empolyees.FirstOrDefault(e => e.Id == id);
return(View("Show", Emp));
}
