public ReturnFPBCheckingItem DeleteByMachineID(string MachineID, string FrequencyID)
{
ReturnFPBCheckingItem returnFPBCheckingItem = new ReturnFPBCheckingItem();
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_FPBCheckingItem_DeleteByMachineID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@MachineID", SqlDbType.VarChar)).Value = MachineID;
cmd.Parameters.Add(new SqlParameter("@FrequencyID", SqlDbType.Int)).Value = int.Parse(FrequencyID);
cmd.ExecuteNonQuery();
returnFPBCheckingItem.Code = "00";
returnFPBCheckingItem.Message = "Cập nhật dữ liệu thành công.";
}
}
}
catch (Exception ex)
{
returnFPBCheckingItem.Code = "99";
returnFPBCheckingItem.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnFPBCheckingItem.Total = 0;
returnFPBCheckingItem.LstFPBCheckingItem = null;
mylog4net.Error("", ex);
}
return(returnFPBCheckingItem);
}
public ReturnFPBCheckingItem Insert(FPBCheckingItem FPBCheckingItem)
{
ReturnFPBCheckingItem returnFPBCheckingItem = new ReturnFPBCheckingItem();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_FPBCheckingItem_InsertUpdate";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@IDFPBCheckingItem", SqlDbType.Int)).Value = FPBCheckingItem.IDFPBCheckingItem;
cmd.Parameters.Add(new SqlParameter("@MachineID", SqlDbType.VarChar)).Value = FPBCheckingItem.MachineID;
cmd.Parameters.Add(new SqlParameter("@CheckingItemName", SqlDbType.NVarChar)).Value = FPBCheckingItem.CheckingItemName;
cmd.Parameters.Add(new SqlParameter("@FrequencyID", SqlDbType.Int)).Value = FPBCheckingItem.FrequencyID;
cmd.Parameters.Add(new SqlParameter("@isActive", SqlDbType.Bit)).Value = 1;
cmd.ExecuteNonQuery();
returnFPBCheckingItem.Code = "00";
returnFPBCheckingItem.Message = "Cập nhật dữ liệu thành công.";
}
}
}
catch (Exception ex)
{
returnFPBCheckingItem.Code = "99";
returnFPBCheckingItem.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnFPBCheckingItem.Total = 0;
returnFPBCheckingItem.LstFPBCheckingItem = null;
mylog4net.Error("", ex);
}
return(returnFPBCheckingItem);
}
public ReturnFPBCheckingItem GetbyMachineID(string MachineID, int FrequencyID)
{
List <FPBCheckingItem> lstFPBCheckingItem = null;
FPBCheckingItem FPBCheckingItem = null;
ReturnFPBCheckingItem returnFPBCheckingItem = new ReturnFPBCheckingItem();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
//cmd.Connection = _sqlConnection;
cmd.CommandText = "sp_FPBCheckingItem_SelectByMachineID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@MachineID", SqlDbType.VarChar)).Value = MachineID;
cmd.Parameters.Add(new SqlParameter("@FrequencyID", SqlDbType.Int)).Value = FrequencyID;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd, sqlConnection))
{
if (sqlDr.HasRows)
{
lstFPBCheckingItem = new List <FPBCheckingItem>();
while (sqlDr.Read())
{
FPBCheckingItem = new FPBCheckingItem();
FPBCheckingItem.IDFPBCheckingItem = int.Parse(sqlDr["IDFPBCheckingItem"].ToString());
FPBCheckingItem.MachineID = sqlDr["MachineID"].ToString();
FPBCheckingItem.CheckingItemName = sqlDr["CheckingItemName"].ToString();
FPBCheckingItem.FrequencyID = int.Parse(sqlDr["FrequencyID"].ToString());
FPBCheckingItem.isActive = SMCommon.ConvertToBoolean(sqlDr["isActive"].ToString());
lstFPBCheckingItem.Add(FPBCheckingItem);
}
returnFPBCheckingItem.Code = "00";
returnFPBCheckingItem.Message = "Lấy dữ liệu thành công.";
returnFPBCheckingItem.LstFPBCheckingItem = lstFPBCheckingItem;
}
else
{
returnFPBCheckingItem.Code = "01";
returnFPBCheckingItem.Message = "Không tồn tại bản ghi nào.";
returnFPBCheckingItem.Total = 0;
returnFPBCheckingItem.LstFPBCheckingItem = null;
}
}
}
}
}
catch (Exception ex)
{
returnFPBCheckingItem.Code = "99";
returnFPBCheckingItem.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnFPBCheckingItem.Total = 0;
returnFPBCheckingItem.LstFPBCheckingItem = null;
mylog4net.Error("", ex);
}
return(returnFPBCheckingItem);
}
public ReturnFPBCheckingItem ListAll()
{
List <FPBCheckingItem> lstFPBCheckingItem = null;
FPBCheckingItem FPBCheckingItem = null;
ReturnFPBCheckingItem returnFPBCheckingItem = new ReturnFPBCheckingItem();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_FPBCheckingItem_SelectAll";
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd))
{
//if (float.Parse(cmd.Parameters["P_RETURN_CODE"].Value.ToString()) > 0)
//{
if (sqlDr.HasRows)
{
lstFPBCheckingItem = new List <FPBCheckingItem>();
while (sqlDr.Read())
{
FPBCheckingItem = new FPBCheckingItem();
//FPBCheckingItem.IDFPBCheckingItem = int.Parse(sqlDr["IDFPBCheckingItem"].ToString());
FPBCheckingItem.MachineID = sqlDr["MachineID"].ToString();
//FPBCheckingItem.CheckingItemName = sqlDr["CheckingItemName"].ToString();
FPBCheckingItem.FrequencyID = int.Parse(sqlDr["FrequencyID"].ToString());
//FPBCheckingItem.isActive = SMCommon.ConvertToBoolean(sqlDr["isActive"].ToString());
lstFPBCheckingItem.Add(FPBCheckingItem);
}
returnFPBCheckingItem.Code = "00";
returnFPBCheckingItem.Message = "Lấy dữ liệu thành công.";
returnFPBCheckingItem.LstFPBCheckingItem = lstFPBCheckingItem;
}
else
{
returnFPBCheckingItem.Code = "01";
returnFPBCheckingItem.Message = "Không tồn tại bản ghi nào.";
returnFPBCheckingItem.Total = 0;
returnFPBCheckingItem.LstFPBCheckingItem = null;
}
}
}
}
}
catch (Exception ex)
{
returnFPBCheckingItem.Code = "99";
returnFPBCheckingItem.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnFPBCheckingItem.Total = 0;
returnFPBCheckingItem.LstFPBCheckingItem = null;
mylog4net.Error("", ex);
}
return(returnFPBCheckingItem);
}
