//public ReturnMachineMtnFrequency Insert(MachineMtnFrequency machineMtnFrequency) //{ // ReturnMachineMtnFrequency returnMachineMtnFrequency = new ReturnMachineMtnFrequency(); // try // { // using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection()) // { // using (SqlCommand cmd = new SqlCommand("", sqlConnection)) // { // cmd.CommandText = "sp_tMachineMtnFrequency_InsertUpdate"; // cmd.CommandType = CommandType.StoredProcedure; // cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = machineMtnFrequency.ID; // cmd.Parameters.Add(new SqlParameter("@MachineID", SqlDbType.VarChar)).Value = machineMtnFrequency.MachineID; // cmd.Parameters.Add(new SqlParameter("@FrequencyID", SqlDbType.SmallInt)).Value = machineMtnFrequency.FrequencyID; // 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; // } // return returnMachineMtnFrequency; //} public ReturnMachineMtnFrequency Insert(MachineMtnFrequency machineMtnFrequency) { ReturnMachineMtnFrequency returnMachineMtnFrequency = new ReturnMachineMtnFrequency(); try { using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection()) { using (SqlCommand cmd = new SqlCommand("", sqlConnection)) { cmd.CommandText = "sp_tMachineMtnFrequency_InsertUpdate"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = machineMtnFrequency.ID; cmd.Parameters.Add(new SqlParameter("@MachineID", SqlDbType.VarChar)).Value = machineMtnFrequency.MachineID; cmd.Parameters.Add(new SqlParameter("@FrequencyID", SqlDbType.SmallInt)).Value = machineMtnFrequency.FrequencyID; 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); }