public ReturnProgramPdtCtrlHistory Insert(ProgramPdtCtrlHistory p) { ReturnProgramPdtCtrlHistory returnProgramPdtCtrlHistory = new ReturnProgramPdtCtrlHistory(); try { using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection()) { using (SqlCommand cmd = new SqlCommand("", sqlConnection)) { cmd.CommandText = "sp_tProgramPdtCtrlHistory_InsertUpdate"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@ProgramName", SqlDbType.VarChar)).Value = p.ProgramName; cmd.Parameters.Add(new SqlParameter("@Parameter", SqlDbType.VarChar)).Value = p.Parameter; cmd.Parameters.Add(new SqlParameter("@ControlItem", SqlDbType.VarChar)).Value = p.ControlItem; cmd.Parameters.Add(new SqlParameter("@ColumnName", SqlDbType.VarChar)).Value = p.ColumnName; cmd.Parameters.Add(new SqlParameter("@LowerLimit", SqlDbType.VarChar)).Value = p.LowerLimit; cmd.Parameters.Add(new SqlParameter("@Unit", SqlDbType.VarChar)).Value = p.Unit; cmd.Parameters.Add(new SqlParameter("@UpperLimit", SqlDbType.VarChar)).Value = p.UpperLimit; cmd.Parameters.Add(new SqlParameter("@HistoryOperatorID", SqlDbType.VarChar)).Value = p.HistoryOperatorID; cmd.Parameters.Add(new SqlParameter("@SpecDisplay", SqlDbType.VarChar)).Value = p.SpecDisplay; cmd.Parameters.Add(new SqlParameter("@ItemName", SqlDbType.VarChar)).Value = p.ItemName; //int RETURN_CODE = Convert.ToInt32(cmd.Parameters["@RETURN_CODE"].Value); cmd.ExecuteNonQuery(); returnProgramPdtCtrlHistory.Code = "00"; returnProgramPdtCtrlHistory.Message = "Cập nhật dữ liệu thành công."; } } } catch (Exception ex) { returnProgramPdtCtrlHistory.Code = "99"; returnProgramPdtCtrlHistory.Message = "Lỗi xử lý dữ liệu: " + ex.ToString(); returnProgramPdtCtrlHistory.Total = 0; returnProgramPdtCtrlHistory.lstProgramPdtCtrlHistory = null; mylog4net.Error("", ex); } return(returnProgramPdtCtrlHistory); }
public ReturnProgramPdtCtrlHistory DeleteByKey(ProgramPdtCtrlHistory p) { ReturnProgramPdtCtrlHistory returnProgramPdtCtrlHistory = new ReturnProgramPdtCtrlHistory(); 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_tProgramPdtCtrlHistory_DeleteByKey"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@ProgramName", SqlDbType.VarChar)).Value = p.ProgramName; cmd.Parameters.Add(new SqlParameter("@Parameter", SqlDbType.VarChar)).Value = p.Parameter; cmd.Parameters.Add(new SqlParameter("@ControlItem", SqlDbType.VarChar)).Value = p.ControlItem; //cmd.Parameters.Add("@RETURN_CODE", SqlDbType.Int).Direction = ParameterDirection.Output; //int RETURN_CODE = Convert.ToInt32(cmd.Parameters["@RETURN_CODE"].Value); cmd.ExecuteNonQuery(); returnProgramPdtCtrlHistory.Code = "00"; returnProgramPdtCtrlHistory.Message = "Cập nhật dữ liệu thành công."; } } } catch (Exception ex) { returnProgramPdtCtrlHistory.Code = "99"; returnProgramPdtCtrlHistory.Message = "Lỗi xử lý dữ liệu: " + ex.ToString(); returnProgramPdtCtrlHistory.Total = 0; returnProgramPdtCtrlHistory.lstProgramPdtCtrlHistory = null; mylog4net.Error("", ex); } return(returnProgramPdtCtrlHistory); }
//public ReturnProgramPdtCtrlHistory SearchProgramPdtCtrlHistory(ReturnProgramPdtCtrlHistory searchProgramPdtCtrlHistory, int pageSize) //{ // List<ProgramPdtCtrlHistory> lstProgramPdtCtrlHistory = null; // ProgramPdtCtrlHistory programPdtCtrlHistory = null; // ReturnProgramPdtCtrlHistory returnProgramPdtCtrlHistory = new ReturnProgramPdtCtrlHistory(); // try // { // using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection()) // { // using (SqlCommand cmd = new SqlCommand("", sqlConnection)) // { // cmd.CommandText = "sp_tProgramPdtCtrlHistory_Search"; // cmd.CommandType = CommandType.StoredProcedure; // cmd.Parameters.Add(new SqlParameter("@ProgramName", SqlDbType.VarChar)).Value = searchProgramPdtCtrlHistory.aProgramPdtCtrlHistory.ProgramName; // cmd.Parameters.Add(new SqlParameter("@Parameter", SqlDbType.NVarChar)).Value = searchProgramPdtCtrlHistory.aProgramPdtCtrlHistory.Parameter; // cmd.Parameters.Add(new SqlParameter("@ControlItem", SqlDbType.NVarChar)).Value = searchProgramPdtCtrlHistory.aProgramPdtCtrlHistory.ControlItem; // cmd.Parameters.Add(new SqlParameter("@pageNumber", SqlDbType.Int)).Value = searchProgramPdtCtrlHistory.PageNumber; // cmd.Parameters.Add(new SqlParameter("@pageSize", SqlDbType.Int)).Value = pageSize; // cmd.Parameters.Add("@totalRow", SqlDbType.Int).Direction = ParameterDirection.Output; // using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd)) // { // if (sqlDr.HasRows) // { // lstProgramPdtCtrlHistory = new List<ProgramPdtCtrlHistory>(); // while (sqlDr.Read()) // { // programPdtCtrlHistory = new ProgramPdtCtrlHistory(); // programPdtCtrlHistory.ProgramName = sqlDr["ProgramName"].ToString(); // programPdtCtrlHistory.Parameter = sqlDr["Parameter"].ToString(); // programPdtCtrlHistory.ControlItem = sqlDr["ControlItem"].ToString(); // programPdtCtrlHistory.SpecDisplay = sqlDr["SpecDisplay"].ToString(); // programPdtCtrlHistory.Unit = sqlDr["Unit"].ToString(); // programPdtCtrlHistory.UpperLimit = sqlDr["UpperLimit"].ToString(); // programPdtCtrlHistory.LowerLimit = sqlDr["LowerLimit"].ToString(); // programPdtCtrlHistory.ColumnName = sqlDr["ColumnName"].ToString(); // programPdtCtrlHistory.OperatorID = Convert.ToInt32(sqlDr["OperatorID"].ToString()); // programPdtCtrlHistory.HistoryOperatorID = Convert.ToInt32(sqlDr["HistoryOperatorID"].ToString()); // programPdtCtrlHistory.ItemName = sqlDr["ItemName"].ToString(); // lstProgramPdtCtrlHistory.Add(programPdtCtrlHistory); // } // returnProgramPdtCtrlHistory.Code = "00"; // returnProgramPdtCtrlHistory.Message = "Lấy dữ liệu thành công."; // returnProgramPdtCtrlHistory.lstProgramPdtCtrlHistory = lstProgramPdtCtrlHistory; // } // else // { // returnProgramPdtCtrlHistory.Code = "01"; // returnProgramPdtCtrlHistory.Message = "Không tồn tại bản ghi nào."; // returnProgramPdtCtrlHistory.Total = 0; // returnProgramPdtCtrlHistory.lstProgramPdtCtrlHistory = null; // } // } // //get return Totalpage value. // if (returnProgramPdtCtrlHistory.Code == "00") // returnProgramPdtCtrlHistory.Total = Convert.ToInt32(cmd.Parameters["@totalRow"].Value); // } // } // } // catch (Exception ex) // { // returnProgramPdtCtrlHistory.Code = "99"; // returnProgramPdtCtrlHistory.Message = "Lỗi xử lý dữ liệu: " + ex.ToString(); // returnProgramPdtCtrlHistory.Total = 0; // returnProgramPdtCtrlHistory.lstProgramPdtCtrlHistory = null; // mylog4net.Error("", ex); // } // return returnProgramPdtCtrlHistory; //} public ReturnProgramPdtCtrlHistory SearchProgramPdtCtrlHistory(ProgramPdtCtrlHistory searchProgramPdtCtrlHistory, int pageNumber, int pageSize) { List <ProgramPdtCtrlHistory> lstProgramPdtCtrlHistory = null; ProgramPdtCtrlHistory programPdtCtrlHistory = null; ReturnProgramPdtCtrlHistory returnProgramPdtCtrlHistory = new ReturnProgramPdtCtrlHistory(); try { using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection()) { using (SqlCommand cmd = new SqlCommand("", sqlConnection)) { cmd.CommandText = "sp_tProgramPdtCtrlHistory_Search"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@ProgramName", SqlDbType.VarChar)).Value = searchProgramPdtCtrlHistory.ProgramName; cmd.Parameters.Add(new SqlParameter("@Part", SqlDbType.NVarChar)).Value = searchProgramPdtCtrlHistory.Part; cmd.Parameters.Add(new SqlParameter("@ControlItem", SqlDbType.NVarChar)).Value = searchProgramPdtCtrlHistory.ControlItem; cmd.Parameters.Add(new SqlParameter("@pageNumber", SqlDbType.Int)).Value = pageNumber; cmd.Parameters.Add(new SqlParameter("@pageSize", SqlDbType.Int)).Value = pageSize; cmd.Parameters.Add("@totalRow", SqlDbType.Int).Direction = ParameterDirection.Output; using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd)) { if (sqlDr.HasRows) { lstProgramPdtCtrlHistory = new List <ProgramPdtCtrlHistory>(); while (sqlDr.Read()) { programPdtCtrlHistory = new ProgramPdtCtrlHistory(); programPdtCtrlHistory.ProgramName = sqlDr["ProgramName"].ToString(); programPdtCtrlHistory.Parameter = sqlDr["Parameter"].ToString(); programPdtCtrlHistory.ControlItem = sqlDr["ControlItem"].ToString(); programPdtCtrlHistory.SpecDisplay = sqlDr["SpecDisplay"].ToString(); programPdtCtrlHistory.Unit = sqlDr["Unit"].ToString(); programPdtCtrlHistory.UpperLimit = sqlDr["UpperLimit"].ToString(); programPdtCtrlHistory.LowerLimit = sqlDr["LowerLimit"].ToString(); programPdtCtrlHistory.ColumnName = sqlDr["ColumnName"].ToString(); if (!String.IsNullOrEmpty(sqlDr["HistoryOperatorID"].ToString())) { programPdtCtrlHistory.HistoryOperatorID = Int32.Parse(sqlDr["HistoryOperatorID"].ToString());//Convert.ToInt32(sqlDr["HistoryOperatorID"].ToString()); programPdtCtrlHistory.HistoryOperatorName = (new UserDB()).getUserNameByID(Convert.ToInt32(programPdtCtrlHistory.HistoryOperatorID)); } if (!String.IsNullOrEmpty(sqlDr["OperatorID"].ToString())) { programPdtCtrlHistory.OperatorID = Int32.Parse(sqlDr["OperatorID"].ToString());//Convert.ToInt32(sqlDr["OperatorID"].ToString()); programPdtCtrlHistory.OperatorName = (new UserDB()).getUserNameByID(Convert.ToInt32(programPdtCtrlHistory.OperatorID)); } programPdtCtrlHistory.CreatedDate = DateTime.Parse(sqlDr["CreatedDate"].ToString()); programPdtCtrlHistory.HistoryDate = DateTime.Parse(sqlDr["HistoryDate"].ToString()); programPdtCtrlHistory.StatusCRUD = sqlDr["StatusCRUD"].ToString(); lstProgramPdtCtrlHistory.Add(programPdtCtrlHistory); } returnProgramPdtCtrlHistory.Code = "00"; returnProgramPdtCtrlHistory.Message = "Lấy dữ liệu thành công."; returnProgramPdtCtrlHistory.lstProgramPdtCtrlHistory = lstProgramPdtCtrlHistory; } else { returnProgramPdtCtrlHistory.Code = "01"; returnProgramPdtCtrlHistory.Message = "Không tồn tại bản ghi nào."; returnProgramPdtCtrlHistory.Total = 0; returnProgramPdtCtrlHistory.lstProgramPdtCtrlHistory = null; } } //get return Totalpage value. if (returnProgramPdtCtrlHistory.Code == "00") { returnProgramPdtCtrlHistory.Total = Convert.ToInt32(cmd.Parameters["@totalRow"].Value); } } } } catch (Exception ex) { returnProgramPdtCtrlHistory.Code = "99"; returnProgramPdtCtrlHistory.Message = "Lỗi xử lý dữ liệu: " + ex.ToString(); returnProgramPdtCtrlHistory.Total = 0; returnProgramPdtCtrlHistory.lstProgramPdtCtrlHistory = null; mylog4net.Error("", ex); } return(returnProgramPdtCtrlHistory); }
public ReturnProgramPdtCtrlHistory GetbyKey(ProgramPdtCtrlHistory p) { List <ProgramPdtCtrlHistory> lstProgramPdtCtrlHistory = null; ProgramPdtCtrlHistory programPdtCtrlHistory = null; ReturnProgramPdtCtrlHistory returnProgramPdtCtrlHistory = new ReturnProgramPdtCtrlHistory(); try { using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection()) { using (SqlCommand cmd = new SqlCommand("", sqlConnection)) { //cmd.Connection = _sqlConnection; cmd.CommandText = "sp_tProgramPdtCtrlHistory_SelectByID"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@ProgramName", SqlDbType.VarChar)).Value = p.ProgramName; cmd.Parameters.Add(new SqlParameter("@Parameter", SqlDbType.NVarChar)).Value = p.Parameter; cmd.Parameters.Add(new SqlParameter("@ControlItem", SqlDbType.NVarChar)).Value = p.ControlItem; using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd, sqlConnection)) { if (sqlDr.HasRows) { lstProgramPdtCtrlHistory = new List <ProgramPdtCtrlHistory>(); while (sqlDr.Read()) { programPdtCtrlHistory = new ProgramPdtCtrlHistory(); programPdtCtrlHistory.ProgramName = sqlDr["ProgramName"].ToString(); programPdtCtrlHistory.Parameter = sqlDr["Parameter"].ToString(); programPdtCtrlHistory.ControlItem = sqlDr["ControlItem"].ToString(); programPdtCtrlHistory.ColumnName = sqlDr["ColumnName"].ToString(); programPdtCtrlHistory.Unit = sqlDr["Unit"].ToString(); programPdtCtrlHistory.SpecDisplay = sqlDr["SpecDisplay"].ToString(); programPdtCtrlHistory.LowerLimit = sqlDr["LowerLimit"].ToString(); programPdtCtrlHistory.UpperLimit = sqlDr["UpperLimit"].ToString(); if (!String.IsNullOrEmpty(sqlDr["HistoryOperatorID"].ToString())) { programPdtCtrlHistory.HistoryOperatorID = Int32.Parse(sqlDr["HistoryOperatorID"].ToString());//Convert.ToInt32(sqlDr["HistoryOperatorID"].ToString()); programPdtCtrlHistory.HistoryOperatorName = (new UserDB()).getUserNameByID(Convert.ToInt32(programPdtCtrlHistory.HistoryOperatorID)); } if (!String.IsNullOrEmpty(sqlDr["OperatorID"].ToString())) { programPdtCtrlHistory.OperatorID = Int32.Parse(sqlDr["OperatorID"].ToString());//Convert.ToInt32(sqlDr["OperatorID"].ToString()); programPdtCtrlHistory.OperatorName = (new UserDB()).getUserNameByID(Convert.ToInt32(programPdtCtrlHistory.OperatorID)); } programPdtCtrlHistory.ItemName = sqlDr["ItemName"].ToString(); lstProgramPdtCtrlHistory.Add(programPdtCtrlHistory); } returnProgramPdtCtrlHistory.Code = "00"; returnProgramPdtCtrlHistory.Message = "Lấy dữ liệu thành công."; returnProgramPdtCtrlHistory.lstProgramPdtCtrlHistory = lstProgramPdtCtrlHistory; returnProgramPdtCtrlHistory.Total = lstProgramPdtCtrlHistory.Count; //} } else { returnProgramPdtCtrlHistory.Code = "01"; returnProgramPdtCtrlHistory.Message = "Không tồn tại bản ghi nào."; returnProgramPdtCtrlHistory.Total = 0; returnProgramPdtCtrlHistory.lstProgramPdtCtrlHistory = null; } } } } } catch (Exception ex) { returnProgramPdtCtrlHistory.Code = "99"; returnProgramPdtCtrlHistory.Message = "Lỗi xử lý dữ liệu: " + ex.ToString(); returnProgramPdtCtrlHistory.Total = 0; returnProgramPdtCtrlHistory.lstProgramPdtCtrlHistory = null; mylog4net.Error("", ex); } return(returnProgramPdtCtrlHistory); }