public bool saveSalaryData(DataSet.DsPSMS.ST_SALARYRow dr, out string msg)
{
bool isOk = true;
if (dr == null)
{
msg = "data is empty ";
return(false);
}
try
{
salaryDB.Open();
int result = salaryDB.insertSalaryData(dr);
msg = "insert complete";
}
catch
{
msg = "error occurs when inserting data to ST_SALARY table";
return(false);
}
finally
{
salaryDB.Close();
}
return(isOk);
}
protected int calculateSalary(DataSet.DsPSMS.ST_SALARYRow temp, string salaryATM)
{
int resultAmt = 0;
if (temp != null)
{
resultAmt = int.Parse(salaryATM);
if (temp.LEAVE_AMOUNT != 0)
{
int leave = temp.LEAVE_TIMES * temp.LEAVE_AMOUNT;
resultAmt -= leave;
}
if (temp.LATE_AMOUNT != 0)
{
int late = temp.LATE_TIMES * temp.LATE_AMOUNT;
resultAmt -= late;
}
if (temp.OT_AMOUNT != 0)
{
resultAmt += temp.OT_AMOUNT;
}
}
return(resultAmt);
}
public int insertSalaryData(DataSet.DsPSMS.ST_SALARYRow dr)
{
int result;
if (dr == null)
{
return(-1);
}
int currentYear = DateTime.Now.Year;
string query = " INSERT INTO ST_SALARY (EDU_YEAR, YEAR, MONTH,STAFF_ID,LEAVE_TIMES,LEAVE_AMOUNT,LATE_TIMES,LATE_AMOUNT,OT_AMOUNT,SALARY_AMOUNT,REMARK) VALUES (" + currentYear + ",'" + dr.YEAR + "','" + dr.MONTH + "','" + dr.STAFF_ID + "'," + dr.LEAVE_TIMES + "," + dr.LEAVE_AMOUNT + "," + dr.LATE_TIMES + "," + dr.LATE_AMOUNT + "," + dr.OT_AMOUNT + "," + dr.SALARY_AMOUNT + "," + dr.REMARK + ")";
string sqlQuery = query;
SqlCommand cmd = new SqlCommand(query, conn);
result = cmd.ExecuteNonQuery();
return(result);
}
