static void Main(string[] args) { Employee emp = new GeneralStaff(); emp.Name = "Abc Xyz"; //---- More code follows---- }
// public List<Staff> GetPersonnel() //显示员工简要信息 public JsonResult GetPersonnelAjax() { string query = Request["query"]; string department = Request["department"]; int flag = 0; int flag_id = 0; int flag_department = 0; if (query == "") { flag_id = 1; } if (department == "0") { flag_department = 1; } if (query == "" && department == "0") { flag = 1; } List <Staff> staffs = new List <Staff>(); string conn = ConfigurationManager.AppSettings["DBConn"]; MySqlConnection con = new MySqlConnection(conn); con.Open(); MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "select id,department,position,duty,type,name from staff where ((id=@id or @flag_id or name like @name)and (department=@department or @flag_department )) or @flag;"; cmd.Parameters.AddWithValue("@id", query); cmd.Parameters.AddWithValue("@department", department); cmd.Parameters.AddWithValue("@flag_id", flag_id); cmd.Parameters.AddWithValue("@name", "%" + query + "%"); cmd.Parameters.AddWithValue("@flag", flag); cmd.Parameters.AddWithValue("@flag_department", flag_department); cmd.Connection = con; MySqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { Staff staff = new GeneralStaff(); staff.Id = Convert.ToInt32(dr["id"].ToString()); staff.Department = Convert.ToInt32(dr["department"].ToString()); staff.Position = Convert.ToInt32(dr["position"].ToString()); staff.Duty = Convert.ToInt32(dr["duty"].ToString()); staff.Type = Convert.ToInt32(dr["type"].ToString()); staff.Name = dr["name"].ToString(); if (staff != null) { staffs.Add(staff); } } //string jsonStr = JsonConvert.SerializeObject(staffs);//将链表转成json字符串 //JsonResult json = new JsonResult(); //json dr.Close(); con.Close(); return(Json(staffs, JsonRequestBehavior.AllowGet)); }
//计算工资并添加到数据库 public JsonResult CountSalaryAjax() { int year = Convert.ToInt32(Request["year"].Trim()); int month = Convert.ToInt32(Request["month"].Trim()); List <GeneralStaff> generalStaffs = new List <GeneralStaff>(); List <Salary> salaries = new List <Salary>(); string conn = ConfigurationManager.AppSettings["DBConn"]; MySqlConnection con = new MySqlConnection(conn); con.Open(); MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "select id,department,position,duty,type,name,month_day,grade,sale,target,reach_bonus,commission,fixed,alltsutomu from staff"; cmd.Connection = con; MySqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { GeneralStaff general = null; if (dr["position"].ToString().Trim() == "3") { Technician technician = new Technician(); technician.Grade = Convert.ToInt32(dr["grade"].ToString()); general = technician; } else if (dr["position"].ToString().Trim() == "2") { Salesman salesman = new Salesman(); salesman.Sale = Convert.ToInt32(dr["sale"].ToString()); salesman.Target = Convert.ToInt32(dr["target"].ToString()); salesman.ReachBonus = Convert.ToInt32(dr["reach_bonus"].ToString()); salesman.Commission = Convert.ToInt32(dr["commission"].ToString()); general = salesman; } else { GeneralStaff generalStaff = new GeneralStaff(); general = generalStaff; } general.Id = Convert.ToInt32(dr["id"].ToString()); general.Department = Convert.ToInt32(dr["department"].ToString()); general.Position = Convert.ToInt32(dr["position"].ToString()); general.Duty = Convert.ToInt32(dr["duty"].ToString()); general.Type = Convert.ToInt32(dr["type"].ToString()); general.Name = dr["name"].ToString(); general.MonthTotalDays = Convert.ToInt32(dr["month_day"].ToString()); general.Fixed = Convert.ToInt32(dr["Fixed"].ToString()); general.AllTsutomu = Convert.ToInt32(dr["alltsutomu"].ToString()); general.Absence = 0; general.SickLeave = 0; general.Lates = 0; general.OvertimeDay = 2; generalStaffs.Add(general); } dr.Close(); foreach (GeneralStaff g in generalStaffs) { Salary salary = g.GetSalary(year, month); salaries.Add(salary); } foreach (Salary salary in salaries) { cmd.CommandText = "insert into salary (staff_id,year,month,total,overtime,leavemoney,late,extra,reachbonus,alltsutomued,technical,fixed) " + "values(@staff_id,@year,@month,@total,@overtime,@leavemoney,@late,@extra,@reachbonus,@alltsutomued,@technical,@fixed)"; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@staff_id", salary.Staff_id); cmd.Parameters.AddWithValue("@year", salary.Year); cmd.Parameters.AddWithValue("@month", salary.Month); //cmd.Parameters.AddWithValue("@total", 123456); cmd.Parameters.AddWithValue("@total", salary.Total); cmd.Parameters.AddWithValue("@overtime", salary.Overtime); cmd.Parameters.AddWithValue("@leavemoney", salary.Leave); cmd.Parameters.AddWithValue("@late", salary.Late); cmd.Parameters.AddWithValue("@extra", salary.Extra); cmd.Parameters.AddWithValue("@reachbonus", salary.ReachBonus); cmd.Parameters.AddWithValue("@alltsutomued", salary.AllTsutomu); cmd.Parameters.AddWithValue("@technical", salary.TechnicalAllowance); cmd.Parameters.AddWithValue("@fixed", salary.Fixed); //cmd.Connection = con; cmd.ExecuteNonQuery(); } con.Close(); //string jsonStr = JsonConvert.SerializeObject(salaries); //return jsonStr; return(Json(salaries, JsonRequestBehavior.AllowGet)); }