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); }