public ReturnMachine DeleteByID(string _ID)
{
ReturnMachine returnMachine = new ReturnMachine();
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_tMachineList_DeleteByID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@MachineID", SqlDbType.VarChar)).Value = _ID;
//cmd.Parameters.Add("@RETURN_CODE", SqlDbType.Int).Direction = ParameterDirection.Output;
//int RETURN_CODE = Convert.ToInt32(cmd.Parameters["@RETURN_CODE"].Value);
cmd.ExecuteNonQuery();
returnMachine.Code = "00";
returnMachine.Message = "Cập nhật dữ liệu thành công.";
}
}
}
catch (Exception ex)
{
returnMachine.Code = "99";
returnMachine.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnMachine.Total = 0;
returnMachine.lstMachine = null;
mylog4net.Error("", ex);
}
return(returnMachine);
}
public ReturnMachine CountbyLineID(string LineID)
{
List <Machine> lstMachine = null;
Machine machine = null;
ReturnMachine returnMachine = new ReturnMachine();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
//cmd.Connection = _sqlConnection;
cmd.CommandText = "sp_tMachineList_CountbyLineID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@LineID", SqlDbType.VarChar)).Value = LineID.Trim();
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd, sqlConnection))
{
if (sqlDr.HasRows)
{
while (sqlDr.Read())
{
returnMachine.lstMachine = null;
returnMachine.Total = Convert.ToInt16(sqlDr[0].ToString());
}
returnMachine.Code = "00";
returnMachine.Message = "Lấy dữ liệu thành công.";
//}
}
else
{
returnMachine.Code = "01";
returnMachine.Message = "Không tồn tại bản ghi nào.";
returnMachine.Total = 0;
returnMachine.lstMachine = null;
}
}
}
}
}
catch (Exception ex)
{
returnMachine.Code = "99";
returnMachine.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnMachine.Total = 0;
returnMachine.lstMachine = null;
mylog4net.Error("", ex);
}
return(returnMachine);
}
public ReturnMachine Insert(Machine machine)
{
ReturnMachine returnMachine = new ReturnMachine();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tMachineList_InsertUpdate";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@MachineID", SqlDbType.VarChar)).Value = machine.MachineID;
cmd.Parameters.Add(new SqlParameter("@MachineName", SqlDbType.NVarChar)).Value = machine.MachineName;
cmd.Parameters.Add(new SqlParameter("@MachineNumber", SqlDbType.NVarChar)).Value = machine.MachineNumber;
cmd.Parameters.Add(new SqlParameter("@Area", SqlDbType.VarChar)).Value = machine.Area;
cmd.Parameters.Add(new SqlParameter("@Section", SqlDbType.VarChar)).Value = machine.Section == null ? "" : machine.Section;
cmd.Parameters.Add(new SqlParameter("@ReceiveDate", SqlDbType.DateTime)).Value = machine.ReceiveDate;
cmd.Parameters.Add(new SqlParameter("@Maker", SqlDbType.VarChar)).Value = machine.Maker == null ? "" : machine.Maker;
cmd.Parameters.Add(new SqlParameter("@SerialNumber", SqlDbType.VarChar)).Value = machine.SerialNumber == null ? "" : machine.SerialNumber;
cmd.Parameters.Add(new SqlParameter("@LineID", SqlDbType.VarChar)).Value = machine.LineID;
cmd.Parameters.Add(new SqlParameter("@MachineTypeID", SqlDbType.Int)).Value = machine.MachineTypeID;
cmd.ExecuteNonQuery();
returnMachine.Code = "00";
returnMachine.Message = "Cập nhật dữ liệu thành công.";
}
}
}
catch (Exception ex)
{
returnMachine.Code = "99";
returnMachine.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnMachine.Total = 0;
returnMachine.lstMachine = null;
mylog4net.Error("", ex);
}
return(returnMachine);
}
//public ReturnMachineMtn DeleteMachineMtnDetailByID(int _ID)
//{
// //ReturnMachineMtn returnMachineMtn = new ReturnMachineMtn();
// //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_tMachineMtn_DeleteByID";
// // cmd.CommandType = CommandType.StoredProcedure;
// // cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = _ID;
// // //cmd.Parameters.Add("@RETURN_CODE", SqlDbType.Int).Direction = ParameterDirection.Output;
// // //int RETURN_CODE = Convert.ToInt32(cmd.Parameters["@RETURN_CODE"].Value);
// // cmd.ExecuteNonQuery();
// // returnMachineMtn.Code = "00";
// // returnMachineMtn.Message = "Cập nhật dữ liệu thành công.";
// // }
// // }
// //}
// //catch (Exception ex)
// //{
// // returnMachineMtn.Code = "99";
// // returnMachineMtn.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
// // returnMachineMtn.Total = 0;
// // returnMachineMtn.lstMachineMtn = null;
// // mylog4net.Error("", ex);
// //}
// //return returnMachineMtn;
//}
public ReturnMachineMtn GetMachineMtnbyID(int ID)
{
List <MachineMtn> lstMachineMtn = null;
MachineMtn machineMtn = null;
ReturnMachineMtn returnMachineMtn = new ReturnMachineMtn();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tMachineMtn_SelectByID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = ID;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd))
{
//if (float.Parse(cmd.Parameters["P_RETURN_CODE"].Value.ToString()) > 0)
//{
if (sqlDr.HasRows)
{
lstMachineMtn = new List <MachineMtn>();
while (sqlDr.Read())
{
machineMtn = new MachineMtn();
machineMtn.ID = Convert.ToInt16(sqlDr["ID"].ToString());
machineMtn.MachineID = sqlDr["MachineID"].ToString();
//get MachineName.
ReturnMachine returnMachine = (new MachineDB()).GetbyID(machineMtn.MachineID);
if (returnMachine.Code == "00")
{
machineMtn.MachineName = returnMachine.lstMachine[0].MachineName;
}
//get OperatorName.
int _operatorID = 0;
ReturnUser returnUser;
if (Int32.TryParse(sqlDr["OperatorID"].ToString(), out _operatorID))
{
returnUser = (new UserDB()).GetbyID(_operatorID);
if (returnUser.Code == "00")
{
machineMtn.OperatorName = returnUser.lstUser[0].UserName;
}
}
machineMtn.Shift = Convert.ToInt16(sqlDr["Shift"].ToString());
machineMtn.MaintenanceDate = Convert.ToDateTime(sqlDr["MaintenanceDate"].ToString());
if (!String.IsNullOrEmpty(sqlDr["FrequencyID"].ToString()))
{
machineMtn.FrequencyID = Convert.ToInt16(sqlDr["FrequencyID"].ToString());
}
machineMtn.Result = sqlDr["Result"].ToString();
machineMtn.ResultContents = sqlDr["ResultContents"].ToString();
if (!String.IsNullOrEmpty(sqlDr["Month"].ToString()))
{
machineMtn.Month = Convert.ToInt16(sqlDr["Month"].ToString());
}
if (!String.IsNullOrEmpty(sqlDr["Year"].ToString()))
{
machineMtn.Year = Convert.ToInt16(sqlDr["Year"].ToString());
}
if (!String.IsNullOrEmpty(sqlDr["Week"].ToString()))
{
machineMtn.Week = Convert.ToInt16(sqlDr["Week"].ToString());
}
if (sqlDr["CheckerID"].ToString() != "")
{
machineMtn.CheckerID = Convert.ToInt16(sqlDr["CheckerID"].ToString());
//get name.
int _CheckerID = 0;
ReturnUser returnChecker;
if (Int32.TryParse(sqlDr["CheckerID"].ToString(), out _operatorID))
{
returnChecker = (new UserDB()).GetbyID(_CheckerID);
if (returnChecker.Code == "00")
{
machineMtn.CheckerName = returnChecker.lstUser[0].UserName;
}
}
}
if (sqlDr["CheckerResult"].ToString() != "")
{
machineMtn.CheckerResult = sqlDr["CheckerResult"].ToString();
}
lstMachineMtn.Add(machineMtn);
}
returnMachineMtn.Code = "00";
returnMachineMtn.Message = "Lấy dữ liệu thành công.";
returnMachineMtn.lstMachineMtn = lstMachineMtn;
returnMachineMtn.UserID = MyShareInfo.ID;
returnMachineMtn.UserName = MyShareInfo.UserName;
}
else
{
returnMachineMtn.Code = "01";
returnMachineMtn.Message = "Không tồn tại bản ghi nào.";
returnMachineMtn.Total = 0;
returnMachineMtn.lstMachineMtn = null;
returnMachineMtn.UserID = MyShareInfo.ID;
returnMachineMtn.UserName = MyShareInfo.UserName;
}
}
}
}
}
catch (Exception ex)
{
returnMachineMtn.Code = "99";
returnMachineMtn.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnMachineMtn.Total = 0;
returnMachineMtn.lstMachineMtn = null;
mylog4net.Error("", ex);
}
return(returnMachineMtn);
}
public ReturnMachine GetbyID(string MachineID)
{
List <Machine> lstMachine = null;
Machine machine = null;
ReturnMachine returnMachine = new ReturnMachine();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
//cmd.Connection = _sqlConnection;
cmd.CommandText = "sp_tMachineList_SelectByID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@MachineID", SqlDbType.VarChar)).Value = MachineID;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd, sqlConnection))
{
if (sqlDr.HasRows)
{
lstMachine = new List <Machine>();
while (sqlDr.Read())
{
machine = new Machine();
machine.MachineID = sqlDr["MachineID"].ToString();
machine.MachineName = sqlDr["MachineName"].ToString();
machine.MachineNumber = sqlDr["MachineNumber"].ToString();
machine.Area = sqlDr["Area"].ToString();
machine.Section = sqlDr["Section"].ToString();
machine.ReceiveDate = DateTime.Parse(sqlDr["ReceiveDate"].ToString());
machine.Maker = sqlDr["Maker"].ToString();
machine.SerialNumber = sqlDr["SerialNumber"].ToString();
machine.LineID = sqlDr["LineID"].ToString();
machine.MachineTypeID = Int32.Parse(sqlDr["MachineTypeID"].ToString());
machine.MachineTypeName = sqlDr["MachineTypeName"].ToString();
lstMachine.Add(machine);
}
returnMachine.Code = "00";
returnMachine.Message = "Lấy dữ liệu thành công.";
returnMachine.lstMachine = lstMachine;
returnMachine.Total = lstMachine.Count;
}
else
{
returnMachine.Code = "01";
returnMachine.Message = "Không tồn tại bản ghi nào.";
returnMachine.Total = 0;
returnMachine.lstMachine = null;
}
}
}
}
}
catch (Exception ex)
{
returnMachine.Code = "99";
returnMachine.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnMachine.Total = 0;
returnMachine.lstMachine = null;
mylog4net.Error("", ex);
}
return(returnMachine);
}
public ReturnMachine MachineAll()
{
List <Machine> lstMachine = null;
Machine machine = null;
ReturnMachine returnMachine = new ReturnMachine();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tMachineList_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)
{
lstMachine = new List <Machine>();
while (sqlDr.Read())
{
machine = new Machine();
machine.MachineID = sqlDr["MachineID"].ToString();
machine.MachineName = sqlDr["MachineName"].ToString();
machine.MachineNumber = sqlDr["MachineNumber"].ToString();
machine.Area = sqlDr["Area"].ToString();
machine.Section = sqlDr["Section"].ToString();
machine.ReceiveDate = DateTime.Parse(sqlDr["ReceiveDate"].ToString());
machine.Maker = sqlDr["Maker"].ToString();
machine.SerialNumber = sqlDr["SerialNumber"].ToString();
machine.LineID = sqlDr["LineID"].ToString();
machine.MachineTypeID = Int32.Parse(sqlDr["MachineTypeID"].ToString());
machine.MachineTypeName = sqlDr["MachineTypeName"].ToString();
//machine.isActive = CalculateCommon.ConvertToBoolean(sqlDr["isActive"].ToString());
lstMachine.Add(machine);
}
returnMachine.Code = "00";
returnMachine.Message = "Lấy dữ liệu thành công.";
returnMachine.lstMachine = lstMachine;
}
else
{
returnMachine.Code = "01";
returnMachine.Message = "Không tồn tại bản ghi nào.";
returnMachine.Total = 0;
returnMachine.lstMachine = null;
}
}
}
}
}
catch (Exception ex)
{
returnMachine.Code = "99";
returnMachine.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnMachine.Total = 0;
returnMachine.lstMachine = null;
mylog4net.Error("", ex);
}
return(returnMachine);
}
