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)));
}
