public static DataSet Retrieve(IAndonReportLog andon) { SqlParameter[] _parameter = { new SqlParameter("@Warehouse", andon.Warehouse), new SqlParameter("@Machine", andon.Machine), new SqlParameter("@Condition", andon.Condition), new SqlParameter("@Group", andon.Group) }; return(SqlHelper.ExecuteDataset(ConnectionString, "sp_AndonReportLogs_SelectAll", _parameter)); }
public static int Update(IAndonReportLog andonReport) { SqlParameter[] _parameter = { new SqlParameter("@Id", andonReport.ID), new SqlParameter("@Condition", andonReport.Condition), new SqlParameter("@CorrectiveAction", andonReport.CorrectiveAction), new SqlParameter("@StartTime", andonReport.StartTime), new SqlParameter("@EndTime", andonReport.EndTime), new SqlParameter("@SysModifier", andonReport.SysModifier) }; return(Convert.ToInt32(SqlHelper.ExecuteNonQuery(ConnectionString, "sp_AndonReportLogs_UpdateById", _parameter))); }
public static int Insert(IAndonReportLog andonReport) { SqlParameter[] _parameter = { new SqlParameter("@Condition", andonReport.Condition), new SqlParameter("@Warehouse", andonReport.Warehouse), new SqlParameter("@Machine", andonReport.Machine), new SqlParameter("@Problem", andonReport.Problem), new SqlParameter("@Group", andonReport.Group), new SqlParameter("@SysCreator", andonReport.SysCreator) }; return(Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, "sp_AndonReportLogs_Insert", _parameter))); }