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