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));
}
