public ReturnMachineTypeFrequency Insert(MachineTypeFrequency machineTypeFrequency)
{
ReturnMachineTypeFrequency returnMachineTypeFrequency = new ReturnMachineTypeFrequency();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tMachineTypeFrequency_InsertUpdate";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = machineTypeFrequency.ID;
cmd.Parameters.Add(new SqlParameter("@MachineTypeID", SqlDbType.Int)).Value = machineTypeFrequency.MachineTypeID;
cmd.Parameters.Add(new SqlParameter("@FrequencyID", SqlDbType.SmallInt)).Value = machineTypeFrequency.FrequencyID;
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);
}
