public ReturnMachineTypeFrequency DeleteByMachineTypeID(int MachineTypeID) { ReturnMachineTypeFrequency returnMachineTypeFrequency = new ReturnMachineTypeFrequency(); try { // Gọi vào DB để lấy dữ liệu. using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection()) { using (SqlCommand cmd = new SqlCommand("", sqlConnection)) { cmd.CommandText = "sp_tMachineTypeFrequency_DeleteByMachineTypeID"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@MachineTypeID", SqlDbType.Int)).Value = MachineTypeID; cmd.ExecuteNonQuery(); returnMachineTypeFrequency.Code = "00"; returnMachineTypeFrequency.Message = "Cập nhật dữ liệu thành công."; } } } catch (Exception ex) { returnMachineTypeFrequency.Code = "99"; returnMachineTypeFrequency.Message = "Lỗi xử lý dữ liệu: " + ex.ToString(); returnMachineTypeFrequency.Total = 0; returnMachineTypeFrequency.lstMachineTypeFrequency = null; mylog4net.Error("", ex); } return(returnMachineTypeFrequency); }
public ReturnMachineTypeFrequency GetbyMachineTypeID(int MachineTypeID) { List <MachineTypeFrequency> lstMachineTypeFrequency = null; MachineTypeFrequency machineTypeFrequency = null; ReturnMachineTypeFrequency returnMachineTypeFrequency = new ReturnMachineTypeFrequency(); try { using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection()) { using (SqlCommand cmd = new SqlCommand("", sqlConnection)) { //cmd.Connection = _sqlConnection; cmd.CommandText = "sp_tMachineTypeFrequency_SelectByMachineTypeID"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@MachineTypeID", SqlDbType.Int)).Value = MachineTypeID; using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd, sqlConnection)) { if (sqlDr.HasRows) { lstMachineTypeFrequency = new List <MachineTypeFrequency>(); while (sqlDr.Read()) { machineTypeFrequency = new MachineTypeFrequency(); machineTypeFrequency.ID = Convert.ToInt16(sqlDr["ID"].ToString()); machineTypeFrequency.MachineTypeID = Convert.ToInt32(sqlDr["MachineTypeID"].ToString()); machineTypeFrequency.FrequencyID = Convert.ToInt16(sqlDr["FrequencyID"].ToString()); lstMachineTypeFrequency.Add(machineTypeFrequency); } returnMachineTypeFrequency.Code = "00"; returnMachineTypeFrequency.Message = "Lấy dữ liệu thành công."; returnMachineTypeFrequency.lstMachineTypeFrequency = lstMachineTypeFrequency; returnMachineTypeFrequency.Total = lstMachineTypeFrequency.Count; } else { returnMachineTypeFrequency.Code = "01"; returnMachineTypeFrequency.Message = "Không tồn tại bản ghi nào."; returnMachineTypeFrequency.Total = 0; returnMachineTypeFrequency.lstMachineTypeFrequency = null; } } } } } catch (Exception ex) { returnMachineTypeFrequency.Code = "99"; returnMachineTypeFrequency.Message = "Lỗi xử lý dữ liệu: " + ex.ToString(); returnMachineTypeFrequency.Total = 0; returnMachineTypeFrequency.lstMachineTypeFrequency = null; mylog4net.Error("", ex); } return(returnMachineTypeFrequency); }