public ReturnMachineMtnDetail CountbyMachineMtnContentID(int machineMtnContentID) { //List<int> lstint = null; ReturnMachineMtnDetail returnMachineMtnDetail = new ReturnMachineMtnDetail(); try { using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection()) { using (SqlCommand cmd = new SqlCommand("", sqlConnection)) { cmd.CommandText = "sp_tMachineMtnDetail_CountbyMachineMtnContentID"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@MachineMtnContentID", SqlDbType.Int)).Value = machineMtnContentID; using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd)) { if (sqlDr.HasRows) { //lstint = new List<int>(); while (sqlDr.Read()) { returnMachineMtnDetail.Total = Convert.ToInt16(sqlDr[0].ToString()); } returnMachineMtnDetail.Code = "00"; returnMachineMtnDetail.Message = "Lấy dữ liệu thành công."; returnMachineMtnDetail.lstMachineMtnDetail = null; } else { returnMachineMtnDetail.Code = "01"; returnMachineMtnDetail.Message = "Không tồn tại bản ghi nào."; returnMachineMtnDetail.Total = 0; returnMachineMtnDetail.lstMachineMtnDetail = null; } } } } } catch (Exception ex) { returnMachineMtnDetail.Code = "99"; returnMachineMtnDetail.Message = "Lỗi xử lý dữ liệu: " + ex.ToString(); returnMachineMtnDetail.Total = 0; returnMachineMtnDetail.lstMachineMtnDetail = null; mylog4net.Error("public ReturnMachineMtnDetail CountbyCondition(int machineMtnContentID) :", ex); } return(returnMachineMtnDetail); }
public ReturnMachineMtnDetail Insert(MachineMtnDetail machineMtnDetail) { ReturnMachineMtnDetail returnMachineMtnDetail = new ReturnMachineMtnDetail(); try { using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection()) { using (SqlCommand cmd = new SqlCommand("", sqlConnection)) { cmd.CommandText = "sp_tMachineMtnDetail_InsertUpdate"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = machineMtnDetail.ID; cmd.Parameters.Add(new SqlParameter("@MachineMtnID", SqlDbType.Int)).Value = machineMtnDetail.MachineMtnID; cmd.Parameters.Add(new SqlParameter("@MachineMtnContentID", SqlDbType.Int)).Value = machineMtnDetail.MachineMtnContentID; cmd.Parameters.Add(new SqlParameter("@Result", SqlDbType.VarChar)).Value = machineMtnDetail.Result; cmd.Parameters.Add(new SqlParameter("@ResultContents", SqlDbType.NVarChar)).Value = machineMtnDetail.ResultContents; cmd.Parameters.Add(new SqlParameter("@ContentMtn", SqlDbType.NVarChar)).Value = machineMtnDetail.ContentMtn; cmd.Parameters.Add(new SqlParameter("@ToolMtn", SqlDbType.NVarChar)).Value = machineMtnDetail.ToolMtn; cmd.Parameters.Add(new SqlParameter("@MethodMtn", SqlDbType.NVarChar)).Value = machineMtnDetail.MethodMtn; cmd.Parameters.Add(new SqlParameter("@Standard", SqlDbType.NVarChar)).Value = machineMtnDetail.Standard; cmd.Parameters.Add(new SqlParameter("@Min", SqlDbType.NVarChar)).Value = machineMtnDetail.Min; cmd.Parameters.Add(new SqlParameter("@Max", SqlDbType.NVarChar)).Value = machineMtnDetail.Max; cmd.Parameters.Add(new SqlParameter("@ActualValue", SqlDbType.NVarChar)).Value = machineMtnDetail.ActualValue; cmd.ExecuteNonQuery(); returnMachineMtnDetail.Code = "00"; returnMachineMtnDetail.Message = "Cập nhật dữ liệu thành công."; } } } catch (Exception ex) { returnMachineMtnDetail.Code = "99"; returnMachineMtnDetail.Message = "Lỗi xử lý dữ liệu: " + ex.ToString(); returnMachineMtnDetail.Total = 0; returnMachineMtnDetail.lstMachineMtnDetail = null; mylog4net.Error("", ex); } return(returnMachineMtnDetail); }