You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
79 lines
2.2 KiB
79 lines
2.2 KiB
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using ICSSoft.Frame.Data.Entity;
|
|
using ICSSoft.Frame.Data.DAL;
|
|
using System.Data;
|
|
using System.Data.SqlClient;
|
|
|
|
namespace ICSSoft.Frame.Data.BLL
|
|
{
|
|
public class CheckBLL
|
|
{
|
|
public static DataTable PoArriveCheckData(string LotNO, string dsconn)
|
|
{
|
|
try
|
|
{
|
|
return CheckDAL.PoArriveCheckData(LotNO, dsconn);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
}
|
|
|
|
public static bool UpdateCheck(SqlConnection sqlConnection, SqlTransaction trans, string LotNO, string iStatus, string User, string dsconn)
|
|
{
|
|
try
|
|
{
|
|
return CheckDAL.UpdateCheck(sqlConnection, trans, LotNO, iStatus, User, dsconn);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
}
|
|
|
|
public static DataTable IQCCheckData(string LotNO, string dsconn)
|
|
{
|
|
try
|
|
{
|
|
return CheckDAL.IQCCheckData(LotNO, dsconn);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
}
|
|
|
|
public static bool UpdateIQCCheck(SqlConnection sqlConnection, SqlTransaction trans, string LotNO, string iStatus, string User, string UserName, string WorkPoint, string dsconn)
|
|
{
|
|
try
|
|
{
|
|
return CheckDAL.UpdateIQCCheck(sqlConnection, trans, LotNO, iStatus, User, UserName, WorkPoint, dsconn);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
}
|
|
|
|
public static DataTable isFinished(string LotNO, string dsconn)
|
|
{
|
|
try
|
|
{
|
|
return CheckDAL.isFinished(LotNO, dsconn);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
}
|
|
|
|
public static DataTable QueryAllCheck100(string ITEMCODE, string OPCODE, string WORKPOINT, string dsconn)
|
|
{
|
|
return CheckDAL.QueryAllCheck100(ITEMCODE, OPCODE, WORKPOINT, dsconn);
|
|
}
|
|
}
|
|
}
|