public SalarySettingVO GetByID(int id)
{
SalarySettingVO vo = new SalarySettingVO();
DataTable dt = Select("ID=" + id + "");
if (dt.Rows.Count > 0)
{
vo = b.ConvertObj(dt.Rows[0], new SalarySettingVO()) as SalarySettingVO;
}
return(vo);
}
public SalarySettingVO GetByFixedRulesIdAndSalaryItem(string query)
{
SalarySettingVO vo = new SalarySettingVO();
DataTable dt = b.SelectByQuery(query);
if (dt.Rows.Count > 0)
{
vo = b.ConvertObj(dt.Rows[0], new SalarySettingVO()) as SalarySettingVO;
}
return(vo);
}
public int Insert(SalarySettingVO vo)
{
int lastInsertId = 0;
string item = null;
try
{
lastInsertId = b.Insert("PR_SalarySetting", b.ConvertColName(vo), b.ConvertValueList(vo));
DataTable dt = b.SelectByQuery("SELECT Max(LINKER) AS LINKER FROM PR_SalarySetting");
foreach (DataRow dr in dt.Rows)
{
if (dr["Linker"] == null || dr["Linker"] == "")
{
item = "item_0000";
}
else
{
item = dr["Linker"].ToString();
}
string latestLinker = item;
int num = int.Parse(latestLinker.Split('_')[1]);
num++;
if (num < 10)
{
latestLinker = "item_000" + num;
}
else if (num < 100)
{
latestLinker = "item_00" + num;
}
else if (num < 1000)
{
latestLinker = "item_0" + num;
}
else
{
latestLinker = "item_" + num;
}
b.SelectByQuery("UPDATE PR_SalarySetting SET LINKER='" + latestLinker + "' WHERE ID=" + lastInsertId + " AND FixedRulesID=" + vo.FixedRulesID + "");
break;
}
}
catch (SqlException ex)
{
throw ex;
}
return(lastInsertId);
}
public int Create(SalarySettingVO vo)
{
int id;
if (!dao.isExist(vo.Id.ToString()))
{
id = dao.Insert(vo);
}
else
{
id = dao.Update(vo);
}
return(id);
}
public int Update(SalarySettingVO vo)
{
int ID = 0;
try
{
b.Update("PR_SalarySetting", vo.Id.ToString(), b.ConvertColName(vo), b.ConvertValueList(vo));
ID = vo.Id;
}
catch (SqlException ex)
{
throw ex;
}
return(ID);
}
