public static Int32 Update(IAndonRequestList andon)
{
SqlParameter[] _parameter = { new SqlParameter("@Id", andon.ID),
new SqlParameter("@Decription", andon.Description),
new SqlParameter("@Name", andon.Name),
new SqlParameter("@SysModifier", andon.SysModifier) };
return(Convert.ToInt32(SqlHelper.ExecuteNonQuery(ConnectionString, "sp_AndonRequestList_UpdateById", _parameter)));
}
public static Int32 Insert(IAndonRequestList andon)
{
SqlParameter[] _parameter = { new SqlParameter("@Group", andon.Group),
new SqlParameter("@Description", andon.Description),
new SqlParameter("@Name", andon.Name),
new SqlParameter("@SysCreator", andon.Syscreator) };
return(Convert.ToInt32(SqlHelper.ExecuteNonQuery(ConnectionString, "sp_AndonRequestList_Insert", _parameter)));
}
