public ReturnConditionSetting DeleteByID(int _ID)
        {
            ReturnConditionSetting returnConditionSetting = new ReturnConditionSetting();

            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_tProductionControlList_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();
                        returnConditionSetting.Code    = "00";
                        returnConditionSetting.Message = "Cập nhật dữ liệu thành công.";
                    }
                }
            }
            catch (Exception ex)
            {
                returnConditionSetting.Code                = "99";
                returnConditionSetting.Message             = "Lỗi xử lý dữ liệu: " + ex.ToString();
                returnConditionSetting.Total               = 0;
                returnConditionSetting.lstConditionSetting = null;
                mylog4net.Error("", ex);
            }
            return(returnConditionSetting);
        }
        public ReturnConditionSetting Insert(ConditionSetting conditionSetting)
        {
            ReturnConditionSetting returnConditionSetting = new ReturnConditionSetting();

            try
            {
                using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
                {
                    using (SqlCommand cmd = new SqlCommand("", sqlConnection))
                    {
                        cmd.CommandText = "sp_tProductionControlList_InsertUpdate";
                        cmd.CommandType = CommandType.StoredProcedure;
                        cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value                = conditionSetting.ID;
                        cmd.Parameters.Add(new SqlParameter("@LineID", SqlDbType.VarChar)).Value        = conditionSetting.LineID;
                        cmd.Parameters.Add(new SqlParameter("@MachineTypeID", SqlDbType.VarChar)).Value = conditionSetting.MachineTypeID;
                        cmd.Parameters.Add(new SqlParameter("@PatternCode", SqlDbType.VarChar)).Value   = conditionSetting.PatternCode;
                        cmd.Parameters.Add(new SqlParameter("@ControlItem", SqlDbType.NVarChar)).Value  = conditionSetting.ControlItem;
                        cmd.Parameters.Add(new SqlParameter("@SpecDisplay", SqlDbType.NVarChar)).Value  = conditionSetting.SpecDisplay;
                        cmd.Parameters.Add(new SqlParameter("@Unit", SqlDbType.NVarChar)).Value         = conditionSetting.Unit;
                        cmd.Parameters.Add(new SqlParameter("@LowerLimit", SqlDbType.Float)).Value      = conditionSetting.LowerLimit;
                        cmd.Parameters.Add(new SqlParameter("@UpperLimit", SqlDbType.Float)).Value      = conditionSetting.UpperLimit;
                        cmd.ExecuteNonQuery();

                        returnConditionSetting.Code    = "00";
                        returnConditionSetting.Message = "Cập nhật dữ liệu thành công.";
                    }
                }
            }
            catch (Exception ex)
            {
                returnConditionSetting.Code                = "99";
                returnConditionSetting.Message             = "Lỗi xử lý dữ liệu: " + ex.ToString();
                returnConditionSetting.Total               = 0;
                returnConditionSetting.lstConditionSetting = null;
                mylog4net.Error("", ex);
            }
            return(returnConditionSetting);
        }
        public ReturnConditionSetting GetbyID(int ID)
        {
            List <ConditionSetting> lstConditionSetting    = null;
            ConditionSetting        conditionSetting       = null;
            ReturnConditionSetting  returnConditionSetting = new ReturnConditionSetting();

            try
            {
                using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
                {
                    using (SqlCommand cmd = new SqlCommand("", sqlConnection))
                    {
                        //cmd.Connection = _sqlConnection;
                        cmd.CommandText = "sp_tProductionControlList_SelectByID";
                        cmd.CommandType = CommandType.StoredProcedure;
                        cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = ID;

                        using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd, sqlConnection))
                        {
                            if (sqlDr.HasRows)
                            {
                                lstConditionSetting = new List <ConditionSetting>();
                                while (sqlDr.Read())
                                {
                                    conditionSetting                 = new ConditionSetting();
                                    conditionSetting.ID              = Convert.ToInt32(sqlDr["ID"].ToString());
                                    conditionSetting.LineID          = sqlDr["LineID"].ToString();
                                    conditionSetting.MachineTypeID   = Convert.ToInt32(sqlDr["MachineTypeID"].ToString());
                                    conditionSetting.MachineTypeName = sqlDr["TypeName"].ToString();
                                    conditionSetting.PatternCode     = sqlDr["PatternCode"].ToString();
                                    conditionSetting.ControlItem     = sqlDr["ControlItem"].ToString();
                                    conditionSetting.SpecDisplay     = sqlDr["SpecDisplay"].ToString();
                                    conditionSetting.Unit            = sqlDr["Unit"].ToString();
                                    conditionSetting.LowerLimit      = float.Parse(sqlDr["LowerLimit"].ToString());
                                    conditionSetting.UpperLimit      = float.Parse(sqlDr["UpperLimit"].ToString());

                                    lstConditionSetting.Add(conditionSetting);
                                }
                                returnConditionSetting.Code    = "00";
                                returnConditionSetting.Message = "Lấy dữ liệu thành công.";
                                //_ReturnTool.Total = Convert.ToInt32(cmd.Parameters["P_TOTAL"].Value.ToString());
                                returnConditionSetting.lstConditionSetting = lstConditionSetting;
                                //}
                            }
                            else
                            {
                                returnConditionSetting.Code                = "01";
                                returnConditionSetting.Message             = "Không tồn tại bản ghi nào.";
                                returnConditionSetting.Total               = 0;
                                returnConditionSetting.lstConditionSetting = null;
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                returnConditionSetting.Code                = "99";
                returnConditionSetting.Message             = "Lỗi xử lý dữ liệu: " + ex.ToString();
                returnConditionSetting.Total               = 0;
                returnConditionSetting.lstConditionSetting = null;
                mylog4net.Error("", ex);
            }
            return(returnConditionSetting);
        }