private SqlParameter[] PayrollItemToParam(PayrollItem item, string currentUser, bool isInsertOp)
{
List<SqlParameter> paras = new List<SqlParameter>();
paras.Add(new SqlParameter("@ItemID",SqlDbType.VarChar,20));
paras.Add(new SqlParameter("@ItemName",SqlDbType.NVarChar,100));
paras.Add(new SqlParameter("@SystemItem",SqlDbType.Bit));
paras.Add(new SqlParameter("@Unit",SqlDbType.Int));
paras.Add(new SqlParameter("@WageBonus",SqlDbType.Int));
paras.Add(new SqlParameter("@ItemGroup",SqlDbType.Int));
paras.Add(new SqlParameter("@CalcMethod",SqlDbType.Int));
paras.Add(new SqlParameter("@Minus",SqlDbType.Bit));
paras.Add(new SqlParameter("@Fomula",SqlDbType.NVarChar,1000));
paras.Add(new SqlParameter("@UpdateUser",SqlDbType.VarChar,20));
paras[0].Value = item.ItemId;
paras[1].Value = item.ItemName;
paras[2].Value = item.SystemItem;
paras[3].Value = item.Unit;
paras[4].Value = item.WageBonus;
paras[5].Value = item.Group;
paras[6].Value = item.CalcMethod;
paras[7].Value = item.Minus;
paras[8].Value = item.Fomula;
paras[9].Value = currentUser;
if (isInsertOp)
{
paras.Add(new SqlParameter("@CreateUser", SqlDbType.VarChar, 20));
paras[10].Value = currentUser;
}
return paras.ToArray();
}
private List<PayrollItem> DoSearchPayrollItem(string sqlStr)
{
try
{
List<PayrollItem> prItems = new List<PayrollItem>();
DataSet searchResult = DAO.DBAccess.ExecuteAdapter(DAO.DBAccess.SQLConnectionString, CommandType.Text, sqlStr, null);
foreach (DataTable dt in searchResult.Tables)
{
foreach (DataRow dr in dt.Rows)
{
PayrollItem item = new PayrollItem();
DataRowToPayrollItem(dr, item);
prItems.Add(item);
}
}
return prItems;
}
catch (Exception ex)
{
throw new DAOException("E0001", ex);
}
}
private void DataRowToPayrollItem(DataRow dr, PayrollItem item)
{
item.ItemId = dr["ItemId"].ToString();
item.ItemName = dr["ItemName"].ToString();
item.SystemItem = Convert.ToBoolean(dr["SystemItem"]);
item.Unit = Convert.ToInt32(dr["Unit"]);
item.WageBonus = Convert.ToInt32(dr["WageBonus"]);
item.Group = Convert.ToInt32(dr["ItemGroup"]);
item.CalcMethod = Convert.ToInt32(dr["CalcMethod"]);
item.Minus = Convert.ToBoolean(dr["Minus"]);
item.Fomula = dr["Fomula"].ToString();
}
public int updatePayrollItem(PayrollItem item, string currentUser, SqlTransaction trans)
{
string sqlStr = dbUtil.getSqlStatement("SQL_Payroll_PayrollItem_Update");
int resultCount = 0;
SqlParameter[] sqlParms = PayrollItemToParam(item, currentUser, false);
try
{
return (int)DAO.DBAccess.ExecuteNonQuery(trans, CommandType.Text, sqlStr, sqlParms);
}
catch (Exception ex)
{
throw new DAOException("E0001", ex);
}
}
public PayrollItem searchPayrollItemById(string itemId)
{
string sqlStr = dbUtil.getSqlStatement("SQL_Payroll_PayrollItem_SearchById");
SqlParameter[] sqlParms = {
new SqlParameter("@ItemId",SqlDbType.VarChar,20)
};
sqlParms[0].Value = itemId;
try
{
DataSet resultSet = DAO.DBAccess.ExecuteAdapter(DAO.DBAccess.SQLConnectionString, CommandType.Text, sqlStr, sqlParms);
UtilService utilService = new UtilService();
if (!utilService.isNullDataset(resultSet))
{
PayrollItem item = new PayrollItem();
item.ItemId = resultSet.Tables[0].Rows[0]["ItemId"].ToString();
item.ItemName = resultSet.Tables[0].Rows[0]["ItemName"].ToString();
item.SystemItem = Convert.ToBoolean(resultSet.Tables[0].Rows[0]["SystemItem"]);
item.Unit = Convert.ToInt32(resultSet.Tables[0].Rows[0]["Unit"]);
item.WageBonus = Convert.ToInt32(resultSet.Tables[0].Rows[0]["WageBonus"]);
item.Group = Convert.ToInt32(resultSet.Tables[0].Rows[0]["ItemGroup"]);
item.CalcMethod = Convert.ToInt32(resultSet.Tables[0].Rows[0]["CalcMethod"]);
item.Minus = Convert.ToBoolean(resultSet.Tables[0].Rows[0]["Minus"]);
item.Fomula = resultSet.Tables[0].Rows[0]["Fomula"].ToString();
return item;
}
return null;
}
catch (Exception ex)
{
throw new DAOException("E0001", ex);
}
}
private void ReadPageData(PayrollItem item)
{
item.ItemName = txtName.Text;
item.WageBonus = cmbWageBonus.SelectedIndex;
item.Group = cmbGroup.SelectedIndex;
item.Unit = (int)((cmbUnit.SelectedItem as ExtItem).Tag);
}
