public static MOABOVE3000 GetMOABOVE3000ByID(int id)
{
MOABOVE3000 mOABOVE3000 = new MOABOVE3000();
SqlMOABOVE3000Provider sqlMOABOVE3000Provider = new SqlMOABOVE3000Provider();
mOABOVE3000 = sqlMOABOVE3000Provider.GetMOABOVE3000ByID(id);
return(mOABOVE3000);
}
public bool UpdateMOABOVE3000(MOABOVE3000 mOABOVE3000)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_UpdateMOABOVE3000", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@MOABOVE3000ID", SqlDbType.Int).Value = mOABOVE3000.MOABOVE3000ID;
cmd.Parameters.Add("@DT", SqlDbType.DateTime).Value = mOABOVE3000.DT;
cmd.Parameters.Add("@CUST_ID", SqlDbType.VarChar).Value = mOABOVE3000.CUST_ID;
cmd.Parameters.Add("@STARTNO", SqlDbType.VarChar).Value = mOABOVE3000.STARTNO;
cmd.Parameters.Add("@ENDNO", SqlDbType.VarChar).Value = mOABOVE3000.ENDNO;
cmd.Parameters.Add("@AMOUNT", SqlDbType.Int).Value = mOABOVE3000.AMOUNT;
cmd.Parameters.Add("@EMP_ID", SqlDbType.Int).Value = mOABOVE3000.EMP_ID;
cmd.Parameters.Add("@STATION_ID", SqlDbType.Int).Value = mOABOVE3000.STATION_ID;
cmd.Parameters.Add("@SHIFT_ID", SqlDbType.Int).Value = mOABOVE3000.SHIFT_ID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public MOABOVE3000 GetMOABOVE3000FromReader(IDataReader reader)
{
try
{
MOABOVE3000 mOABOVE3000 = new MOABOVE3000
(
(int)reader["MOABOVE3000ID"],
(DateTime)reader["DT"],
reader["CUST_ID"].ToString(),
reader["STARTNO"].ToString(),
reader["ENDNO"].ToString(),
(int)reader["AMOUNT"],
(int)reader["EMP_ID"],
(int)reader["STATION_ID"],
(int)reader["SHIFT_ID"]
);
return(mOABOVE3000);
}
catch (Exception ex)
{
return(null);
}
}
public static bool UpdateMOABOVE3000(MOABOVE3000 mOABOVE3000)
{
SqlMOABOVE3000Provider sqlMOABOVE3000Provider = new SqlMOABOVE3000Provider();
return(sqlMOABOVE3000Provider.UpdateMOABOVE3000(mOABOVE3000));
}
public static int InsertMOABOVE3000(MOABOVE3000 mOABOVE3000)
{
SqlMOABOVE3000Provider sqlMOABOVE3000Provider = new SqlMOABOVE3000Provider();
return(sqlMOABOVE3000Provider.InsertMOABOVE3000(mOABOVE3000));
}
