}////根据ID检索计件项目,用于取出数据进行编辑
public int Insert_SalaryPieceItemChangeRecord(SalaryPieceworkItemMaintananceInfo sPIMI)
{
return((int)SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_I_SalaryPieceItemChangeRecord",
new SqlParameter("@SPI_ID", sPIMI.SPI_ID), new SqlParameter("@SPICR_FormerPrice", sPIMI.SPICR_FormerPrice),
new SqlParameter("@SPICR_NewPrice", sPIMI.SPICR_NewPrice), new SqlParameter("@SPICR_OpPerson", sPIMI.SPICR_OpPerson),
new SqlParameter("@SPICR_ExecDate", sPIMI.SPICR_ExecDate)));
}//新增计件历史单价
public int Insert_SalaryPieceworkItem(SalaryPieceworkItemMaintananceInfo sPIMI)
{
return((int)SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_I_SalaryPieceworkItem",
new SqlParameter("@SPI_ID", sPIMI.SPI_ID), new SqlParameter("@SPS_ID", sPIMI.SPS_ID),
new SqlParameter("@PBC_ID", sPIMI.PBC_ID), new SqlParameter("@SPI_Name", sPIMI.SPI_Name), new SqlParameter("@SPI_UnitPrice", sPIMI.SPI_UnitPrice),
new SqlParameter("@SPI_IsDeleted", sPIMI.SPI_IsDeleted)));
}//新增计件项目
public int Update_SalaryPieceworkItem(SalaryPieceworkItemMaintananceInfo sPIMI)
{
return(iSPIM.Update_SalaryPieceworkItem(sPIMI));
}
public int Insert_SalaryPieceItemChangeRecord(SalaryPieceworkItemMaintananceInfo sPIMI)
{
return(iSPIM.Insert_SalaryPieceItemChangeRecord(sPIMI));
}//新增计件历史单价
public int Insert_SalaryPieceworkItem(SalaryPieceworkItemMaintananceInfo sPIMI)
{
return(iSPIM.Insert_SalaryPieceworkItem(sPIMI));
}
