/// <summary>
/// 得到一个对象实体
/// </summary>
public FileZillaServerModel.Salary GetModel(string ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,EMPLOYEEID,MONTHDATE,BASESALARY,CONTRACTSALARY,PIECEWAGE,PIECEPENALTY,FULLATTEND,OVERTIMEWAGE,AGEWAGE,ACCOMMODATION_ALLOWANCE,MEAL_ALLOWANCE,ATTENDANCEPENALTY,OTHERWAGE,SOCIALSECURITY_INDIVIDUAL,SOCIALSECURITY_COMPANY,HOUSINGPROVIDENTFUND_INDIVIDUAL,HOUSINGPROVIDENTFUND_COMPANY,TOTALINCOME,REALSALARY,REALSALARY_COMPANY from salary ");
strSql.Append(" where ID=@ID ");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.VarChar, 40)
};
parameters[0].Value = ID;
FileZillaServerModel.Salary model = new FileZillaServerModel.Salary();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(FileZillaServerModel.Salary model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into salary(");
strSql.Append("ID,EMPLOYEEID,MONTHDATE,BASESALARY,CONTRACTSALARY,PIECEWAGE,PIECEPENALTY,FULLATTEND,OVERTIMEWAGE,AGEWAGE,ACCOMMODATION_ALLOWANCE,MEAL_ALLOWANCE,ATTENDANCEPENALTY,OTHERWAGE,TOTALORDERAMOUNT,SOCIALSECURITY_INDIVIDUAL,SOCIALSECURITY_COMPANY,HOUSINGPROVIDENTFUND_INDIVIDUAL,HOUSINGPROVIDENTFUND_COMPANY,TOTALINCOME,REALSALARY,REALSALARY_COMPANY)");
strSql.Append(" values (");
strSql.Append("@ID,@EMPLOYEEID,@MONTHDATE,@BASESALARY,@CONTRACTSALARY,@PIECEWAGE,@PIECEPENALTY,@FULLATTEND,@OVERTIMEWAGE,@AGEWAGE,@ACCOMMODATION_ALLOWANCE,@MEAL_ALLOWANCE,@ATTENDANCEPENALTY,@OTHERWAGE,@TOTALORDERAMOUNT,@SOCIALSECURITY_INDIVIDUAL,@SOCIALSECURITY_COMPANY,@HOUSINGPROVIDENTFUND_INDIVIDUAL,@HOUSINGPROVIDENTFUND_COMPANY,@TOTALINCOME,@REALSALARY,@REALSALARY_COMPANY)");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.VarChar, 40),
new MySqlParameter("@EMPLOYEEID", MySqlDbType.VarChar, 40),
new MySqlParameter("@MONTHDATE", MySqlDbType.Date),
new MySqlParameter("@BASESALARY", MySqlDbType.Decimal, 10),
new MySqlParameter("@CONTRACTSALARY", MySqlDbType.Decimal, 8),
new MySqlParameter("@PIECEWAGE", MySqlDbType.Decimal, 8),
new MySqlParameter("@PIECEPENALTY", MySqlDbType.Decimal, 8),
new MySqlParameter("@FULLATTEND", MySqlDbType.Decimal, 8),
new MySqlParameter("@OVERTIMEWAGE", MySqlDbType.Decimal, 8),
new MySqlParameter("@AGEWAGE", MySqlDbType.Decimal, 8),
new MySqlParameter("@ACCOMMODATION_ALLOWANCE", MySqlDbType.Decimal, 8),
new MySqlParameter("@MEAL_ALLOWANCE", MySqlDbType.Decimal, 8),
new MySqlParameter("@ATTENDANCEPENALTY", MySqlDbType.Decimal, 8),
new MySqlParameter("@OTHERWAGE", MySqlDbType.Decimal, 8),
new MySqlParameter("@TOTALORDERAMOUNT", MySqlDbType.Decimal, 8),
new MySqlParameter("@SOCIALSECURITY_INDIVIDUAL", MySqlDbType.Decimal, 8),
new MySqlParameter("@SOCIALSECURITY_COMPANY", MySqlDbType.Decimal, 8),
new MySqlParameter("@HOUSINGPROVIDENTFUND_INDIVIDUAL", MySqlDbType.Decimal, 8),
new MySqlParameter("@HOUSINGPROVIDENTFUND_COMPANY", MySqlDbType.Decimal, 8),
new MySqlParameter("@TOTALINCOME", MySqlDbType.Decimal, 8),
new MySqlParameter("@REALSALARY", MySqlDbType.Decimal, 10),
new MySqlParameter("@REALSALARY_COMPANY", MySqlDbType.Decimal, 10)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.EMPLOYEEID;
parameters[2].Value = model.MONTHDATE;
parameters[3].Value = model.BASESALARY;
parameters[4].Value = model.CONTRACTSALARY;
parameters[5].Value = model.PIECEWAGE;
parameters[6].Value = model.PIECEPENALTY;
parameters[7].Value = model.FULLATTEND;
parameters[8].Value = model.OVERTIMEWAGE;
parameters[9].Value = model.AGEWAGE;
parameters[10].Value = model.ACCOMMODATION_ALLOWANCE;
parameters[11].Value = model.MEAL_ALLOWANCE;
parameters[12].Value = model.ATTENDANCEPENALTY;
parameters[13].Value = model.OTHERWAGE;
parameters[14].Value = model.TOTALORDERAMOUNT;
parameters[15].Value = model.SOCIALSECURITY_INDIVIDUAL;
parameters[16].Value = model.SOCIALSECURITY_COMPANY;
parameters[17].Value = model.HOUSINGPROVIDENTFUND_INDIVIDUAL;
parameters[18].Value = model.HOUSINGPROVIDENTFUND_COMPANY;
parameters[19].Value = model.TOTALINCOME;
parameters[20].Value = model.REALSALARY;
parameters[21].Value = model.REALSALARY_COMPANY;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public FileZillaServerModel.Salary DataRowToModel(DataRow row)
{
FileZillaServerModel.Salary model = new FileZillaServerModel.Salary();
if (row != null)
{
if (row["ID"] != null)
{
model.ID = row["ID"].ToString();
}
if (row["EMPLOYEEID"] != null)
{
model.EMPLOYEEID = row["EMPLOYEEID"].ToString();
}
if (row["MONTHDATE"] != null && row["MONTHDATE"].ToString() != "")
{
model.MONTHDATE = DateTime.Parse(row["MONTHDATE"].ToString());
}
if (row["BASESALARY"] != null && row["BASESALARY"].ToString() != "")
{
model.BASESALARY = decimal.Parse(row["BASESALARY"].ToString());
}
if (row["CONTRACTSALARY"] != null && row["CONTRACTSALARY"].ToString() != "")
{
model.CONTRACTSALARY = decimal.Parse(row["CONTRACTSALARY"].ToString());
}
if (row["PIECEWAGE"] != null && row["PIECEWAGE"].ToString() != "")
{
model.PIECEWAGE = decimal.Parse(row["PIECEWAGE"].ToString());
}
if (row["PIECEPENALTY"] != null && row["PIECEPENALTY"].ToString() != "")
{
model.PIECEPENALTY = decimal.Parse(row["PIECEPENALTY"].ToString());
}
if (row["FULLATTEND"] != null && row["FULLATTEND"].ToString() != "")
{
model.FULLATTEND = decimal.Parse(row["FULLATTEND"].ToString());
}
if (row["OVERTIMEWAGE"] != null && row["OVERTIMEWAGE"].ToString() != "")
{
model.OVERTIMEWAGE = decimal.Parse(row["OVERTIMEWAGE"].ToString());
}
if (row["AGEWAGE"] != null && row["AGEWAGE"].ToString() != "")
{
model.AGEWAGE = decimal.Parse(row["AGEWAGE"].ToString());
}
if (row["ACCOMMODATION_ALLOWANCE"] != null && row["ACCOMMODATION_ALLOWANCE"].ToString() != "")
{
model.ACCOMMODATION_ALLOWANCE = decimal.Parse(row["ACCOMMODATION_ALLOWANCE"].ToString());
}
if (row["MEAL_ALLOWANCE"] != null && row["MEAL_ALLOWANCE"].ToString() != "")
{
model.MEAL_ALLOWANCE = decimal.Parse(row["MEAL_ALLOWANCE"].ToString());
}
if (row["ATTENDANCEPENALTY"] != null && row["ATTENDANCEPENALTY"].ToString() != "")
{
model.ATTENDANCEPENALTY = decimal.Parse(row["ATTENDANCEPENALTY"].ToString());
}
if (row["OTHERWAGE"] != null && row["OTHERWAGE"].ToString() != "")
{
model.OTHERWAGE = decimal.Parse(row["OTHERWAGE"].ToString());
}
if (row["SOCIALSECURITY_INDIVIDUAL"] != null && row["SOCIALSECURITY_INDIVIDUAL"].ToString() != "")
{
model.SOCIALSECURITY_INDIVIDUAL = decimal.Parse(row["SOCIALSECURITY_INDIVIDUAL"].ToString());
}
if (row["SOCIALSECURITY_COMPANY"] != null && row["SOCIALSECURITY_COMPANY"].ToString() != "")
{
model.SOCIALSECURITY_COMPANY = decimal.Parse(row["SOCIALSECURITY_COMPANY"].ToString());
}
if (row["HOUSINGPROVIDENTFUND_INDIVIDUAL"] != null && row["HOUSINGPROVIDENTFUND_INDIVIDUAL"].ToString() != "")
{
model.HOUSINGPROVIDENTFUND_INDIVIDUAL = decimal.Parse(row["HOUSINGPROVIDENTFUND_INDIVIDUAL"].ToString());
}
if (row["HOUSINGPROVIDENTFUND_COMPANY"] != null && row["HOUSINGPROVIDENTFUND_COMPANY"].ToString() != "")
{
model.HOUSINGPROVIDENTFUND_COMPANY = decimal.Parse(row["HOUSINGPROVIDENTFUND_COMPANY"].ToString());
}
if (row["TOTALINCOME"] != null && row["TOTALINCOME"].ToString() != "")
{
model.TOTALINCOME = decimal.Parse(row["TOTALINCOME"].ToString());
}
if (row["REALSALARY"] != null && row["REALSALARY"].ToString() != "")
{
model.REALSALARY = decimal.Parse(row["REALSALARY"].ToString());
}
if (row["REALSALARY_COMPANY"] != null && row["REALSALARY_COMPANY"].ToString() != "")
{
model.REALSALARY_COMPANY = decimal.Parse(row["REALSALARY_COMPANY"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FileZillaServerModel.Salary model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update salary set ");
strSql.Append("EMPLOYEEID=@EMPLOYEEID,");
strSql.Append("MONTHDATE=@MONTHDATE,");
strSql.Append("BASESALARY=@BASESALARY,");
strSql.Append("CONTRACTSALARY=@CONTRACTSALARY,");
strSql.Append("PIECEWAGE=@PIECEWAGE,");
strSql.Append("PIECEPENALTY=@PIECEPENALTY,");
strSql.Append("FULLATTEND=@FULLATTEND,");
strSql.Append("OVERTIMEWAGE=@OVERTIMEWAGE,");
strSql.Append("AGEWAGE=@AGEWAGE,");
strSql.Append("ACCOMMODATION_ALLOWANCE=@ACCOMMODATION_ALLOWANCE,");
strSql.Append("MEAL_ALLOWANCE=@MEAL_ALLOWANCE,");
strSql.Append("ATTENDANCEPENALTY=@ATTENDANCEPENALTY,");
strSql.Append("OTHERWAGE=@OTHERWAGE,");
strSql.Append("TOTALORDERAMOUNT=@TOTALORDERAMOUNT,");
strSql.Append("SOCIALSECURITY_INDIVIDUAL=@SOCIALSECURITY_INDIVIDUAL,");
strSql.Append("SOCIALSECURITY_COMPANY=@SOCIALSECURITY_COMPANY,");
strSql.Append("HOUSINGPROVIDENTFUND_INDIVIDUAL=@HOUSINGPROVIDENTFUND_INDIVIDUAL,");
strSql.Append("HOUSINGPROVIDENTFUND_COMPANY=@HOUSINGPROVIDENTFUND_COMPANY,");
strSql.Append("TOTALINCOME=@TOTALINCOME,");
strSql.Append("REALSALARY=@REALSALARY,");
strSql.Append("REALSALARY_COMPANY=@REALSALARY_COMPANY");
strSql.Append(" where ID=@ID ");
MySqlParameter[] parameters =
{
new MySqlParameter("@EMPLOYEEID", MySqlDbType.VarChar, 40),
new MySqlParameter("@MONTHDATE", MySqlDbType.Date),
new MySqlParameter("@BASESALARY", MySqlDbType.Decimal, 10),
new MySqlParameter("@CONTRACTSALARY", MySqlDbType.Decimal, 8),
new MySqlParameter("@PIECEWAGE", MySqlDbType.Decimal, 8),
new MySqlParameter("@PIECEPENALTY", MySqlDbType.Decimal, 8),
new MySqlParameter("@FULLATTEND", MySqlDbType.Decimal, 8),
new MySqlParameter("@OVERTIMEWAGE", MySqlDbType.Decimal, 8),
new MySqlParameter("@AGEWAGE", MySqlDbType.Decimal, 8),
new MySqlParameter("@ACCOMMODATION_ALLOWANCE", MySqlDbType.Decimal, 8),
new MySqlParameter("@MEAL_ALLOWANCE", MySqlDbType.Decimal, 8),
new MySqlParameter("@ATTENDANCEPENALTY", MySqlDbType.Decimal, 8),
new MySqlParameter("@OTHERWAGE", MySqlDbType.Decimal, 8),
new MySqlParameter("@TOTALORDERAMOUNT", MySqlDbType.Decimal, 8),
new MySqlParameter("@SOCIALSECURITY_INDIVIDUAL", MySqlDbType.Decimal, 8),
new MySqlParameter("@SOCIALSECURITY_COMPANY", MySqlDbType.Decimal, 8),
new MySqlParameter("@HOUSINGPROVIDENTFUND_INDIVIDUAL", MySqlDbType.Decimal, 8),
new MySqlParameter("@HOUSINGPROVIDENTFUND_COMPANY", MySqlDbType.Decimal, 8),
new MySqlParameter("@TOTALINCOME", MySqlDbType.Decimal, 8),
new MySqlParameter("@REALSALARY", MySqlDbType.Decimal, 10),
new MySqlParameter("@REALSALARY_COMPANY", MySqlDbType.Decimal, 10),
new MySqlParameter("@ID", MySqlDbType.VarChar, 40)
};
parameters[0].Value = model.EMPLOYEEID;
parameters[1].Value = model.MONTHDATE;
parameters[2].Value = model.BASESALARY;
parameters[3].Value = model.CONTRACTSALARY;
parameters[4].Value = model.PIECEWAGE;
parameters[5].Value = model.PIECEPENALTY;
parameters[6].Value = model.FULLATTEND;
parameters[7].Value = model.OVERTIMEWAGE;
parameters[8].Value = model.AGEWAGE;
parameters[9].Value = model.ACCOMMODATION_ALLOWANCE;
parameters[10].Value = model.MEAL_ALLOWANCE;
parameters[11].Value = model.ATTENDANCEPENALTY;
parameters[12].Value = model.OTHERWAGE;
parameters[13].Value = model.TOTALORDERAMOUNT;
parameters[14].Value = model.SOCIALSECURITY_INDIVIDUAL;
parameters[15].Value = model.SOCIALSECURITY_COMPANY;
parameters[16].Value = model.HOUSINGPROVIDENTFUND_INDIVIDUAL;
parameters[17].Value = model.HOUSINGPROVIDENTFUND_COMPANY;
parameters[18].Value = model.TOTALINCOME;
parameters[19].Value = model.REALSALARY;
parameters[20].Value = model.REALSALARY_COMPANY;
parameters[21].Value = model.ID;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
