public ReturnMachineMtnFrequency DeleteByMachineID(string MachineID) { ReturnMachineMtnFrequency returnMachineMtnFrequency = new ReturnMachineMtnFrequency(); 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_tMachineMtnFrequency_DeleteByMachineID"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@MachineID", SqlDbType.VarChar)).Value = MachineID; cmd.ExecuteNonQuery(); returnMachineMtnFrequency.Code = "00"; returnMachineMtnFrequency.Message = "Cập nhật dữ liệu thành công."; } } } catch (Exception ex) { returnMachineMtnFrequency.Code = "99"; returnMachineMtnFrequency.Message = "Lỗi xử lý dữ liệu: " + ex.ToString(); returnMachineMtnFrequency.Total = 0; returnMachineMtnFrequency.lstMachineMtnFrequency = null; mylog4net.Error("", ex); } return(returnMachineMtnFrequency); }
public ReturnMachineMtnFrequency GetbyMachineID(string MachineID) { List <MachineMtnFrequency> lstMachineMtnFrequency = null; MachineMtnFrequency machineMtnFrequency = null; ReturnMachineMtnFrequency returnMachineMtnFrequency = new ReturnMachineMtnFrequency(); try { using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection()) { using (SqlCommand cmd = new SqlCommand("", sqlConnection)) { //cmd.Connection = _sqlConnection; cmd.CommandText = "sp_tMachineMtnFrequency_SelectByMachineID"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@MachineID", SqlDbType.VarChar)).Value = MachineID; using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd, sqlConnection)) { if (sqlDr.HasRows) { lstMachineMtnFrequency = new List <MachineMtnFrequency>(); while (sqlDr.Read()) { machineMtnFrequency = new MachineMtnFrequency(); machineMtnFrequency.ID = Convert.ToInt16(sqlDr["ID"].ToString()); machineMtnFrequency.MachineID = sqlDr["MachineID"].ToString(); machineMtnFrequency.FrequencyID = Convert.ToInt16(sqlDr["FrequencyID"].ToString()); lstMachineMtnFrequency.Add(machineMtnFrequency); } returnMachineMtnFrequency.Code = "00"; returnMachineMtnFrequency.Message = "Lấy dữ liệu thành công."; returnMachineMtnFrequency.lstMachineMtnFrequency = lstMachineMtnFrequency; } else { returnMachineMtnFrequency.Code = "01"; returnMachineMtnFrequency.Message = "Không tồn tại bản ghi nào."; returnMachineMtnFrequency.Total = 0; returnMachineMtnFrequency.lstMachineMtnFrequency = null; } } } } } catch (Exception ex) { returnMachineMtnFrequency.Code = "99"; returnMachineMtnFrequency.Message = "Lỗi xử lý dữ liệu: " + ex.ToString(); returnMachineMtnFrequency.Total = 0; returnMachineMtnFrequency.lstMachineMtnFrequency = null; mylog4net.Error("", ex); } return(returnMachineMtnFrequency); }